Indicates a single instance of an SMS triggered send. This table does not support deletes or updates.

Table-Specific Information

Select

The adapter 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 adapter processes other filters client-side within the adapter.

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

SELECT * FROM SMSTriggeredSend

SELECT * FROM SMSTriggeredSend WHERE ObjectID = 123

SELECT * FROM SMSTriggeredSend WHERE ObjectID IN (123, 456)

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

Insert

You must specify the following field when inserting to this table: SMSTriggeredSendDefinition_ObjectID.

INSERT INTO SMSTriggeredSend(SMSTriggeredSendDefinition_ObjectID) VALUES(123)

Columns