Unanswered

Get data from JSON

(0) Share

Report

Posted on by GuttormG

I have a flow that gets new posts from Teams. I use triggerBody() to extract the data, and pase this to JSON. So far so, good 🙂
Now I want to get only a few values from this JSON. How do I get the values marked in this JSON?

I have tried things like outputs('Parse_JSON')?['sections']?['facts'] in several different ways, but either the flow fails, or I get a null-value.

Any suggestions?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Pstork1 68,678 Most Valuable Professional on at

Like (1)

Report
Re: Get data from JSON

Since Sections and facts are both arrays you'll need to add an index number to reach them directly. Something like this

outputs('Parse_JSON')?['sections'][0]?['facts'][0]?['value']

Was this reply helpful? Yes No
GuttormG 23 on at

Like (0)

Report

Re: Get data from JSON

Ahh, thank you very much! Got almost crazy of all the brackets, question marks and index numbers I couldn't figure out.
Also, I had to use body() instead of outputs(). Don't know why, but it works now!

Was this reply helpful? Yes No