JDBC Driver for Salesforce Marketing Cloud

Build 24.0.9062

SuppressionListContext

Defines a context that a SuppressionListDefinition can be associated with.

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 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.

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