Retrieve team user information specified in a sourcing project.

View-Specific Information

Select

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

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

For example, the following queries are processed server side:

SELECT * FROM TeamUsers WHERE TeamId = 'PG17371157'

SELECT * FROM TeamUsers WHERE ProjectId = 'WS12345'

Insert

Users can be added to a specific project team by executing INSERT statements. A user is uniquely identified by a combination of uniqueName and passwordAdapter. For example:

INSERT INTO TeamUsers (UniqueName,PasswordAdapter, TeamId) VALUES ('testName','1234','100')

Columns

Name	Type	ReadOnly	References	Description
TeamId [KEY]	String	False	Teams.Id	Specifies the unique identifier of the project group.
TeamName	String	False		Specifies the name of the project group.
TeamType	String	False		Specifies the type of the project group. Possible values- ProjectGroup, GlobalGroup.
Type	String	False		Specifies the user type.
Name	String	False		Specifies the full name of the user.
UniqueName [KEY]	String	False		Specifies the unique name of the user.
PasswordAdapter	String	False		Specifies the password adapter of the user.
EmailAddress	String	False		Specifies the email address of the user.
TimeZoneId	String	False		Specifies time zone for the user. Example: Asia/Kolkata.
Organization	String	False		Specifies the organization name of the user.
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.