Power BI Connector for Zoho Inventory

Build 24.0.9062

Items

Read, Insert, Update and Delete Items.

Table Specific Information

Select

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

  • Id supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Items WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the Name column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Items (Name) VALUES ('testitem11') 

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Items SET Name = 'updated name' WHERE Id = '3350895000000090009'

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example:

DELETE FROM Items WHERE Id = '3350895000000089001'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Unique ID generated by the server for the group to which the item belongs, if any. This is used as an identifier.

ActualAvailableStock Integer True

Stock based on Shipments and Receives minus ordered stock.

AccountName String True

Name of the Sales Account.

AttributeId1 Long False

Unique ID used by the server. This is used as an identifier.

AttributeName1 String False

Name of the attribute present in the Item Group.

AttributeOptionId1 Long True

Unique ID generated by the server for the attribute options. This is used as an identifier.

AttributeOptionName1 String True

Name of the attribute option.

AvailableStock Integer True

Stock based on Shipments and Receives.

CreatedTime Datetime True

Time at which item was created.

Description String False

Description of the Item.

Documents String False

Documents of the Item.

Ean Long True

Unique EAN value for the Item.

GroupId Long False

Unique ID generated by the server for the group to which the item belongs, if any. This is used as an identifier.

GroupName String False

Name of product group.

HsnOrSac Integer True

HSN Code of the item

ImageName String True

Image name of the Item.

ImageType String True

Type of the image i.e., its file format.

InventoryAccountId Long False

Unique ID generated by the server for the Inventory account.

IsComboProduct Boolean True

Flag to determine is the item part of combo.

IsLinkedWithZohocrm Boolean True

Flag to determine if product is linked with ZohoCRM

Name String False

Name of the Item.

IsTaxable Boolean False

Boolean to track the taxability of the item.

Isbn Long True

Unique ISBN value for the Item.

ItemType String False

Item type can be inventory, sales, purchases or sales_and_purchases. If item is associated with a group, then type should be inventory.

LastModifiedTime Datetime True

Time at which item was last modified.

PartNumber String True

Part Number of the Item.

ProductType String False

Type of the product. It can be goods or service

PurchaseDescription String True

The description for the purchase information. This will be displayed to the vendor in your purchase order.

PurchaseAccountId Long False

Unique ID generated by the server for the Purchase account.

PurchaseAccountName String False

Name of the Purchase Account.

PurchaseRate Integer False

Purchase price of the Item.

Rate Integer False

Sales price of the Item.

ReorderLevel Integer False

Reorder level of the item.

Sku String True

The Stock Keeeping Unit (SKU) of an item. This is unique for every item in the Inventory.

Source String True

The source of the Item Group.

Status String True

Status of the Item Group.

StockOnHand Integer True

Stock available for a particular item.

TaxId Long False

Unique ID generated by the server for the tax associated with the item. This is used a unique identifier.

TaxName String True

Name of the tax applied on the Item Group.

TaxPercentage Integer True

Percentage of the Tax.

TaxType String True

Type of the Tax.

ItemTaxPreferences String False

Item Tax Preference.

Upc Long True

The 12 digit Unique Product Code (UPC) of the item.

Unit String False

Unit of measurement for the item.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062