Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Get value from json in LogicApp Two/Three Levels Down

Absolute newb question here how do I get a value two levels down in the JSON data with Azure Logic Apps? The web-hook is sending in: Image of incoming JSON

I need the value for shipping/address/city…

I have been trying to run @triggerBody()?[‘shipping’][‘address’][‘city’] but it can’t find address (obviously I am doing something wrong).

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

I just need some syntax to continue and your help is greatly appreciated!

>Solution :

One of the workaround is to use Parse_JSON connector to get the inner values of JSON. Just use the sample Schema in Use sample payload to generate schema and it fetches the inner values.
Below is the screenshot of my logic app.

enter image description here

Result:

enter image description here

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading