Home > database >  Get value from json in LogicApp Two/Three Levels Down
Get value from json in LogicApp Two/Three Levels Down

Time:03-11

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).

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

CodePudding user response:

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

  • Related