Query product options.

View-Specific Information

The driver uses the Shopify API to process search criteria that refer to the ProductId and ProductUpdatedAt columns. The supported SQL operators are '=' for ProductId and '>' and '<' for ProductUpdatedAt. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

Select

SELECT * FROM ProductOptions

SELECT * FROM ProductOptions WHERE ProductId='123'

SELECT * FROM ProductOptions WHERE ProductUpdatedAt > '2018-05-10'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns

Name	Type	References	Description
Id [KEY]	Long		The id of the product option.
ProductId	Long	Products.Id	The id of the product.
ProductUpdatedAt	Datetime		The date and time when the product was last modified.
Name	String		The name of the product option.
Position	Integer		The position of the product option.
Values	String		The values of the product option.