SSIS Components for SAP Ariba Source

Build 24.0.9060

Teams

Retrieve teams information specified in a sourcing project.

View-Specific Information

Select

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

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060