Parsing JSON in Azure Logic App

Question

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

Did you use basically this process to setup the listener? azure.microsoft.com/en-us/documentation/articles/… I want to ensure I am answering the right question. — Shaun Luttin
– Shaun Luttin, Commented Sep 3, 2015 at 16:57
Yes, the listener works fine, if I just put "@{triggers().outputs.body.Content}" then it will forward the entire JSON wherever I want it to (I'm testing it in a slack connector) but I want to deserialize the JSON into its components — Michael B
– Michael B, Commented Sep 3, 2015 at 17:04
@ShaunLuttin Much appreciated - and note to self, delete that listener now I've posted it to the universe ;) — Michael B
– Michael B, Commented Sep 3, 2015 at 17:10

Matt Kocaj · Accepted Answer · 2019-04-17 00:42:12Z

13

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.

edited Apr 17, 2019 at 0:42

Matt Kocaj

11.6k6 gold badges53 silver badges79 bronze badges

answered Sep 3, 2015 at 18:02

jeffhollan

3,22717 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Michael B Over a year ago

that works perfectly! thank you - On a related note, I'm wondering if it is worth a question about how to discover these things (or if it just comes from someone who programs these things rather than hacks about with them like I do!)

jeffhollan Over a year ago

It's a good question. The syntax docs can be found here but we are working hard to make sure that's easier to find. Always welcome to reach out to me directly as well if you have any questions (or feedback, we love that too :). jehollan[at]microsoft.com

Frank Boucher Over a year ago

Just an FYI,@parse is now deprecated. Use @json instead.

Vivek · Accepted Answer · 2016-05-24 10:04:46Z

2

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.

answered May 24, 2016 at 10:04

Vivek

2212 silver badges5 bronze badges

Comments

Ravi Anand · Accepted Answer · 2016-12-12 12:09:32Z

1

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}

answered Dec 12, 2016 at 12:09

Ravi Anand

5,54211 gold badges54 silver badges81 bronze badges

Collectives™ on Stack Overflow

Parsing JSON in Azure Logic App

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related