Publication
Represents publication-level configuration details that support managing how subscriber-facing content is organized and distributed in Salesforce Marketing Cloud. This view provides structural information that describes publication settings, visibility rules, and relationships used in content distribution workflows.
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 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 | Specifies the system-defined identifier (Id) that uniquely identifies the publication within the account. |
| PartnerKey | String | Provides a unique Id that is supplied by an external partner system and is available only through API access. This value enables system-to-system correlation when multiple platforms exchange publication metadata. |
| CreatedDate | Datetime | Specifies the read-only date and time when the publication was initially created. |
| ModifiedDate | Datetime | Specifies the date and time when the publication record was most recently modified. |
| Client_ID | Int | Specifies the Id of the client account that owns or manages the publication. |
| Client_PartnerClientKey | String | Specifies the partner-supplied key that associates the publication with a specific client context for integration or reporting purposes. |
| Name | String | Specifies the user-defined name of the publication. The name appears in configuration tools and API responses to help users identify the publication. |
| Category | Int | Specifies the Id of the folder in which the publication is stored. This categorization helps organize publication assets within the account's folder hierarchy. |