ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves a list of attachments for the specific pull request.

Table Specific Information


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 本製品.

NOTE: RepositoryId and PullRequestId is required in order to query PullRequestAttachments.

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


Name Type References Description
Id Integer Id of the attachment.
ProjectId String


Id of the project.
RepositoryId String


Id of the repository.
PullRequestId Integer


Id of the pull request.
AuthorDisplayName String The non-unique display name of the author.
AuthorId String Id of the author.
AuthorImageUrl String The image URL of the author.
AuthorUniqueName String The unique name 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479