Employees
Retrieves list of employees. Also, get the details of an employee.
Table Specific Information
Select
The add-in uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- EmployeeId supports the '=' comparison.
- Status supports the '=' comparison.
The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM Employees WHERE EmployeeId = '1894553000000068001' AND Status = 'All'
Columns
| Name | Type | References | SupportedOperators | Description |
| EmployeeId [KEY] | String | Id of an employee. | ||
| Name | String | Name of an employee. | ||
| String | Email address of an employee. |
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.
| Name | Type | Description | |
| Status | String | Filter employee based on the status.
The allowed values are All, Billable, Nonbillable, Reimbursed, Invoiced, Unbilled. |