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.