ADO.NET Provider for Zoho Books

Build 22.0.8479

Items

Retrieves list of all active items.

Table Specific Information

Select

The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • 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.
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.8479