JDBC Driver for Shopify

Build 24.0.9060

ProductOptions

Returns a list of product options. The limit is specified by Shop.resourceLimits.maxProductOptions.

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.

  • ProductId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM ProductOptions
  SELECT * FROM ProductOptions WHERE ProductId = 'Val1'

Columns

Name Type References Description
Id [KEY] String A globally-unique identifier.
ProductId String

Products.Id

A globally-unique identifier.
Name String The product option's name.
Position Int The product option's position.
Values String The corresponding value to the product option name.

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