SuppressionListDefinition

Represents suppression lists in Salesforce Marketing Cloud. A suppression list defines subscribers who should be excluded from specific sends or publications. Each record can be associated with one or more suppression contexts to enforce message exclusions.

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

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

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

Insert

You must specify the following fields when inserting to this table: Name.

INSERT INTO SuppressionListDefinition (Name) VALUES ('Test')

Update

You must specify the ObjectID in the WHERE clause when executing an update against this table.

UPDATE SuppressionListDefinition SET Name = 'Changed' WHERE ObjectID = 'nzxcaslkjd-123'

Delete

You must specify the ObjectID in the WHERE clause when executing a delete against this table.

DELETE FROM SuppressionListDefinition WHERE ObjectID = 'nzxcaslkjd-123'

Columns


Name	Type	ReadOnly	Description
ObjectID	String	False	Specifies the system-controlled text string that serves as the unique identifier (Id) for the suppression-list definition. This Id is read-only and is generated internally.
CustomerKey	String	False	Specifies the user-supplied unique Id for the suppression-list definition. This value provides an external reference that is used for integration, retrieval, and configuration tasks.
Name	String	False	Defines the name that is assigned to the suppression-list definition. This value helps users identify the definition within the user interface and automation workflows.
Description	String	False	Describes the purpose, scope, or functional behavior of the suppression-list definition. This description helps users understand how and when the list should be applied.
Client_CreatedBy	Int	False	Returns the Id of the user who created the suppression-list definition. This value supports auditing and administrative tracking.
CreatedDate	Datetime	False	Indicates the date and time when the suppression-list definition was created. This timestamp supports chronological tracking of configuration changes.
Client_ModifiedBy	Int	False	Returns the Id of the user who most recently modified the suppression-list definition. This value supports administrative oversight and auditing.
ModifiedDate	Datetime	False	Indicates the date and time when the suppression-list definition was last modified. This timestamp reflects the most recent update to its configuration.
Category	Long	False	Specifies the folder Id that is used to organize the suppression-list definition within the account's folder structure. This value supports navigation and access control.
Client_ID	Int	False	Specifies the Id of the client that owns or manages the suppression-list definition. This Id links the definition to the appropriate account.
Client_EnterpriseID	Long	False	Specifies the enterprise-level Id that is associated with the client. This value is reserved for future enterprise-level functionality.
SubscriberCount	Long	False	Indicates the number of subscriber records that are currently stored on the suppression list. This value helps assess the size and impact of the list within send operations.