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.