Hi, I'm extracting data from a sharepoint list via a HTTP Rest API call and then parsing the output which ends up with a relatively simple looking JSON extract. But when I try and loop through it, I get the following error....
The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['body']?['value']' is of type 'Null'. The result must be a valid array.
The output from my PARSE JSON is in this format (trunctuated and anonymised for simplicity). I've tried googling, and am sure there is a simple thing I'm doing wrong, but not sure what
{
"body": {
"odata.nextLink": "https://myurlwiththeAPIcall.com",
"value": [
{
"myID": 1234,
"Match_x0020_Level": "Exact",
"GroupID": "bae26ea6"
},
{
"myID": 2345,
"Match_x0020_Level": "Exact",
"GroupID": "aaf12f0e"
}
]
}
}
