CollectionProducts
Retrieves a list of the products inside of a collection.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the CollectionId 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 CollectionProducts WHERE CollectionId='VALUE'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Globally unique identifier. | |
| CollectionId | String |
Collections.Id | A globally-unique identifier for the collection. |
| Title | String | The title of the product. | |
| Position | Int | The position in which the products are sorted. |