List

Represents subscriber lists in Salesforce Marketing Cloud. A list defines a group of subscribers that share common attributes or purposes, such as newsletter recipients or event registrants. This table supports list management operations including queries, inserts, and updates.

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 List WHERE Id = 123

SELECT * FROM List WHERE Id IN (123, 456)

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

Insert

You must specify the following field when inserting to this table: ListName.

INSERT INTO List (ListName) VALUES ('Test')

Update

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

UPDATE List SET ListName = 'Changed' WHERE Id = 123

Delete

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

DELETE FROM List WHERE Id = 123

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Int	False	Specifies the identifier (Id) that uniquely identifies the list.
ObjectID	String	False	Specifies the system-controlled text string Id that is assigned to the list object for internal tracking.
PartnerKey	String	False	Specifies the unique Id that is provided by a partner for the list when it is accessed through the API.
CreatedDate	Datetime	False	Indicates the date and time when the list was created.
ModifiedDate	Datetime	False	Indicates the date and time when information about the list was last modified.
Client_ID	Int	False	Specifies the Id of the client that owns or manages the list.
Client_PartnerClientKey	String	False	Specifies the partner-defined client key that is associated with the account.
ListName	String	False	Specifies the name that is assigned to the list.
Description	String	False	Provides descriptive information about the purpose, use case, or contents of the list.
Category	Int	False	Specifies the Id of the folder where the list is stored within the account's folder structure.
Type	String	False	Specifies the type of list. Valid values include 'Public', 'Private', 'Salesforce', 'GlobalUnsubscribe', and 'Master'.
CustomerKey	String	False	Specifies the user-supplied unique Id for the list within the list object type.
ListClassification	String	True	Specifies the classification that defines how the list behaves within Salesforce Marketing Cloud Cloud, such as for subscription management or audience segmentation.
AutomatedEmail_ID	Int	False	Specifies the Id of the automated email configuration that is associated with this list.