ProjectUsers

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

Table Specific Information

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

The rest of the filter is executed client-side in the component.

For example:

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


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.