Answered

How to get JSON values from HTTP Json Response ?

(0) Share

Report

Posted on by dips23

Hello,

I am using Parse JSON action to parse json response returned from http request, however with Parse JSON, I get following values as output:

{
"displayName": "John Doe",
"jobTitle": "Software Engineer"
}

While, I want to fetch value of "displayName" key which is "John Doe" and pass to further action in Microsoft flow, Is there any formula/action to implement it ?

Best Regards,

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (1)

Report

Hi @dips23 ,

You could use object['key'] to get the specified key value.

Image reference:

Please take a try.

Best Regards,

Was this reply helpful? Yes No
LetsGetThisData 12 on at

Like (0)

Report

This solved the issue I was having.

I was grabbing data from a SQL Server and POSTing the data through HTTP. Once POSTed there was an ID that the system generated on the POST side, so I needed to grab that to tie it to the record on my side. Added the Body from the HTTP to a Compose, then added another Compose to reference the previous compose. I got the id needed and it was posted back to be used on my end.

Thanks for the help Barry

Was this reply helpful? Yes No