Publication
Reserved for future use.
View-Specific Information
Select
The driver 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 driver processes other filters client-side within the driver.
For example, the following (but not only) queries are processed server side:
SELECT * FROM Publication WHERE Id = 123 SELECT * FROM Publication WHERE Id IN (123, 456) SELECT * FROM Publication WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ID [KEY] | Int | Read-only identifier for an object. |
| PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| CreatedDate | Datetime | Read-only date and time of the object's creation. |
| ModifiedDate | Datetime | Indicates the last time object information was modified. |
| Client_ID | Int | The Id of the client. |
| Client_PartnerClientKey | String | User-defined partner key for an account. |
| Name | String | Name of the object or property. |
| Category | Int | ID of the folder that an item is located in. |