PublicationProducts
Returns the list of publication for products.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the PublicationId column, which supports the '=' comparison operator.
The connector processes other filters client-side within the connector.
For example, the following query is processed server-side:
SELECT * FROM PublicationProducts WHERE PublicationId='VALUE'
Columns
| Name | Type | References | Description |
| ProductId [KEY] | String | A globally-unique ID. | |
| PublishDate | Datetime | The date that the resource publication was or is going to be published to the publication. | |
| IsPublished | Bool | Whether the resource publication is published. | |
| PublicationId [KEY] | String | A globally-unique ID. | |
| PublicationName | String | Name of the publication. |