ODBC Driver for Azure DevOps

Build 22.0.8479


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'


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.

使用できる値は次のとおりです。NONE, 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479