Lists line items of an order transactions.

Select

The add-in will use the TaxJar API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.

• TransactionDate supports the following operators: <,<=,=,>,>=
• TransactionID supports the following operators: =,IN
• Provider supports the following operator: = (By default the Provider is set to "api" which means that only data that has been created from the API will be retrieved.)

For the following query:

SELECT * FROM TableName

We have these 2 cases:

• StartDate connection property is not set. The add-in will retrieve data of the last 3 months.
• StartDate connection property is set. The add-in will retrieve data from the StartDate specified, until today.

The following queries are processed server side:

    SELECT * FROM TableName WHERE TransactionID = '200'
    SELECT * FROM TableName WHERE Provider = 'ebay'
    SELECT * FROM TableName WHERE TransactionID IN ('123', '122')
    SELECT * FROM TableName WHERE TransactionDate <= '2020/05/15' AND TransactionDate >= '2014/05/15'
    SELECT * FROM TableName WHERE TransactionDate < '2015/05/15' AND TransactionDate > '2014/05/15'
    SELECT * FROM TableName WHERE TransactionDate < '2015/05/15'
    SELECT * FROM TableName WHERE TransactionDate > '2015/05/15'
    SELECT * FROM TableName WHERE TransactionDate >= '2015/05/15'
    SELECT * FROM TableName WHERE TransactionDate = '2015/05/15'

Columns

Name	Type	Description
TransactionID [KEY]	String	Unique identifier of the given order transaction.
TransactionDate	Date	The date/time the transaction was originally recorded.
Provider	String	Source of where the transaction was originally recorded.
ID [KEY]	String	Unique identifier of the given line item.
Quantity	Int	Quantity for the item.
ProductIdentifier	String	Product identifier for the item.
Description	String	Description of the line item (up to 255 characters).
ProductTaxCode	String	Product tax code for the item.
UnitPrice	Double	Unit price for the item in dollars.
Discount	Double	Total discount (non-unit) for the item in dollars.
SalesTax	Double	Total sales tax collected (non-unit) for the item in dollars.