SMSSharedKeyword
Contains information used to request a keyword for use with SMS messages in a Marketing Cloud account.
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 SMSSharedKeyword WHERE Client_ID = 123 SELECT * FROM SMSSharedKeyword WHERE Client_ID IN (123, 456) SELECT * FROM SMSSharedKeyword WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| CreatedDate | Datetime | Read-only date and time of the object's creation. |
| ModifiedDate | Datetime | Indicates the last time object information was modified. |
| Client_ID | Long | The Id of the client. |
| SharedKeyword | String | Specifies keyword requested for use in an account. |
| RequestDate | Datetime | Specifies the date when the request for an SMS shared keyword was made. |
| EffectiveDate | Datetime | Specifies when an SMS shared keyword becomes active for use. |
| ExpireDate | Datetime | Specifies when an SMS shared keyword stops being active for use. |
| ReturnToPoolDate | Datetime | Specifies the date when an expired SMS keyword can be requested for different use in a short code. |
| ShortCode | String | Specifies the short code for which an SMS keyword was requested. |