TriggeredSendDefinition

Defines triggered send definitions in Salesforce Marketing Cloud. A triggered send definition establishes parameters for automatically sending emails to contacts who meet specified conditions or trigger events. The 'All Subscribers' list permission is required when using the default list for triggered sends.

Table-Specific Information

Select

The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.

For example, the following (but not only) queries are processed server side:

SELECT * FROM TriggeredSendDefinition WHERE ObjectID = 'nzxcaslkjd-123'

SELECT * FROM TriggeredSendDefinition WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')

SELECT * FROM TriggeredSendDefinition WHERE CreatedDate > '2017/01/25'

Insert

You must specify the following fields when inserting to this table: Name, SendClassification_ObjectID, and Email_Id.

INSERT INTO TriggeredSendDefinition (Name, SendClassification_ObjectID, Email_Id) VALUES ('Test', 'nzxcaslkjd-789', 123)

Update

You must specify the ObjectID in the WHERE clause when executing an update against this table.

UPDATE TriggeredSendDefinition SET Description = 'Changed' WHERE ObjectID = 'nzxcaslkjd-123'

Delete

You must specify the ObjectID in the WHERE clause when executing a delete against this table.

When deleting a row from this table, the row will not be deleted, but instead the value of TriggeredSendStatus will be set to false.

DELETE FROM TriggeredSendDefinition WHERE ObjectID = 'nzxcaslkjd-123'

Columns


Name	Type	ReadOnly	Description
ObjectID [KEY]	String	False	Specifies the system-controlled text string that serves as the unique identifier (Id) for the triggered-send definition record.
PartnerKey	String	False	Specifies the partner-supplied unique Id that is associated with the triggered-send definition and used exclusively for partner integrations.
CreatedDate	Datetime	False	Specifies the date and time when the triggered-send definition record was created. This value is read-only.
ModifiedDate	Datetime	False	Specifies the date and time when the triggered-send definition record was last modified. This value is read-only.
Client_ID	Long	False	Specifies the Id of the client account that owns the triggered-send definition.
CustomerKey	String	False	Specifies the user-supplied unique Id for the triggered-send definition within the object type.
Email_ID	Int	False	Specifies the Id of the associated email asset that is used when the triggered send is executed.
List_ID	Int	False	Specifies the Id of the subscriber list that is associated with the triggered send.
Name	String	False	Specifies the name that is assigned to the triggered-send definition.
Description	String	False	Provides descriptive information that explains the purpose or configuration of the triggered-send definition.
TriggeredSendType	String	False	[DEPRECATED] Indicates the triggered-send type.
TriggeredSendStatus	String	False	Specifies the status of the triggered send, which indicates whether the definition is active, paused, or otherwise restricted.
HeaderContentArea_ID	Int	False	Specifies the Id of the header content area that is associated with the triggered-send definition.
FooterContentArea_ID	Int	False	Specifies the Id of the footer content area that is associated with the triggered-send definition.
SendClassification_ObjectID	String	False	Specifies the system-controlled text string that serves as the Id of the send classification that is associated with the triggered-send definition.
SendClassification_CustomerKey	String	False	Specifies the customer key (Id) of the send classification that is linked to the triggered-send definition.
SenderProfile_CustomerKey	String	False	Specifies the customer key (Id) of the sender profile that is linked to the triggered-send definition.
SenderProfile_ObjectID	String	False	Specifies the system-controlled text string that serves as the Id of the sender profile that is associated with the triggered-send definition.
DeliveryProfile_CustomerKey	String	False	Specifies the customer key (Id) of the delivery profile that is associated with the triggered-send definition.
DeliveryProfile_ObjectID	String	False	Specifies the system-controlled text string that serves as the identifier (Id) of the delivery profile that is associated with the triggered-send definition.
PrivateDomain_ObjectID	String	False	Specifies the system-controlled text string that serves as the identifier (Id) of the private domain that is configured for the triggered send.
PrivateIP_ID	Int	True	Specifies the read-only identifier (Id) of the private internet protocol (IP) address that is assigned to the triggered send.
AutoAddSubscribers	Bool	False	Returns a value of 'true' when the triggered-send process automatically adds the recipient to a subscriber list. It returns a value of 'false' when the triggered-send process does not add the recipient to a subscriber list.
AutoUpdateSubscribers	Bool	False	Returns a value of 'true' when the triggered-send process updates existing subscriber information during send processing. It returns a value of 'false' when subscriber information is not updated.
BatchInterval	Int	False	[DEPRECATED] Indicates the batch-processing interval for bundled triggered sends.
FromName	String	False	Specifies the display name that is used in the 'From' field of the email message for the triggered send.
FromAddress	String	False	Specifies the email address that is used in the 'From' field when the triggered email is sent.
BccEmail	String	False	Specifies one or more email addresses that receive a blind-carbon copy (Bcc) of the triggered email message.
EmailSubject	String	False	Specifies the subject line that is used for the triggered-send email message.
DynamicEmailSubject	String	False	Specifies the dynamic subject-line content that is rendered at send time based on personalization or AMPscript logic.
IsMultipart	Bool	False	Returns a value of 'true' when the triggered-send email is delivered as a multipart MIME message. It returns a value of 'false' when the email is not delivered in multipart format.
IsWrapped	Bool	False	Returns a value of 'true' when the triggered-send email includes wrapped links that are required for click-tracking. It returns a value of 'false' when link wrapping is not applied.
TestEmailAddr	String	False	Specifies the test email address to which test versions of the triggered-send email can be delivered.
AllowedSlots	String	False	Specifies configuration data that defines delivery slot permissions or restrictions. This field is reserved for future functional expansion.
NewSlotTrigger	Int	False	[DEPRECATED] Indicates the configuration value that was previously used to control slot-trigger behavior for triggered sends.
SendLimit	Int	False	Specifies the maximum number of messages that can be delivered under the triggered-send definition within a defined send window.
SendWindowOpen	Datetime	False	Specifies the date and time when the allowed send window begins for the triggered-send definition.
SendWindowClose	Datetime	False	Specifies the date and time when the allowed send window ends for the triggered-send definition.
SuppressTracking	Bool	False	Returns a value of 'true' when the triggered-send definition suppresses tracking for opens, clicks, and other send events. It returns a value of 'false' when tracking is recorded normally.
Keyword	String	False	Specifies a keyword value that is reserved for future functionality within triggered-send processing.
List_PartnerKey	String	False	Specifies the partner-supplied unique Id that is associated with the referenced list object and available only through partner integrations.
Email_PartnerKey	String	False	Specifies the partner-supplied unique Id that is associated with the referenced email asset and available only through partner integrations.
SendClassification_PartnerKey	String	False	Specifies the partner-supplied unique Id that is associated with the send classification and available only through partner integrations.
PrivateDomain_PartnerKey	String	True	Specifies the partner-supplied unique Id that is associated with the private domain configuration and available only through partner integrations.
PrivateIP_PartnerKey	String	True	Specifies the partner-supplied unique Id that is associated with the private IP address configuration and available only through partner integrations.
Client_PartnerClientKey	String	False	Specifies the user-defined partner key (Id) that is assigned to the client account for integration or tracking purposes.
IsPlatformObject	Bool	False	Returns a value of 'true' when the triggered-send definition is a platform-managed object. It returns a value of 'false' when the triggered-send definition is not classified as a platform object.
CategoryID	Int	False	Specifies the Id of the folder that contains the triggered-send definition within the account's organizational hierarchy.