
Hello,
I am trying to select the "site" > "name" in the Parse JSON below, having a spent a good couple of hours. Can somebody point me in the right direct or show me what I am doing wrong please!
I have tried the scheme as both an object or a array. I just want to pull out the site name so I can use it for a filter later on.
I have tried outputs('Parse_JSON')?['body']?['name'] it shows shows no errors but shows a blank screen, however ('Parse_JSON')?['body'] pulls in the entire body no problems, I just cant manage to drill down into 'site'.
I am using the auditor connectors if this makes any differences
any help would be great,
thanks .
Hello @jakemorris ,
as per I can see, you should use the following expression:
outputs('Parse_JSON')['body']['audit_data']['site']['name']
It weird that you cannot grab this value as an output from the Parse JSON action.
Anyhow, could you please share the JSON?
If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.
My blog site about Power Automate: https://powerautomatejoy.com/
BR,
Marco