MuleSoft Connector for Salesforce Marketing Cloud

Build 20.0.7654


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

Table Specific Information


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','')
INSERT INTO Subscribers#Temp(SubscriberKey,EmailAddress) VALUES ('21621cc5-d12e-46d0-bf09-a429da29ef1a','')


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')


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

EXECUTE CreateTriggeredSend Owner_ClientId='7307527', Owner_FromName='From_Name', Owner_FromAddress='', TriggeredSendDefinitionCustomerKey='27775'


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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654