Excel Add-In for Shopify

Build 24.0.9060

DraftOrderItemTaxLines

Query draft order items tax lines.

View-Specific Information

The add-in uses the Shopify API to process search criteria that refer to the DraftOrderId. The supported SQL operators are '=' for DraftOrderId. The add-in processes other filters client-side within the add-in. For example, the following queries are processed server-side.

Select


SELECT * FROM DraftOrderTaxItems WHERE DraftOrderId = '123'

Columns

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

DraftOrderItems.ItemId

The id of the draft line item.
DraftOrderId Long

DraftOrders.Id

The id of the draft.
TaxTitle String The name of the tax.
TaxRate Decimal The rate of tax to be applied.
TaxPrice Decimal The amount of tax to be charged.

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