SSIS Components for Azure DevOps

Build 24.0.9063

Repositories

Generated schema file..

Table Specific Information

Select

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

Insert

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

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

Update

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'

Delete

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'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Id of the repository.

Links String True

Aggregate of the reference links.

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.

Pseudo-Columns

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063