Teams
Retrieve teams information specified in a sourcing project.
View-Specific Information
Select
The driver uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.
- Id supports the '=' comparison operator.
- ProjectId supports the '=' comparison operator.
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. |