Fetch the team details from the portal.

Select

You can use the below query to get all Teams:

SELECT * FROM Teams

Following columns support '=' operator:

• Id
• LastUpdatedTime
• SearchTerm

• Columns that support server-side ORDER BY: Name

Insert

Name, UserIds, LeadId columns are required to create a new Team.

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

• Name
• Email
• UserIds
• ProjectIds
• LeadId
• Notify

INSERT INTO Teams (Name, UserIds, LeadId, ProjectIds)
VALUES ('TestTeam5', '["123456000000031003", "123456000000032055"]', '123456000000032055', '["123456000000031899"]'

Update

To update a Team specify the Id field.

UPDATE Teams
SET LeadId = '123456000000031003', 
	UserIds = '["123456000000031003", "123456000000032055"]',
	ProjectIds = '["123456000000031899"]', 
	Name = 'TestTeam5' 
WHERE Id = '123456000000036001'

Delete

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

DELETE FROM Teams WHERE Id = '123456000000044025' 

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Long	True	Team Id.
Name	String	False	Team Name.
Email	String	False	Team Email.
CreatedById	Long	True	Team Created By Id.
CreatedByName	String	True	Team Created By Name.
CreatedByEmail	String	True	Team Created By Email.
CreatedByZuid	Long	True	Team Created By Zuid.
CreatedTime	Datetime	True	Team Created Time.
LastUpdatedTime	Datetime	True	Team Last Updated Time.
UpdatedById	Long	True	Team Updated By Id.
UpdatedByName	String	True	Team Updated By Name.
UpdatedByEmail	String	True	Team Updated By Email.
UpdatedByZuid	Long	True	Team Updated By Zuid.
EmailVerified	Boolean	True	Team Email Verified.
LeadId	Long	False	Team Lead Id.
LeadName	String	True	Team Lead Name.
LeadEmail	String	True	Team Lead Email.
LeadZuid	Long	True	Team Lead Zuid.
AddedVia	String	True	Team Added Via.
AssociatedServices	String	True	Team Associated Services.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
SearchTerm	String	A search term to filter teams by name.
UserIds	String	Array of IDs of the users to add or update to the team.
ProjectIds	String	Array of IDs of the projects to update or associate with the team.
Notify	String	Specify whether to notify the team members about the update or creation.