SSIS Components for Azure DevOps

Build 24.0.9060

CommitWorkItems

Retrieve work items for the specific commit, sliced across all repositories.

Table Specific Information

Select

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

  • ProjectId supports the '=' operator.
  • RepositoryId supports the '=' operator.
  • CommitId supports the '=' operator.
The rest of the filter is executed client-side in the component.


NOTE: RepositoryId and CommitId are required in order to query CommitWorkItems.

For example:

	SELECT * FROM CommitWorkItems WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND CommitId = '01832416d11f521e2e8fa1dc3acd9aebd93c773f'

Columns

Name Type References Description
Id [KEY] String Id of the work item.
ProjectId String Id of the project.
RepositoryId String

Repositories.Id

Id of the repository.
CommitId String

Commits.Id

Id of the commit.
Url String URL of the work item.

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