List, Insert, Update, delete CompositeItems Bundles

Table Specific Information

Select

The add-in 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 add-in.

• 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

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.