Retrieve teams information specified in a sourcing project.

View-Specific Information

Select

The connector uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.

• Id supports the '=' comparison operator.
• ProjectId supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM Teams WHERE Id = 'PG17371157'

SELECT * FROM Teams WHERE ProjectId = 'WS12345'

Update

The list of users and groups in a project team can be updated by executing UPDATE statements. Note that this Replaces all users or groups in the team with the users or groups specified in the request body.

Users and groups cannot be updated in the same statement.

For example:

UPDATE Teams SET Users='[{"uniqueName":"test","passwordAdapter":"pass"}]' WHERE ProjectId='WS12345' AND Id='PG14510'
UPDATE Teams SET ChildGroups='[{"uniqueName":"testGroup"}]' WHERE ProjectId='WS12345' AND Id='PG14510'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		Specifies the unique name for the project group.
Name	String	False		Specifies the name for the project group.
NameDefaultTranslation	String	False		Specifies the default translation for project group's name.
Type	String	False		Specifies if team is of type ProjectGroup or GlobalGroup.
Roles	String	False		Specifies the roles assigned to this project group.
IsGlobal	Bool	False		Indicates whether the group is a global group defined for the entire site. If true, this is a global group.
IsDeletable	Bool	False		Indicates whether the group can be deleted. If true, this group can be deleted.
IsEditable	Bool	False		Indicates whether the group can be edited. If true, this group can be edited.
IsOwner	Bool	False		Indicates whether the group has Project Owner capabilities. If true, this group has Project Owner capabilities.
Users	String	False		Specifies the users in this project group.
ChildGroups	String	False		Specifies the child groups defined for this project group.
ProjectId [KEY]	String	False	Projects.InternalId	Specify the unique identifier of the sourcing project for which you want to fetch task details. Example, Try it out with: WS17371155.