Excel Add-In for Zoho Projects

Build 23.0.8839

Teams

Fetch the team details from the portal.

Select

You can use the below query to get all Teams:
SELECT * FROM Teams

Insert

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

  • GroupName
  • EmailAlias
  • UserIdArr
  • ProjIds
  • TeamLead


INSERT INTO Teams (GroupName, UserIdArr, TeamLead, ProjIds)" +
VALUES ('TestTeam5', '["123456000000031003", "123456000000032055"]', '123456000000032055', '["123456000000031899"]

Update

To update a Team specify the GroupId field.

UPDATE Teams
SET TeamLead = '123456000000031003', 
	UserIdArr = '["123456000000031003", "123456000000032055"]',
	ProjIds = '["123456000000031899"]', 
	GroupName = 'TestTeam5' 
WHERE GroupId = '123456000000036001'

Delete

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

DELETE FROM Teams WHERE GroupId = '123456000000044025' 

Columns

Name Type ReadOnly Description
GroupId [KEY] String False

Group Id of the team.

GroupName String False

Group Name of the team.

CreatedBy String False

Team Created By.

CreatedTime String False

Created Time of the team.

Description String False

Description of the team.

EmailAlias String False

Email Id of the team.

EmailVerified Boolean False

Email Verified of the team.

OrgId String False

Organization Id of the team.

OwnerEmail String False

Owner Email of the team.

OwnerName String False

Owner Name of the team.

OwnerZpuid String False

Owner Zpuid of the team.

OwnerZuid String False

Owner Zuid of the team.

Prefix String False

Prefix of the team.

UpdatedBy String False

Updated By of the team.

UpdatedTime String False

Updated Time of the team.

HasGroupEdit Boolean False

Has Group Edit of the team.

ProjectCount Integer False

Project Count of the team.

UserCount Integer False

User Count of the team.

UserIdArr String False

Array of multiple Zpuid.

UserObj String False

User Object of the team.

ProjIds String False

Array of multiple project Ids.

TeamLead String False

ZPuid of the team lead.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839