Power BI Connector for Zoho Inventory

Build 24.0.9062

ItemGroupsItems

List items of Item Groups.

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 ItemGroupsItems WHERE Id = '3350895000000089001'

Columns

Name Type References Description
GroupId Long

ItemGroups.Id

Id of the Item Group
Name String Name of the Item.
Rate Double Sales price of the Item.
PurchaseRate Double Purchase price of the Item.
ReorderLevel Double Reorder level of the item.
InitialStock Double The opening stock of the item.
InitialStockRate Double The opening stock value of the item.
VendorId Long Unique ID generated by the server for the Vendor.
Sku String The Stock Keeeping Unit (SKU) of an item.
Upc Long The 12 digit Unique Product Code (UPC) of the item.
Ean Long Unique EAN value for the Item.
Isbn Long Unique ISBN value for the Item.
PartNumber String Part Number of the Item.
AttributeOptionName1 Long Name of the attribute option.

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