Query order item properties.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the DraftOrderId column. The supported SQL operators are '=' for DraftOrderId. The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side.

SELECT * FROM DraftOrderItemProperties WHERE DraftOrderId = '123'

Columns

Name	Type	References	Description
ItemId	Long	DraftOrderItems.ItemId	The id of the order item.
DraftOrderId	Long	DraftOrders.Id	The id of the draft.
Name	String		The name of the item property.
Value	String		The value of the item property.