Cmdlets for Zoho Books

Build 24.0.8963

ProjectUsers

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

Table Specific Information

Select

The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

  • ProjectId supports the '=' comparison.
  • UserId supports the '=' comparison.

The rest of the filter is executed client-side in the 本製品.

For example:

    SELECT * FROM ProjectUsers WHERE ProjectId = '1894553000000072363' AND UserId = '1894553000000056001'

Columns

Name Type References SupportedOperators Description
ProjectId String

Projects.ProjectId

Id of a project.
UserId [KEY] String

Users.UserId

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

Users.RoleId

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963