JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves list of users associated with a project. Also, get details of a user in project.

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

  • ProjectId supports the '=' comparison.
  • UserId supports the '=' comparison.
For example:
    SELECT * FROM ProjectUsers WHERE ProjectId = '1894553000000072363' AND UserId = '1894553000000056001'


Name Type References SupportedOperators Description
ProjectId String


Id of a project.
UserId [KEY] String


Id of the user.
IsCurrentUser Boolean Check if it is a current user.
UserName String Username of the project users.
Email String Email ID of user.
UserRole String Role of the user in project.
RoleId String


ID of the role.
Status String Status of the project user.
Rate Decimal Hourly rate for a task.
BudgetHours Integer Total number of hours alloted to the user for the project.
BudgetHoursInTime String Time of total number of hours alloted to the user for the project.
TotalHours String Total number of hours to be spent in project.
BilledHours String Total number of billed hours to be spent in project.
UnBilledHours String Total number of unbilled hours spent in project.
BillableHours String Total number of billable hours spent in project.
NonBillableHours String Total number of non billable hours spent in project.
StaffRole String Role of staff in project.
StaffStatus String Status of staff in project.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479