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 following columns and operators. The connector processes other filters client-side within the connector.
- CollectionId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM CollectionProducts
SELECT * FROM CollectionProducts WHERE CollectionId = 'Val1'
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. |