DownloadPullRequestAttachment
Download Pull Request Attachment.
Stored Procedures Specific Information
Process of Download PullRequest Attachment
Azure DevOps allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only = comparison. The available columns for DownloadPullRequestAttachment are ProjectId, RepositoryId, PullRequestId, FileName and FileLocation.
For example:
EXECUTE DownloadPullRequestAttachment ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4', RepositoryId = '666e04e0-6c4c-4675-8636-af6b0bc29d43', PullRequestId = 4, FileName = 'App.png', FileLocation = 'C:\azuredevops'
Input
| Name | Type | Required | Accepts Output Streams | Description |
| ProjectId | String | False | False | Id of the project. |
| RepositoryId | String | True | False | Id of the repository. |
| PullRequestId | Integer | True | False | Id of the pull request. |
| FileName | String | True | False | Name of the attachment. |
| FileLocation | String | False | False | Location of the file. |
| Encoding | String | False | False | The FileData input encoding type.
The allowed values are NONE, BASE64. The default value is BASE64. |
| FileStream | String | False | True | An instance of an output stream where file data is written to. Only used if FileLocation is not provided. |
Result Set Columns
| Name | Type | Description |
| Status | String | Stored procedure execution status. |
| FileData | String | If the FileLocation and FileStream are not provided, this contains the content of the file. |