SMSTriggeredSend
Indicates a single instance of an SMS triggered send. This table does not support deletes or updates.
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 |
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. |