JDBC Driver for Salesforce Marketing Cloud

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062