DraftOrderItemProperties
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. 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.
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. |