SSIS Components for Zoho Books

Build 22.0.8509

Items

Retrieves list of all active items.

Table Specific Information

Select

The 本製品 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 本製品.

For example:

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

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

Columns

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

Taxes.TaxId

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.

使用できる値は次のとおりです。All, Active, Inactive

Pseudo-Columns

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