CData Python Connector for Azure DevOps

Build 24.0.9060

PullRequestReviewers

Retrieves a list of reviewers for the specific pull request

Table Specific Information

Select

The connector 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.
  • PullRequestId supports the '=' operator.
The rest of the filter is executed client-side in the connector.


NOTE: RepositoryId and PullRequestId are required in order to query PullRequestReviewers.

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 String True

Id of the repository.

PullRequestId [KEY] 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.9060