JDBC Driver for Avalara

Build 22.0.8462


Items table for AvalaraAvatax data provider.


The driver will use the Avalara API to process WHERE clause conditions built with the following columns and operators. Most of the columns support server side filtering with the following operators: =,>,<,<=,>=,IN,NOT,IN,AND,OR,LIKE. The rest of the filter is executed client side within the driver. For example, the following query is processed server side:

SELECT * FROM Items WHERE CompanyId = 247015 AND Description LIKE '%MUG'
SELECT * FROM Items WHERE CompanyId = 247015 AND ModifiedUserId IN (289767, 1354)


To add an Item.

INSERT INTO Items (companyId,itemCode,taxCode,description,itemGroup) VALUES ('247015','CERMUG1','P0000000','Ceramic Mug','Mugs')")

In order to add an item with ItemsClassifications #TEMP table should be used

INSERT INTO Itemsclassifications#TEMP (productCode,systemCode) VALUES ('P0000000','TARIC')")
INSERT INTO Items (companyId,itemCode,taxCode,description,itemGroup,Linkedclassifications) VALUES ('247015','CERMUG','P0000000','Ceramic Mug','Mugs','Itemsclassifications#TEMP')")
INSERT INTO Items (companyId,itemCode,taxCode,description,itemGroup) VALUES ('247015','CERMUG1','P0000000','Ceramic Mug','Mugs')")


Avalara allows updates to Items columns.

UPDATE Items SET Description = 'description',itemcode = 'CERMUG' WHERE Id = '189117938' AND CompanyId = '247015'

In order to update ItemsClassifications, a #TEMP table should be used.

INSERT INTO Itemsclassifications#TEMP (systemcode,productcode) VALUES ('P0000001','AVATAXCEDE')")
UPDATE items SET description = 'description',itemcode = 'CERMUG',linkedclassifications = 'Itemsclassifications#TEMP' WHERE id = '189117938' AND companyId = '247015'")


Items can be deleted by providing the Id of the address and issuing a DELETE statement.



Name Type ReadOnly Description
Id [KEY] Int False

The unique ID number of this item.

CompanyId [KEY] Int False

The unique ID number of the company that owns this item.

ItemCode String False

A unique code representing this item.

ModifiedUserId Int False

The user ID of the user who last modified this record.

LinkedClassifications String False

List of classifications that belong to this item. A single classification consists of a productCode and a systemCode for a particular item.

CreatedUserId Int False

The User ID of the user who created this record.

ItemGroup String False

A way to group similar items.

ModifiedDate Datetime False

The date/time when this record was last modified.

Description String False

A friendly description of this item in your product catalog.

LinkedParameters String False

List of item parameters.

CreatedDate Datetime False

The date when this record was created.

TaxCode String False

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