Cmdlets for Zoho Books

Build 24.0.8963

Employees

Retrieves list of employees. Also, get the details of an employee.

Table Specific Information

Select

The 本製品 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 本製品.

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.
Email 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.

使用できる値は次のとおりです。All, Billable, Nonbillable, Reimbursed, Invoiced, Unbilled

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963