SSIS Components for Azure DevOps

Build 24.0.9063

PullRequestAttachments

Retrieves a list of attachments 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:

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

  • PullRequestId supports the '=' operator.
  • RepositoryId supports the '=' operator.
For example:
	SELECT * FROM PullRequestAttachments WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND RepositoryId = '123e04e0-6c4c-4675-8636-af6b0bc29d43' AND PullRequestId = 4

Columns

Name Type References Description
Id Integer Id of the attachment.
ProjectId String Id of the project.
RepositoryId String Id of the repository.
PullRequestId Integer

PullRequests.Id

Id of the pull request.
AuthorDisplayName String The non-unique display name of the author.
AuthorId String Id of the author.
AuthorUrl String The URL of the author.
ContentHash String Content hash of on-disk representation of file content. Its calculated by the server by using SHA1 hash function.
CreatedDate Datetime The time the attachment was uploaded.
Description String The description of the attachment.
DisplayName String The display name of the attachment.
Properties String Properties of the attachments.
Url String The URL to download the content of the attachment.

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