JDBC Driver for TaxJar

Build 22.0.8462

RefundLineItems

Lists line items of an order transactions.

Select

The driver 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 driver.

  • 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 driver will retrieve data of the last 3 months.
  • StartDate connection property is set. The driver 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462