ODBC Driver for Shopify

Build 24.0.9060

CollectionProducts

Retrieves a list of the products inside of a collection.

View-Specific Information

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060