Pulling information from JSON/XML array

(0) Share

Report

Posted on by MacAodh

Hi folks

I feel like this solution is staring me in the face but I can't quite seem to get there.

I'm pulling information, in xml or json, from an api. This is returning several paramaters, including an array as per below (in json format). Each of the below is for one specific job.

I am trying to pull the value for where the label equals x.

Name = Jim McJohn

Contact Details = 123456

Sales Exec = John McJim

[
{
"id": 32165,
"label": "Name",
"third_party_id": "",
"value": "Jim McJohn",
"type": "read_only"
},
{
"id": 987654,
"label": "Contact Details",
"third_party_id": "",
"value": "123456",
"type": "read_only"
},
{
"id": 321456,
"label": "Sales Exec",
"third_party_id": "",
"value": "John McJim",
"type": "not_shown"
},
]

I feel this should be really simple but it's just catching me out at the moment. Any help anyone could offer would be very much appreciated!

Thank you in advance.

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (1)

Paulie78 8,418 Moderator on at

Like (1)

Report
Re: Pulling information from JSON/XML array

Would this work? Or do you actually need to filter based on the value of the label (which is possible, just slightly more complex).

The second compose generates a JSON object. Example output:

{ "Name": "Jim McJohn", "Contact Details": "123456", "Sales Exec": "John McJim" }

The code within each line of the compose is:

outputs('compose')[0]['value'] outputs('compose')[1]['value'] outputs('compose')[2]['value']

As you can see, it is not collecting the data by the named label, just compiling all three entries into a single object.

Blog: tachytelic.net

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

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

Was this reply helpful? Yes No
Verified answer

MacAodh 21 on at

Like (1)

Report
Re: Pulling information from JSON/XML array

Firstly thank you very much for replying - I would have responded sooner but I hadn't realised you replied (assumed incorrectly I would get an email...)
That would work but what I neglected to mention was I have quite a few fields (28 to be precise), and I want this to be able to take new fields when/if I ever add them.

So what I did, and it took a little pain, was to create a html table from the array and follow the amazing video which I suspect is from yourself:
How to use Power Automate to parse a HTML Table and convert to JSON

I then used a join to convert the array to a string, replaced } and { using replace and finally added a curly bracket either side using concat. Suspect this is similar to going from Dublin to London via New York but if it works...

replace(body('Join'),'{','') replace(outputs('Replace_{'),'}','') concat('{',outputs('Replace_}'),'}')

Was this reply helpful? Yes No