Power BI Connector for Zoho Inventory

Build 24.0.9062

ItemGroups

Read, Insert, Update adn Delete 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 ItemGroups WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the GroupName and Unit 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 ItemGroups (GroupName, Unit, Brand) VALUES ('Bags', 'qty', 'Website') 

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 ItemGroups SET GroupName = 'Ra', unit = 'qty' WHERE GroupId = '3285934000000163005'

Delete

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

DELETE FROM ItemGroups WHERE Id = '3350895000000089001'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Id of the Item Group

AttributeId1 Long True

Id of the attribute present in the Item Group

AttributeName1 String False

Name of the attribute present in the Item Group

Brand String False

Brand of the Item Group

CreatedTime Datetime True

Time at which item group was created.

Description String False

Description of the Item Group

GroupName String False

Name of the Item Group

ImageId Long True

Id of the image.

ImageName String True

Name of the image.

ImageType String True

Type of the image.

IsTaxable Boolean True

Flag to determine if item group is taxable.

LastModifiedTime Datetime True

Last modified time of item group

Manufacturer String False

Manufacturer of item group

ProductType String True

Product type of item group.

Source String True

Source of item group.

Status String True

Status of item group.

TaxExemptionId Long True

Tax exemption id of item group.

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

Tax name of item group.

TaxPercentage Integer True

Tax percentage of item group.

TaxType String True

Tax type of item group.

Unit String False

Unit of item group.

Items String False

Aggreagate items of item group.

Attributes String False

Aggreagate attributes of item group.

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