How to parse JSON with Copilot Studio

[@4-r-k]

Actually what's more important is to know how to loop through the JSON and print out the respective values, which was ignored here.

[@md.sharifulislam5645]

Did you get the idea to loop through the JSON and print out the respective values?

[@vvvvv432]

Really useful! And for anyone who is looking to parse values like: Topic.SampleJSON.result[0].number, the way to do it in Copilot Studio is: Index(Topic.SampleJSON.result,1).number

[@ashishk1773]

Great video Dewain! Need your help in understanding what might have to be added if I need to file a JSON file as a whole and parse it on runtime. It could be on OneDrive or on SharePoint but something that is accessed on runtime. Edit: I am accessing a JSON through HTTP request. While the content comes through, the parsing is a challenge... as the functions to convert it to a string or accessing nodes are a challenge I have added the files as well as SharePoint to the knowledge sources also. Thank you so much!

[@We_went_camping_again]

What if I want to display the items in a column set or fact set? How do I do do that? Thanks

[@andrescastellanospin]

Hi Dewain, we are trying to send a variable information by http request, you have somer video to explain this part?. Thanks

[@sixycorn]

What is the advantage parsing the JSON inside of PVA in contrary to Power automate?

[@andrewcoates2222]

You can use the parsed Json directly in PVA without the overhead of going back to Power Automate

[@VishalThakur-i6x]

in copilot studio parse record to string ? How to do this ? can we stringify JSON

[@Dewain27]

There is a PowerFX function for this... I will see if I can add this as a video to show how to do it...

[@eudesbarbosa9382]

Great video! I have a question: I managed to access the 'Topic.SampleJSON.result' property at the first level, but I'm having trouble reaching the innermost property. I tried something like 'Topic.SampleJSON.result[0].number', but I'm getting an error saying it doesn't exist. Could you provide a tip or guidance on how to correctly access this innermost property? { "result":[ { "number":"string", "short_description":"string", "close_notes":"string"} ] }

[@Dewain27]

First(Topic.SampleJSON.result).whatever

[@vvvvv432]

Or use this: Index(Topic.SampleJSON.result,1).close_notes