PullRequestAttachments
Retrieves a list of attachments for the specific pull request, sliced across all repositories.
Table Specific Information
Select
The connector 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 connector.
- PullRequestId supports the '=' operator.
- RepositoryId supports the '=' operator.
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. |