SSIS Components for Salesforce Marketing Cloud

Build 24.0.9062

SMSMTEvent

Contains information on a specific SMS message sent to a subscriber.

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 SMSMTEvent WHERE ObjectID = 'nzxcaslkjd-123'

SELECT * FROM SMSMTEvent WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')

SELECT * FROM SMSMTEvent WHERE CreatedDate > '2017/01/25'

Columns

Name Type Description
ObjectID [KEY] String System-controlled, read-only text string identifier for object.
EventDate Datetime Date when a tracking event occurred.
Client_ID Long The Id of the client.
MOCode String Specifies the MO code associated with a specific MO or MT tracking event.
SMSTriggeredSend_SMSSendId String Indicates ID for a specific SMS send.
SMSTriggeredSend_SMSTriggeredSendDefinition_ObjectID String System-controlled, read-only text string identifier for object.
SMSTriggeredSend_SMSTriggeredSendDefinition_CustomerKey String User-supplied unique identifier for an object within an object type.
Subscriber_ID Int Read-only identifier for an object.
Subscriber_SubscriberKey String Identification of a specific subscriber.
Subscriber_PrimarySMSAddress_Address String The primary SMS address of the subscribers.
Carrier String Name of the SMS carrier associated with an SMS address.

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