Users
List, Insert, Update, 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
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Id of the user | |
| String | False |
email address of the user | ||
| IsCurrentUser | Boolean | True |
check if user is activated or not | |
| Name | String | False |
name of the user | |
| PhotoUrl | String | True |
PhotoUrl | |
| RoleId | String | True |
RoleId | |
| Status | String | True |
Status | |
| UserRole | String | False |
UserRole | |
| UserType | String | True |
Usertype | |
| AssociatedClients | String | True |
Associated clients. | |
| BillingRate | Double | True |
Billing rate. | |
| CreatedTime | Datetime | True |
Time the user was created. | |
| CustomFieldHash | String | True |
Hash of custom fields. | |
| CustomFields | String | True |
Custom fields. | |
| EmailIds | String | True |
Email IDs. | |
| IsAccountant | Boolean | True |
Whether the user is an accountant. | |
| Role | String | True |
Role of the user. | |
| Roles | String | True |
Roles assigned to the user. | |
| SegmentationDetails | String | True |
Segmentation details. | |
| Source | String | True |
Source. | |
| IsAssociatedForApproval | Boolean | True |
Whether the user is associated for approval. | |
| IsAssociatedWithOrgEmail | Boolean | True |
Whether the user is associated with the organization email. |
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.
| Name | Type | Description |
| UserFilter | String |
Criteria used to filter |