ListSubscriber
Retrieves subscriber relationships for lists in Salesforce Marketing Cloud. Each record shows which lists a subscriber belongs to or which subscribers are assigned to a list. This view supports subscription management and audience segmentation reporting.
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 ListSubscriber WHERE Id = 123 SELECT * FROM ListSubscriber WHERE Id IN (123, 456) SELECT * FROM ListSubscriber WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ID [KEY] | Int | Specifies the read-only identifier (Id) that uniquely identifies the list-subscriber record. |
| ObjectID | String | Specifies the system-controlled text string that the platform generates to identify this list-subscriber record. |
| SubscriberKey | String | Specifies the unique subscriber key that identifies the individual subscriber associated with the list entry. |
| CreatedDate | Datetime | Specifies the read-only date and time when the list-subscriber record was created. |
| ModifiedDate | Datetime | Indicates the date and time when the list-subscriber record was last modified. |
| Client_ID | Int | Specifies the Id of the client that owns or manages the subscriber and list association. |
| Client_PartnerClientKey | String | Specifies the user-defined partner key that is associated with the client for integration or partner tracking. |
| ListID | Int | Specifies the Id of the list on which the subscriber resides. |
| Status | String | Specifies the current subscription status for the subscriber on the list (for example, 'Active', 'Unsubscribed', or 'Held'). |
| UnsubscribedDate | Datetime | Specifies the date and time when the subscriber unsubscribed from the list. |