SubscriberList
Use to retrieve lists for a specific subscriber.
View-Specific Information
Select
The provider 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 provider processes other filters client-side within the provider.
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 | Identifier for an object. |
| ID [KEY] | Int | Identifier for an object. |
| PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| CreatedDate | Datetime | date and time of the object's creation. |
| Subscriber_UnsubscribedDate | Datetime | The unsubscribed date of the subscriber. |
| Client_ID | Int | The Id of the client. |
| Status | String | Defines status of object. |
| List_ID | Int | Identifier for an object. |
| List_ListName | String | The name of the list. |
| Subscriber_Status | String | Defines status of object. |
| Subscriber_CreatedDate | Datetime | Indicates the date and time of the object's creation. |
| Subscriber_ID | Int | identifier for an object. |
| Subscriber_EmailAddress | String | The email address of a subscriber. |
| Subscriber_SubscriberKey | String | Identification of a specific subscriber. |
| Subscriber_PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |