Power BI Connector for Zoho Inventory

Build 24.0.9062

CompositeItemsBundles

Read,Insert, Update and Delete CompositeItemsBundles.

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.
  • CompositeItemId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CompositeItemsBundles WHERE Id = '3350895000000089001'

SELECT * FROM CompositeItemsBundles WHERE CompositeItemId = '23350895000000089001'

Insert

Insert can be executed by specifying the ReferenceNumber, Date, Description, CompositeItemId, CompositeItemName, IsCompleted, QuantityToBundle and LineItems 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 CompositeItemsBundles (ReferenceNumber, Date, Description, CompositeItemId, CompositeItemName, IsCompleted, QuantityToBundle, LineItems) VALUES (124, '22-02-22', 'desc', 123, 'name', 'true', 12, '[ {\"item_id\": 3285934000000104097, \"quantity\": 3}]') 

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 CompositeItemsBundles SET Name = 'test2' WHERE Id = '3285934000000136008'

Delete

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

DELETE FROM CompositeItemsBundles WHERE Id = '3350895000000089001'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Id of Bundle

IsCompleted Boolean False

Denotes the status of the bundle. Currently, this has to be true since we didnt support any other status as of now.

CompositeItemId Long False

CompositeItems.Id

Unique ID generated for the composite item by the server.

CompositeItemName String False

Name of the composite item

CompositeItemSku String False

Stock Keeping Unit value of the composite item.

Date Date False

The date on which bundling is done

Description String False

Sample Description.

LineItems String False

A bundle can contain multiple line items.

QuantityToBundle Integer False

Quantity of bundles to be bundled.

ReferenceNumber String False

Reference number for the Bundle.

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