ADO.NET Provider for Zoho Books

Build 22.0.8462

ProjectUsers

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

Table Specific Information

Select

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

  • ProjectId supports the '=' comparison.
  • UserId supports the '=' comparison.
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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462