MuleSoft Connector for Zoho Books

Build 20.0.7654


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

Table Specific Information


The connector 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 connector.

  • 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654