CreateTriggeredSend

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

Table Specific Information

Subscriber Attributes

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

INSERT INTO Subscribers#Temp(Order_Number,Order_Status,Purchase_Date) VALUES (1234,'received','2015-06-30 11:10:36.956')

EXECUTE CreateTriggeredSend  key='TEST_1', FromAddress='test123@salesforce.com', FromName='test', ToAddress='arctest42@gmail.com',SubscriberKey='12345678', Subscribers='Subscribers#Temp'

Execute

you can execute the stored procedure.

EXECUTE CreateTriggeredSend  key='TEST_1', FromAddress='test123@salesforce.com', FromName='test', ToAddress='arctest42@gmail.com',SubscriberKey='12345678'

EXECUTE CreateTriggeredSend  key='TEST_1', FromAddress='test123@salesforce.com', FromName='test', ToAddress='arctest42@gmail.com', SubscriberKey='12345678', SubscriberAttributes='{\"attrname\":\"test\",\"attrname2\":22,\"attrname3\":\"testing\"}'

Input


Name	Type	Required	Description
Key	String	False	Defines associated triggered send definition for triggered send. This property corresponds to the external key assigned to an object in Marketing Cloud.
SendId	String	False	ID of the entry event send definition that comes from the response when creating a TriggeredSendDefinition. Either this or the external key is required.
FromAddress	String	False	Email address that will show as the sender.
FromName	String	False	Name of the sender.
ToAddress	String	True	Email address of the message recipient.
SubscriberKey	String	True	Unique identifier defined for the message recipient.
SubscriberAttributes	String	False	Name and value pairs for subscriber attributes defined for the message.
RequestType	String	False	Valid values ASYNC and SYNC. Default value when not defined is ASYNC. Determines if the request is processed asychronously.

Result Set Columns