CreateTriggeredSend

Creates a triggered send object in Salesforce Marketing Cloud. A triggered send represents a specific instance of an automated email send that is initiated by an API event or system trigger. This procedure allows real-time delivery of personalized messages.

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	Specifies the external key that identifies the triggered send definition that is associated with the triggered send operation. This value determines which configured definition the system should use when creating the triggered send object.
Owner_ClientId	String	False	Specifies the identifier (Id) of the account that owns the triggered send. This value determines the business unit context in which the triggered send is created and executed.
Owner_FromAddress	String	False	Specifies the email address that appears in the 'From' field of the triggered send. This value establishes the sender identity shown to recipients.
Owner_FromName	String	False	Specifies the 'From Name' value that is associated with the triggered send. This value provides the display name that accompanies the 'From' address in outbound messages.

Result Set Columns


Name	Type	Description
Success	Boolean	Returns a value of 'true' when the triggered send object is created successfully. It returns a value of 'false' when the creation request encounters an error or fails validation.