SSIS Components for Azure DevOps

Build 24.0.9063

PullRequestReviewers

Retrieves a list of reviewers for the specific pull request, 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:

  • RepositoryId supports the '=' operator.
  • PullRequestId supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.

For example:

	SELECT * FROM PullRequestReviewers WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND RepositoryId = '229ec1a1-609f-4545-af5a-85f00ce7428b' AND PullRequestId = 2
	SELECT * FROM PullRequestReviewers WHERE RepositoryId = '229ec1a1-609f-4545-af5a-85f00ce7428b' AND PullRequestId = 2

Insert

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

INSERT INTO PullRequestReviewers (ProjectId, RepositoryId, PullRequestId, Id, Vote) VALUES ('c831d3b4-a289-462f', 'b20311e2-b5e4-444f', 2, '0c51c6d1-49b7-661b', 5)

Update

The following is an example of updating a PullRequestReviewers table:

UPDATE PullRequestReviewers SET DisplayName = 'cdata1', hasDeclined = false WHERE ProjectId = '1db52c22-a4e9-4ddc-ba82-5c0ae281dfd2' AND RepositoryId = '6b9dab15-dfe0-4488-a2b1-c5fe2a34b2cb' AND PullRequestId = 1 AND Id = '6a10066b-ee05-40c0-a207-b9fcbac568be'

Delete

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

DELETE FROM PullRequestReviewers WHERE ProjectId = '1db52c22-a4e9-4ddc-ba82-5c0ae281dfd2' AND RepositoryId = '6b9dab15-dfe0-4488-a2b1-c5fe2a34b2cb' AND PullRequestId = 1 AND Id = '6a10066b-ee05-40c0-a207-b9fcbac568be'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Id of the reviewer

ProjectId String True

Id of the project.

RepositoryId [KEY] String True

Id of the repository.

PullRequestId Integer True

PullRequests.Id

Id of the pullrequest.

DisplayName String False

Display name of the reviewer.

ReviewerUrl String False

URL to retrieve information about the reviewer.

Url String False

This url is the full route to the source resource of the reviewer.

Vote Integer False

Vote on a pull request: 10 - approved, 5 - approved with suggestions, 0 - no vote, -5 - waiting for author, -10 - rejected.

isFlagged Boolean False

Whether a pull request is flagged.

hasDeclined Boolean False

Whether a pull request has been declined.

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