The CData ODBC Driver for Shopify models entities in the Shopify API as tables, views, and stored procedures. These are defined in schema files, which are simple, text-based configuration files that are easy to customize.

Key Features

• Include Custom Fields connection property allows you to retrieve custom fields for Products and ProductVariants table. Set this property to True, to enable this feature.
• The Row Scan Depth connection property sets the number of rows that are filtered for custom fields. The default value for this property is 50. There is a trade-off: setting a low value may result in not getting all the custom fields, but setting a high value decreases the driver's performance. To use this feature set the Include Custom Fields connection property to True.
• The Flexible Schema retrieves custom fields for the Products and ProductVariants table. This feature is enabled when the Include Custom Fields connection property is set to True. Flexible schema searches at most 250 rows for custom fields. To retrieve more fields, set the Row Scan Depth to a higher value.

Using Rest API

See REST Data Model for the available entities in the REST API.

Using GraphQL API

See GRAPHQL Data Model for the available entities in the GraphQL API.