Parsing JSON in Azure Logic App

azure azure-logic-apps
Michael B picture Michael B · Sep 3, 2015 · Viewed 20.4k times · Source

I have a HTTP listener that I am sending a JSON post body with. 

{
"recipient":"[email protected]",
"subject":"this is a test subject",
"body":"this is a test body email"
}

I am trying to pull those individual parameters out in the next flow, but it errors instead!

The result I am looking to achieve is "[email protected]" being taken as an input for the next action

I've tried things like 

"@{triggers().outputs.body.Content.recipient}"

and various variations of, but I suspect I'm missing something!

edit to add

I am currently sending the post request via Powershell, though it will ultimately be over c# 

$a = @"
{"recipient":"[email protected]","subject":"this is a test subject","body":"this is a test body email"}
"@

Invoke-WebRequest -Uri     https://httplistenerc743421edf234899a1315aa38c6398bc.azurewebsites.net/listen -Method POST -Body $a

Answer

jeffhollan picture jeffhollan · Sep 3, 2015

Ah the trick with this is the output of the HTTP Listener body is a String, so you need to convert it to JSON before you can parse it. There is a @parse() command to do just this.

So if you do this it should work:

@{json(trigger().outputs.body.Content).recipient}

That should give you the recipient. Let me know if that doesn't work.

Related questions

How to do a 'null' check in 'if' condition action of Azure Logic App

I've created a logic app which contains some trigger, an 'http' connector and then an 'If' condition activity. The 'http' connector returns a 'json' result say jsonObj. I'm able to check condition as @equal(body('HTTP')['jsonObj'].someProperty,'someValue') but …

Read More
Azure Logic app : How to Send an Email with one or more attachments after getting the content from Blob storage?

I want to read blob contents using azure logic app get blob contents connector and send that contents as attachment via email using azure logic app send email connector. Attachments could be one or more. Send email requires attachment data …

Read More
Parse text in Azure Logic Apps

I want to create Azure Logic App which will constantly request a specific website on the Internet and parse received HTML. I've created Logic App and set up interval and HTTP request action. Which action should I choose as the …

Read More