ProjectUsers
Retrieves list of users associated with a project. Also, get details of a user in project.
Table Specific Information
Select
The connector 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 connector.
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. | ||
| 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. |