Excel Add-In for Salesforce Marketing Cloud

Build 20.0.7695

CreateTriggeredSend

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

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

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='test@gmail.com.com', TriggeredSendDefinitionCustomerKey='27775'

Input

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) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695