SSIS Components for TaxJar

Build 21.0.7930

OrderLineItems

Lists existing order transactions

Select

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

  • TransactionDate support the following operators: <,<=,=,>,>=
  • TransactionID support 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 component will retrieve data of the last 3 months.
  • StartDate connection property is set. The component 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'
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930