ADO work items in Azure SQL DB using ADO REST API in ADF

Copper Contributor

Anyone managed to get the work items using ADO REST API? I have setup everything but each time I try to preview data (ADO wit) or run the activity, I am getting error:

Error occurred when deserializing source JSON file ''. Check if the data is in valid JSON object format. Unexpected character encountered while parsing value: <. Path '', line 0, position 0.>

I have constructed REST API as below and using POST method{organization}/{project}/{team}/_apis/wit/wiql?api-version=6.0


My rest API url:

further info on variable:

@apiBody1={ "query": "Select [System.Id] From WorkItems Where [System.WorkItemType] In ('

@apiBody2=' and [System.AreaPath] = 'mypath'" } --sometime this also has '\' such as mypath\subpath

further I am concatenating the variables:


1 Reply

I am using PAT for authentication.