Power BI Connector for Shopify

Build 24.0.9060

TaxItems

Query order taxes.

View-Specific Information

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

Select


SELECT * FROM TaxItems WHERE OrderId = '123'

SELECT * FROM TaxItems WHERE OrderUpdatedAt > '2018-05-21'

Columns

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

Orders.Id

The id of the order.
OrderUpdatedAt Datetime The date and time when the order was last modified.
ChannelLiable Bool Whether the channel that submitted the tax line is liable for remitting.
TaxItemPrice Decimal The amount of tax to be charged.
TaxItemRate Decimal The rate of tax to be applied.
TaxItemTitle String The name of the tax.

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