Retrieves list of employees. Also, get the details of an employee.
Table Specific Information
The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
- EmployeeId supports the '=' comparison.
- Status supports the '=' comparison.
SELECT * FROM Employees WHERE EmployeeId = '1894553000000068001' AND Status='All'
|EmployeeId [KEY]||String||Id of an employee.|
|Name||String||Name of an employee.|
|String||Email address of an employee.|
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.
|Status||String||Filter employee based on the status.
使用できる値は次のとおりです。All, Billable, Nonbillable, Reimbursed, Invoiced, Unbilled