SSIS Components for Zoho Books

Build 22.0.8509


Retrieves list of all active items.

Table Specific Information


The component uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

  • TaxId supports the '=' comparison.
  • TaxName supports the '=' comparison.
  • Description supports the '=' comparison.
  • Name supports the '=' comparison.
  • Rate supports the '=,<,<=,>,>=' comparisons.
  • AccountId supports the '=' comparison.
  • Status supports the '=' comparison.

The rest of the filter is executed client-side in the component.

For example:

    SELECT * FROM Items WHERE Rate < 200 AND Rate > 24.9

    SELECT * FROM Items WHERE Description = '16' AND Name = 'Monitor'


Name Type References SupportedOperators Description
ItemId [KEY] String ID of an item.
ItemName String Name of an item.
ItemType String Type of item.
TaxId String


Id of a tax.
TaxName String Name of tax.
TaxPercentage Integer Tax percentage of item.
AccountName String Name of the account
Description String Description of an item.
HasAttachment Boolean Check if the items has attachment.
ImageDocumentId String ID of an image document.
Name String Name of an item.
Rate Decimal =,<,<=,>,>= Price of the item. Search items by rate.
ReorderLevel String Reorder level of the item.
Status String Status of the item.

The allowed values are All, Active, Inactive.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
AccountId String ID of the Bank Account to which the item has to be associated with.

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