Query order taxes.

View-Specific Information

The driver 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 driver processes other filters client-side within the driver. For example, the following queries are processed server side.

Select

SELECT * FROM TaxItems

SELECT * FROM TaxItems WHERE OrderId = '123'

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

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.

Columns

Name	Type	References	Description
OrderId	Long	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.
ChannelLiable	Boolean		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.