CreateTriggeredSend

Create a triggered send object which represents a specific instance of a triggered email send.

Table Specific Information

Subscribers

You cannot create a trigger send without specifying the subscribers. To create subscribers, you must insert data in a temporary table called 'Subscribers#TEMP'.

Example: Create two subscribers

INSERT INTO Subscribers#TEMP (SubscriberKey, EmailAddress) VALUES ('a4367b39-d7d6-4612-a020-0952aa9e83dd', '[email protected]')
INSERT INTO Subscribers#TEMP (SubscriberKey, EmailAddress) VALUES ('21621cc5-d12e-46d0-bf09-a429da29ef1a', '[email protected]')

Attributes

To create attributes, you must insert data in a temporary table called 'Attributes#TEMP'.

Example: Create two attributes

INSERT INTO Attributes#TEMP (Name, Value) VALUES ('orderstatus', 'received')
INSERT INTO Attributes#TEMP (Name, Value) VALUES ('orderdate', '2015-06-30 11:10:36.956')

Execute

After creating at least one subscriber item, you can execute the stored procedure.

EXECUTE CreateTriggeredSend Owner_ClientId = '7307527', Owner_FromName = 'From_Name', Owner_FromAddress = '[email protected]', TriggeredSendDefinitionCustomerKey = '27775'

Input


Name	Type	Required	Description
TriggeredSendDefinitionCustomerKey	String	True	Defines associated triggered send definition for triggered send. This property corresponds to the external key assigned to an object in Marketing Cloud.
Owner_ClientId	String	False	Specifies the account ownership and context of an object.
Owner_FromAddress	String	False	Indicates From address associated with a object.
Owner_FromName	String	False	Specifies the default email message From Name.

Result Set Columns


Name	Type	Description
Success	Boolean	Whether the triggered send object was created successfully or not.