Read, Insert, Update and Delete Users.

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.

For example, the following queries are processed server side:

SELECT * FROM Users WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the Name and email 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 Users (name, email, userrole) VALUES ('Test', '[email protected]', 'admin')

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 Users SET Name = 'test2', Email = '[email protected]' WHERE Id = '3285934000000136008'

Delete

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

DELETE FROM Users WHERE Id = '3350895000000089001'

Columns

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.