SSIS Components for Azure DevOps

Build 24.0.9060

CommitChanges

Retrieve changes for a particular 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.

For example:

    SELECT * FROM CommitChanges WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND CommitId = '01832416d11f521e2e8fa1dc3acd9aebd93c773f'
	SELECT * FROM CommitChanges WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND CommitId = '01832416d11f521e2e8fa1dc3acd9aebd93c773f'

Columns

Name Type References Description
CommitId String

Commits.Id

Id of the commit.
ProjectId String Id of the project.
RepositoryId String Id of the repository.
ChangeType String The type of change that was made to the item.
ItemGitObjectType String Git object type.
ItemObjectId String Change object Id.
ItemIsFolder Boolean Indicates whether its a folder.
ItemPath String Path of the change.
ItemUrl String URL of the commit change.

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