JDBC Driver for Salesforce Marketing Cloud

Build 24.0.9062

SMSTriggeredSendDefinition

Defines the send definition for an SMS message.

View-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 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 System-controlled, read-only text string identifier for object.
CustomerKey String User-supplied unique identifier for an object within an object type.
Client_ID Long The Id of the client.
Name String Name of the object or property.
Description String Describes and provides information regarding the object.
Publication_ID Int Read-only identifier for an object.
CreatedDate Datetime Read-only date and time of the object's creation.
ModifiedDate Datetime Indicates the last time object information was modified.
Content_ID Int Read-only identifier for an object.
SendToList Bool Indicates whether SMS triggered send goes to a list or a single subscriber.
DataExtension_ObjectID String System-controlled, read-only text string identifier for object.
IsPlatformObject Bool Indicated whether the object is a platform object.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062