SMSTriggeredSend

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

Table-Specific Information

Select

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

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

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


Name	Type	ReadOnly	Description
ObjectID [KEY]	String	False	System-controlled, text string identifier for object.
CreatedDate	Datetime	False	Indicates the date and time of the object's creation.
Client_ID	Int	False	The Id of the client.
SmsSendId	String	False	Indicates ID for a specific SMS send.
SMSTriggeredSendDefinition_ObjectID	String	False	System-controlled, text string identifier for object.

JDBC Driver for Salesforce Marketing Cloud

SMSTriggeredSend

Table-Specific Information

Select

Insert

Columns