ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves a list of repositories.

Table Specific Information


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

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • IncludeAllUrls supports the '=' operator.
  • IncludeHidden supports the '=' operator.
  • IncludeLinks supports the '=' operator.
  • IncludeParent supports the '=' operator.

The rest of the filter is executed client-side in the 本製品.

For example:

	SELECT * FROM Repositories WHERE Id = '02b4a62d-2f5f-4d69-8420-29257dcc8051'
	SELECT * FROM Repositories WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM Repositories WHERE IncludeAllUrls = true
	SELECT * FROM Repositories WHERE IncludeLinks = true


The following is an example of inserting into a Repositories table:

INSERT INTO Repositories (ProjectId, Name) VALUES ('c831d3b4-a289-462f', 'TestRepository')


The following is an example of updating a Repositories table:

UPDATE Repositories SET Name = 'cdata2' WHERE Id ='dbf5e1ff-9192-4f94-ba21-735a4c289c72' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'


The following is an example of deleting data in a Repositories table:

DELETE FROM Repositories WHERE Id = 'dbf5e1ff-9192-4f94-ba21-735a4c289c72' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'


Name Type ReadOnly References Description
Id [KEY] String True

Id of the repository.

LinksCommitsHref String True

Commits reference link.

LinksItemsHref String True

Items reference link.

LinksProjectHref String True

Project reference link.

LinksPullRequestsHref String True

Pull requests reference link.

LinksPushesHref String True

Pushes reference link.

LinksRefsHref String True

Refs reference link.

LinksSelfHref String True

Self reference link.

LinksSshHref String True

Ssh reference link.

LinksWebHref String True

Web reference link.

DefaultBranch String True

The default branch.

IsFork Boolean True

True if the repository was created as a fork.

Name String False

The name of the repository.

ParentRepositoryId String False

Id of the parent repository.

ParentRepositoryIsFork Boolean False

True if the repository was created as a fork.

ParentRepositoryName String False

The name of the parent repository.

ParentRepositoryProjectId String False

The project ID of the parent repository.

ParentRepositoryRemoteUrl String False

The remote URL of the parent repository.

ParentRepositorySshUrl String False

The SSH URL of the parent repository.

ParentRepositoryUrl String False

The URl of the parent repository.

ProjectId String True


Id of the project.

RemoteUrl String True

The remote URL of the repository.

Size String True

The size of the repository.

SshUrl String True

The SSH URL of the repository.

Url String True

The URL of the repository.

ValidRemoteUrls String True

The collection of valid remote URL's.

WebUrl String True

The web URL of the Repository.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
IncludeAllUrls Boolean

True to include all remote URLs.

IncludeHidden Boolean

True to include hidden repositories.

IncludeLinks Boolean

True to include reference links.

IncludeParent Boolean

True to include parent repository.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479