SMSTriggeredSendDefinition
Defines Short Message Service (SMS) triggered send definitions in Salesforce Marketing Cloud. Each definition includes message templates, target audiences, and sending parameters. This view supports auditing and configuration validation for automated SMS workflows.
View-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 SMSTriggeredSendDefinition WHERE ObjectID = 'nzxcaslkjd-123'
SELECT * FROM SMSTriggeredSendDefinition WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')
SELECT * FROM SMSTriggeredSendDefinition WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | Specifies the system-controlled, read-only text string that serves as the unique identifier (Id) for the Short Message Service (SMS) triggered-send definition. This Id is generated automatically and is used to reference the definition within the system. |
| CustomerKey | String | Specifies the user-supplied unique Id for the triggered-send definition within its object type. This Id enables consistent identification across API operations and user interface components. |
| Client_ID | Long | Specifies the Id of the client. This Id associates the triggered-send definition with the correct Marketing Cloud account context. |
| Name | String | Specifies the name of the triggered-send definition. This value is displayed in the user interface and is used to distinguish this definition from other definitions. |
| Description | String | Describes and provides detailed information regarding the triggered-send definition. This text helps users understand the purpose, configuration, and functional context of the definition. |
| Publication_ID | Int | Specifies the read-only Id of the publication that is associated with the triggered-send definition. This Id links the definition to the appropriate SMS program or publication list. |
| CreatedDate | Datetime | Indicates the read-only date and time of the object's creation. This timestamp is generated automatically when the triggered-send definition is added to the system. |
| ModifiedDate | Datetime | Indicates the last time the triggered-send definition was modified. This timestamp reflects the most recent administrative or configuration update. |
| Content_ID | Int | Specifies the read-only Id of the content asset that is associated with the triggered-send definition. This Id identifies the SMS message content that is used during the triggered-send process. |
| SendToList | Bool | Returns a value of 'true' when the SMS triggered send is configured to send to a list instead of an individual subscriber. It returns a value of 'false' when the send is directed to a single subscriber rather than a list. |
| DataExtension_ObjectID | String | Specifies the system-controlled, read-only text string that serves as the Id of the data extension used as the target for the triggered send. This Id identifies the data source that supplies subscriber data for the send operation. |
| IsPlatformObject | Bool | Returns a value of 'true' when the triggered-send definition represents a platform-level object that is used across multiple account contexts. It returns a value of 'false' when the object is scoped only to the local business unit or account. |