Power BI Connector for Salesforce Marketing Cloud

Build 25.0.9454

SuppressionListContext

Defines the context within which a suppression list can be associated in Salesforce Marketing Cloud. Each context determines the scope of a suppression list, such as a specific business unit, publication, or message type.

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 Specifies the system-controlled text string that serves as the unique identifier (Id) for the suppression-list context record. This Id is read-only and is generated internally.
Definition_ObjectID String Specifies the system-controlled text string that serves as the Id of the suppression-list definition that is associated with this context. This Id is read-only and is generated internally.
Definition_Name String Defines the name that is assigned to the suppression-list definition that is associated with this context. This value helps identify the definition within configuration workflows.
Definition_CustomerKey String Specifies the user-supplied unique Id for the suppression-list definition that is associated with this context. This value provides an external reference for integration, retrieval, or configuration tasks.
Definition_Category Long Identifies the folder category in which the suppression-list definition is stored. This value supports organization, access control, and hierarchical navigation.
Definition_Description String Describes the purpose, scope, or functional details of the suppression-list definition that is associated with this context. This description helps users understand how the definition is intended to be used.
Context String Specifies the context that is assigned to the suppression-list definition, such as its usage scenario or scope of application. This value determines when and where the suppression list is applied.
SendClassification_ObjectID String Specifies the system-controlled text string that serves as the Id of the send classification that is associated with the suppression-list context. This Id is read-only and is generated internally.
Send_ID Int Specifies the Id of the send to which this suppression-list context applies. This Id is read-only and is used to link the context to a specific send record.
SenderProfile_ObjectID String Specifies the system-controlled text string that serves as the Id of the sender profile associated with this suppression-list context. This Id is read-only and is generated internally.
SendClassificationType String Defines the type of the associated send classification that is used with this suppression-list context. Valid values include 'Operational' and 'Marketing', which determine how the suppression rules are enforced.
Client_CreatedBy Int Returns the Id of the user who created the suppression-list context record. This Id supports auditing and administrative tracking.
CreatedDate Datetime Indicates the date and time when the suppression-list context record was created. This value provides chronological tracking for configuration changes.
Client_ModifiedBy Int Returns the Id of the user who most recently modified the suppression-list context record. This Id supports auditing and administrative oversight.
ModifiedDate Datetime Indicates the date and time when the suppression-list context record was last modified. This timestamp reflects the most recent update to configuration details.
Client_ID Long Specifies the Id of the client that owns or manages the suppression-list context. This Id links the context to the correct account.
Client_EnterpriseID Long Specifies the enterprise-level Id that is associated with the client.
AppliesToAllSends Bool Returns a value of 'true' when the suppression-list context applies to all transactional and marketing sends for the client. It returns a value of 'false' when the suppression-list context applies only to specific sends or classifications.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454