SMSTriggeredSend
Represents individual instances of Short Message Service (SMS) triggered sends in Salesforce Marketing Cloud. Each record corresponds to a message sent as part of a triggered send definition. This table does not support deletes or updates to preserve historical send data.
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 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 |
Specifies the system-controlled text string that serves as the unique identifier (Id) for the Short Message Service (SMS) triggered-send record. This Id is generated automatically and provides a stable reference for the object. |
| CreatedDate | Datetime | False |
Indicates the date and time of the object's creation. This timestamp is generated by the system to record when the SMS triggered-send record was first added. |
| Client_ID | Int | False |
Specifies the Id of the client. This Id associates the SMS triggered-send record with the correct Marketing Cloud account context. |
| SmsSendId | String | False |
Specifies the Id for a specific SMS send that is associated with the triggered-send process. This Id links the mobile message activity to the corresponding triggered-send definition and execution. |
| SMSTriggeredSendDefinition_ObjectID | String | False |
Specifies the system-controlled text string that is used as the Id of the SMS triggered-send definition. This value identifies the configuration that dictates how the triggered SMS message is constructed and delivered. |