Parse specific fields from JSON response of Azure Devops REST API

[hkr1990]

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 })
})

[schwibach]

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

[hkr1990]

How do I get the JSON output as an array

[schwibach]

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.