ODBC Driver for Zoho Projects

Build 22.0.8389

TeamUsers

Fetch details of a particular team.

Select

  • GroupId is required to retrieve Team Users.
You can use the below query to get all Team Users:
SELECT * FROM TeamUsers WHERE GroupId = '123456000000033021'

Insert

To create a new Team you must specify the following fields:

  • GroupId
  • Zpuid


INSERT INTO TeamUsers (GroupId, ZPUID)
VALUES ('123456000000034163', '123456000000031003')

Delete

TeamUsers can be deleted by providing the GroupId and Id and issuing a DELETE statement.

DELETE FROM TeamUsers WHERE GroupId = '123456000000034163' AND Id = '123456000000031003'

Columns

Name Type ReadOnly Description
ProjectId String False

Project Id.

GroupId String False

Team Id.

Id [KEY] String False

User Id.

Name String False

User Name.

AddedBy String False

User Added By.

AddedTime String False

User Added Time.

Confirmed String False

User Confirmed.

CreatedBy String False

User Created By.

CreatedTime String False

User Created Time.

CreatedUser String False

User Created User.

Description String False

User Description.

DisplayName String False

User Display Name.

Email String False

User Email.

EntityType String False

User Entity Type.

FirstName String False

User First Name.

IsClient Boolean False

User Is Client.

IsDefault Boolean False

User Is Default.

LastAccessedTime String False

User Last Accessed Time.

LastName String False

User Last Name.

LastUpdatedTime String False

User Last Updated Time.

RoleId String False

User Role Id.

RoleName String False

User Role Name.

Type String False

User Type.

UpdatedBy String False

User Updated By.

UpdatedDate String False

User Updated Date.

UpdatedDateTime String False

User Updated Date Time.

UserStatus String False

User User Status.

Zpuid String False

User Zpuid.

Zuid String False

User Zuid.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8389