SuppressionListContext
Defines a context that a SuppressionListDefinition can be associated with.
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 SuppressionListContext WHERE Id = 123 SELECT * FROM SuppressionListContext WHERE Id IN (123, 456) SELECT * FROM SuppressionListContext WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | System-controlled, read-only text string identifier for object. |
| Definition_ObjectID | String | System-controlled, read-only text string identifier for object. |
| Definition_Name | String | Name of the object or property. |
| Definition_CustomerKey | String | User-supplied unique identifier for an object within an object type. |
| Definition_Category | Long | The category of the defition. |
| Definition_Description | String | Describes and provides information regarding the object. |
| Context | String | The context with which a SuppressionListDefinition is associated. |
| SendClassification_ObjectID | String | System-controlled, read-only text string identifier for object. |
| Send_ID | Int | Read-only identifier for an object. |
| SenderProfile_ObjectID | String | System-controlled, read-only text string identifier for object. |
| SendClassificationType | String | Defines the type for the applicable send classification. Valid values include Operational and Marketing. |
| Client_CreatedBy | Int | Returns user ID for user who created object |
| CreatedDate | Datetime | Read-only date and time of the object's creation. |
| Client_ModifiedBy | Int | Returns user ID for user who modified object. |
| ModifiedDate | Datetime | Indicates the last time object information was modified. |
| Client_ID | Long | The Id of the client. |
| Client_EnterpriseID | Long | Reserved for future use. |
| AppliesToAllSends | Bool | Indicates whether this context applies to all transactional and marketing sends. |