SubscriberList
Retrieves the lists that are associated with a specific subscriber in Salesforce Marketing Cloud. Each record links a subscriber to one or more lists to support segmentation, subscription tracking, and campaign targeting.
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 SubscriberList WHERE Id = 123 SELECT * FROM SubscriberList WHERE Id IN (123, 456) SELECT * FROM SubscriberList WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ListSubID | Long | Specifies the unique identifier (Id) for the subscriber-list association record. This Id identifies the specific linkage between a subscriber and a list. |
| ID [KEY] | Int | Specifies the Id for the list-subscriber record. This Id uniquely identifies the object within the Marketing Cloud environment. |
| PartnerKey | String | Specifies the partner-supplied key that is associated with the object as part of an external integration. This key is accessible only through the API. |
| CreatedDate | Datetime | Specifies the date and time when the list-subscriber record was created. This value is read only and is set automatically by the system. |
| Subscriber_UnsubscribedDate | Datetime | Specifies the date and time when the subscriber unsubscribed from the associated list. This value allows downstream processes to evaluate historical opt-out activity. |
| Client_ID | Int | Specifies the Id of the client account that owns the list-subscriber record. This Id determines the account context in which the object exists and is managed. |
| Status | String | Specifies the status that is associated with the list-subscriber relationship (for example, Active, Unsubscribed, or Held). This value reflects how the subscriber is treated for future sends. |
| List_ID | Int | Specifies the Id of the list to which the subscriber is associated. This Id identifies the specific list that defines the audience membership. |
| List_ListName | String | Specifies the name of the list that is associated with the subscriber. This value is used for identification, reporting, and user-interface display. |
| Subscriber_Status | String | Specifies the status that is associated with the subscriber within the context of this list. This value can differ from the subscriber's global status. |
| Subscriber_CreatedDate | Datetime | Specifies the date and time when the subscriber record was created in the system. This value provides historical context for segmentation and reporting. |
| Subscriber_ID | Int | Specifies the Id of the subscriber. This Id uniquely identifies the subscriber object within the Salesforce Marketing Cloud account. |
| Subscriber_EmailAddress | String | Specifies the email address that is associated with the subscriber. This address represents the primary communication channel for email sends. |
| Subscriber_SubscriberKey | String | Specifies the subscriber key that uniquely identifies a subscriber across multiple lists, business units, and data sources. This key is required for all send-related operations. |
| Subscriber_PartnerKey | String | Specifies the partner-provided key for the subscriber, which is used for external system correlation. This key is accessible only through the API. |