Unanswered

Parse specific fields from JSON response of Azure Devops REST API

(0) Share

Report

Posted on by hkr1990 Microsoft Employee

I'm working on a flow to read the error details from the build pipeline using Azure Devops connector and send an email with failure results.

I'm having trouble parsing the JSON output of build timeline API.
Timeline - Get - REST API (Azure DevOps Build) | Microsoft Learn

The output JSON format has multiple records with taskname, issue, and logs. How do I iterate through it and collect all failure reason in a Variable.

"type": "object",

"properties": {

"records": {

"type": [

"array"

"items": {

"type": "object",

"properties": {

...

"details": {},

"errorCount": {

"type": "integer"

"warningCount": {

"type": "integer"

"url": {},

"log": {

"type": [

"object",

"null"

"issues": {

..
}

....

}

}

Example PowerShell code for what I want:

# Get the response from the devops api
$response = Invoke-RestMethod ......
$errors = $response.records.Where({ $_.issues -ne $null })
$errors.ForEach({
 # Task name
 $_.name
 # Error message
 $_.issues.ForEach({ $_.message })
})

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

schwibach 2 Moderator on at

Like (0)

Report

You'll want to use the Filter Array action and grab the records as content
and then the field messages inside the issues.
It'll look something like
item()?['issues']?['message']

Oh and you will probably want to use the empty() function and compare with if the expression true

Was this reply helpful? Yes No
hkr1990 Microsoft Employee on at

Like (0)

Report

How do I get the JSON output as an array

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report

In that field where it says body, you make reference not the entire object, but only the array within it that you want.

In your case that expression will look something like this:
body('HTTP')?['records']

That would give you the content of the object records inside the body of the flow step HTTP.

With the correct name of the previous flow step and a sample of the outputs of that step, we could put together the code.

Was this reply helpful? Yes No