Retrieve all project groups from the Zoho Projects portal.

Select

You can use the below query to get all ProjectGroups:

SELECT * FROM ProjectGroups

Insert

To create a new ProjectGroup you can use the below query:

INSERT INTO ProjectGroups (name) VALUES ('New Project Group')

Update

To update a ProjectGroup specify the Id field.

UPDATE ProjectGroups SET Name = 'NewName' WHERE Id = '165818000000045001'

Delete

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

DELETE FROM ProjectGroups WHERE Id = '123456000000045018'  

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Long	True	Project Group Id.
Name	String	False	Project Group Name.
IsDefault	Boolean	True	Is Default Project Group.
Prefix	String	False	Project Group Prefix.
Type	String	False	Project Group Type.
Sequence	Integer	True	Project Group Sequence.
AssociatedProjects	Integer	True	Project Group Associated Projects.
HasEditAccess	Boolean	True	Has Edit Access.