Items
Retrieves list of all active items.
Table Specific Information
Select
The connector 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 connector.
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 | ||
| SKU | String | The SKU of the Item. | ||
| CanBePurchased | Boolean | Check if the item can be purchased. | ||
| CanBeSold | Boolean | Check if the items can be sold. | ||
| CreatedTime | Datetime | Time at which the item was created. | ||
| ImageName | String | Name of the image. | ||
| ImageType | String | MIME type or format of the item's image. | ||
| IsLinkedWithZohoCRM | Boolean | Indicates if the Item is linked with Zoho CRM. | ||
| LastModifiedTime | Datetime | The time of last modification of the item. | ||
| ProductType | String | Type of the product. | ||
| PurchaseAccountId | String |
BankAccounts.AccountId | Account Id of purchase items. | |
| PurchaseAccountName | String | Account name of purchase items. | ||
| PurchaseDescription | String | Description of purchase items. | ||
| PurchaseRate | Decimal | Rate of purchase items. | ||
| Source | String | Source of the item. | ||
| Tags | String | Details of tags related to items. | ||
| TrackInventory | Boolean | Check if the item can be tracked | ||
| Unit | String | Number of quantity of item. | ||
| ZcrmProductId | String | ZCRM Product Id of the item. |
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. |