CData Python Connector for Shopify

Build 23.0.8839

OrderItemProperties

Query order item properties.

View-Specific Information

Select

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

For example, the following queries are processed server-side. You can set the Type pseudo column to "DraftOrder" to list order items belonging to draft orders instead of orders, or you can set Type to "AbandonedCheckout" to list order items belonging to abandoned checkouts.

SELECT * FROM OrderItemProperties WHERE OrderId = '123'

Columns

Name Type References Description
LineNumber [KEY] Long A unique numeric identifier for the table.
ItemId Long

OrdersItems.ItemId

The id of the order item. Only available for orders.
OrderId Long

Orders.Id

The id of the order.
Name String The name of the item property.
Value String The value of the item property.
OrderUpdatedAt Datetime The date and time when the order was last modified.

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