Employees
Retrieves list of employees. Also, get the details of an employee.
Table Specific Information
Select
The server uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- Status supports the '=' comparison.
The rest of the filter is executed client-side in the server.
For example:
SELECT * FROM Employees WHERE 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. |