CODEWITHSUNDEEP
azureazure-logic-apps
Michael B
Michael B

Reputation: 12228

Parsing JSON in Azure Logic App

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

Upvotes: 8

Views: 33985

Answers (3)

jeffhollan
jeffhollan

Reputation: 3227

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.

Upvotes: 13

Ravi Anand
Ravi Anand

Reputation: 5524

as i did with mine where azure function is returning json data as text/string:

@{body('azure_fun_Name').recipient}
@{body('azure_fun_Name').subject}
@{body('azure_fun_Name').body}

Upvotes: 1

Vivek
Vivek

Reputation: 221

You have to define content-type in header of http listener, after which you don't need to parse http listener's response, it will automatically in described format.

Upvotes: 2

Related Questions