SSIS Components for Azure DevOps

Build 24.0.9063

GitBranches

Retrieves a collection of git branch, sliced across all repositories.

Table Specific Information

Select

The 本製品 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.
  • IncludeLinks supports the '=' operator.
  • MyBranches supports the '=' operator.
  • IncludeStatuses supports the '=' operator.
  • LatestStatusesOnly supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.


NOTE: RepositoryId is required in order to query GitBranches.

For example:

	SELECT * FROM GitBranches WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051'
	SELECT * FROM GitBranches WHERE RepositoryId = '02b4a62d-2f5f-4d69-8420-29257dcc8051' AND IncludeLinks = true

Update

The following is an example of updating a GitBranches table:

UPDATE GitBranches SET isLocked = true WHERE name = 'abc' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND RepositoryId = 'e50698d4-bb6e-400f-a1a0-5f4d17517d9e'

Columns

Name Type ReadOnly References Description
ObjectId [KEY] String True

Path for the branch.

ProjectId String False

Id of the project this branch belongs to.

RepositoryId String False

Repositories.Id

Id of the repositories.

Name String False

Name of the branch.

CreatorDisplayName String True

The non-unique display name of the user who created this branch.

CreatorUrl String True

The URL of the user who created this branch.

CreatorLinksAvatarHref String True

Avatar reference link of the creator.

CreatorId String True

Id of the creator.

CreatorDescriptor String True

Descriptor of the creator.

Links String True

Aggregate of the reference links.

Statuses String True

Contains the metadata of a service/extension posting a status.

Url String True

Full HTTP resource link of the branch.

isLocked Boolean False

Represents a boolean value if the branch is locked or not.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。

Name Type Description
IncludeLinks Boolean

Specifies if referenceLinks should be included in the result.

IncludeStatuses Boolean

Includes up to the first 1000 commit statuses for each ref.

MyBranches Boolean

Includes only branches that the user owns, the branches the user favorites, and the default branch.

LatestStatusesOnly Boolean

rue to include only the tip commit status for each ref.

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