TriggeredSendDefinition

To create or update a TriggeredSendDefinition where the list ID is the All Subs List ID, you need the Email | Subscribers | All Subscribers | View and SendEmailToList permissions.

Table-Specific Information

Select

The driver 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 driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.

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

SELECT * FROM TriggeredSendDefinition

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	System-controlled, text string identifier for object.
PartnerKey	String	False	Unique identifier provided by partner for an object, accessible only via API.
CreatedDate	Datetime	False	Indicates the date and time of the object's creation.
ModifiedDate	Datetime	False	Indicates the last time object information was modified.
Client_ID	Long	False	The Id of the client.
CustomerKey	String	False	User-supplied unique identifier for an object within an object type.
Email_ID	Int	False	Identifier for an object.
List_ID	Int	False	Identifier for an object.
Name	String	False	Name of the object or property.
Description	String	False	Describes and provides information regarding the object.
TriggeredSendType	String	False	Deprecated.
TriggeredSendStatus	String	False	Represents status of triggered send.
HeaderContentArea_ID	Int	False	Identifier for an object.
FooterContentArea_ID	Int	False	Identifier for an object.
SendClassification_ObjectID	String	False	System-controlled, text string identifier for object.
SendClassification_CustomerKey	String	False	The customer key of the send classification.
SenderProfile_CustomerKey	String	False	The customer key of the sender profile.
SenderProfile_ObjectID	String	False	System-controlled, text string identifier for object.
DeliveryProfile_CustomerKey	String	False	The customer key of the delivery profile.
DeliveryProfile_ObjectID	String	False	System-controlled, text string identifier for object.
PrivateDomain_ObjectID	String	False	System-controlled, text string identifier for object.
PrivateIP_ID	Int	True	Read-only identifier for an object.
AutoAddSubscribers	Bool	False	Indicates whether a triggered send recipient should be added to a subscriber list.
AutoUpdateSubscribers	Bool	False	Indicates if any subscriber information should be updated as part of a triggered send.
BatchInterval	Int	False	Deprecated.
FromName	String	False	Specifies the default email message From Name.
FromAddress	String	False	Indicates From address associated with a object.
BccEmail	String	False	Indicates email addresses to receive blind carbon copy of a message.
EmailSubject	String	False	Subject for an email send.
DynamicEmailSubject	String	False	Contains content to be used in a dynamic subject line.
IsMultipart	Bool	False	Indicates whether the email is sent with Multipart/MIME enabled.
IsWrapped	Bool	False	Indicates whether an email send contains the links necessary to process tracking information for clicks.
TestEmailAddr	String	False	Specified a test email address.
AllowedSlots	String	False	Reserved for future use.
NewSlotTrigger	Int	False	Deprecated.
SendLimit	Int	False	Indicates limit of messages to send as part of a send definition within a predefined send window.
SendWindowOpen	Datetime	False	Defines the beginning of a send window for a send definition.
SendWindowClose	Datetime	False	Defines the end of a send window for a send definition.
SuppressTracking	Bool	False	Indicates whether the send definition suppresses tracking results for associated sends.
Keyword	String	False	Reserved for future use.
List_PartnerKey	String	False	Unique identifier provided by partner for an object, accessible only via API.
Email_PartnerKey	String	False	Unique identifier provided by partner for an object, accessible only via API.
SendClassification_PartnerKey	String	False	Unique identifier provided by partner for an object, accessible only via API.
PrivateDomain_PartnerKey	String	True	Unique identifier provided by partner for an object, accessible only via API.
PrivateIP_PartnerKey	String	True	Unique identifier provided by partner for an object, accessible only via API.
Client_PartnerClientKey	String	False	User-defined partner key for an account.
IsPlatformObject	Bool	False	Indicated whether the object is a platform object.
CategoryID	Int	False	Specifies the identifier of the folder containing the email.