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='[email protected]', FromName='test', ToAddress='[email protected]',SubscriberKey='12345678', Subscribers='Subscribers#Temp'
Execute
you can execute the stored procedure.
EXECUTE CreateTriggeredSend key='TEST_1', FromAddress='[email protected]', FromName='test', ToAddress='[email protected]',SubscriberKey='12345678'
EXECUTE CreateTriggeredSend key='TEST_1', FromAddress='[email protected]', FromName='test', ToAddress='[email protected]', 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
Name | Type | Description |
Success | String | Returns True if triggered is created successfully otherwise return false. |
RecipientSendId | String | Recipient Send Id generated when event send definition triggered successfully. |
Messages | String | Defines the detailed description of the messages. |