PublicationSubscriber
Describes subscriber on a publication list.
View-Specific Information
Select
The adapter 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 adapter processes other filters client-side within the adapter.
For example, the following (but not only) queries are processed server side:
SELECT * FROM PublicationSubscriber SELECT * FROM PublicationSubscriber WHERE Publication_ID = 123 SELECT * FROM PublicationSubscriber WHERE Publication_ID IN (123, 456) SELECT * FROM PublicationSubscriber WHERE Publication_CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| Publication_ID | Int | Read-only identifier for an object. |
| Publication_PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| Publication_CreatedDate | Datetime | Read-only date and time of the object's creation. |
| Publication_ModifiedDate | Datetime | Indicates the last time object information was modified. |
| Publication_Client_ID | Int | Read-only identifier for an object. |
| Publication_Client_PartnerClientKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| Client_ID | Int | The Id of the client. |
| Client_PartnerClientKey | String | User-defined partner key for an account. |
| Publication_Name | String | Name of the object or property. |
| Publication_Category | Int | The category of the publication. |
| Subscriber_ID | Int | Read-only identifier for an object. |
| Subscriber_SubscriberKey | String | Identification of a specific subscriber. |
| Subscriber_PrimarySMSAddress_AddressType | String | The address type of the subscriber. |
| Subscriber_PrimarySMSAddress_Address | String | The address of the subscriber. |
| Subscriber_PrimarySMSAddress_Carrier | String | The carrier of the subscriber. |
| Subscriber_PrimarySMSPublicationStatus | String | The primary SMS publication status of the subscriber. |