BizTalk Adapter for Zoho Books

Build 20.0.7654

ItemDetails

Retrieves details of an existing item.

Table Specific Information

Select

The {i 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 {i.
Note: ItemId is required in order to query ItemDetails.

  • ItemId supports the '=' comparison.
For example:
    SELECT * FROM ItemDetails WHERE ItemId = '1894553000000079049'

Columns

Name Type References SupportedOperators Description
ItemId [KEY] String

Items.ItemId

ID of an item.
ItemType String Type of an item.
AccountId String

BankAccounts.AccountId

ID of the Bank Account.
AccountName String Name of the account.
Brand String Brand of the item.
CreatedTime Datetime Time at which the item was created.
Description String Description of an item.
ImageName String Name of the image.
LastModifiedTime Datetime The time of last modification of the item.
Manufacturer String Company that makes goods for sale.
Name String Name of an item.
PricebookRate Decimal Rate of pricebook.
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.
Rate Decimal Rate of the item.
SalesChannels String Total channels exists for sales.
SalesRate Decimal The rate of sale in the item.
Sku String Stock Keeping Unit value of item, should be unique throughout the product.
Source String Source of the item.
Status String Status of the item.
Tags String Details of tags related to items.
TaxId String

Taxes.TaxId

Id of tax.
TaxName String Name of the tax.
TaxPercentage Integer Percentage applied for tax.
TaxType String Type of tax.
Unit String Number of quantity of item.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654