ODBC guide

Add link to existing work item (attachment as reference)


Add an attachment reference to an existing work item using a JSON PATCH body. Use the attachment URL you received from the upload endpoint (or any existing attachment URL). The example adds a history comment and one AttachedFile relation; replace YOUR_ORGANIZATION, YOUR_PROJECT, WORK_ITEM_NUMBER, and ATTACHMENT_ID with your values. Useful for linking screenshots or documents to a work item after upload.

SELECT *
FROM generic_request
WITH(
	  Url='YOUR_ORGANIZATION/YOUR_PROJECT/_apis/wit/workitems/WORK_ITEM_NUMBER?api-version=7.0',
	  RequestMethod='PATCH',
	  Headers='Content-Type: application/json-patch+json',
	  Meta='id:int; fields.System.Title:string; fields.System.State:string; fields.System.WorkItemType:string; relations:string(4000)',
	  Body='
[
  {
    "op": "add",
    "path": "/fields/System.History",
    "value": "Adding the necessary spec"
  },
  {
    "op": "add",
    "path": "/relations/-",
    "value": {
      "rel": "AttachedFile",
      "url": "https://dev.azure.com/YOUR_ORGANIZATION/YOUR_PROJECT/_apis/wit/attachments/ATTACHMENT_ID?fileName=Screenshot.png",
      "attributes": {
        "comment": "Error screenshot"
      }
    }
  }
]
'
)