Parsing JSON - get the last array

[lucas14]

Hi,

I want to get the last array from a tag named profilesData from a JSON file. Im using parse JSON to get the information out of a JSON file from a HTTP response. Then I want to analyse the profilesData array, but as I mentioned only the last one from the two from the HTTP response.

This one here:

I tried this, but it says that its an invalid template, because the type is Null.

Thanks for your help 🙂

[Paulie78 · Accepted solution]

I am not sure if you are trying to get the last element of the body array or just the profilesData within that array. 

Try this code for the final element of the profilesData array:

last(outputs('HTTP')['body'][0]['profilesData'])

or if you want the last element of the body array it would be:

last(outputs('HTTP')['body'])

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘