SSIS Components for Azure DevOps

Build 24.0.9060

TaskGroupSourceDefinitions

Retrieves a list of source definitions for the specific task group.

Table Specific Information

Select

The component uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • TaskGroupId supports the '=' operator.
  • ProjectId supports the '=' operator.

The rest of the filter is executed client-side in the component.

NOTE: TaskGroupId is required in order to query TaskGroupSourceDefinitions.

For example:

	SELECT * FROM TaskGroupSourceDefinitions WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND TaskGroupId = 7

Columns

Name Type References Description
ProjectId String Id of the project.
TaskGroupId [KEY] Integer

TaskGroups.Id

Id of the taskgroup.
AuthKey String Auth key of the source definition.
Endpoint String Source definition endpoint.
Selector String Source definition selector.
Target String Source definition target.

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