Parsing json - get first item of an array

(2) Share

Report

Posted on by KrisvanderMast

From an HTTP get call I'm getting this json back:

[{"Value": "BRUUL","Id": 39318,"Brussels": false}]

I simply want to take the value for the Id property of the first item in the array.

I've been reading up on articles I found via several search engines, trying with compose and set variable but either it goes into a apply each block, which I don't want, or I keep on getting the entire above string sent back to my Power Virtual Agent.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

DeepakS 2,301 Most Valuable Professional on at

Like (11)

Report

Hi @KrisvanderMast

After you parse your JSON using parse JSON action use following expression :
body('Parse_JSON_2')[0]['Id'] this will give you id of first item

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
KrisvanderMast 25 on at

Like (0)

Report

Hi,

that gives me the following error:

Correct to include a valid reference to 'Parse_JSON_2' for the input parameter(s) of action 'Initialize_variable'.

Was this reply helpful? Yes No
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Hi @KrisvanderMast

Parse_JSON_2 is the action name in my FLOW, in your flow you should use action name that in your flow. share a screen capture of your flow i will let you know what to use.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
KrisvanderMast 25 on at

Like (1)

Report

Did a rename of my action and it worked.

Is there some overview/list of functions like body() and the likes I can take a look at and learn?

Was this reply helpful? Yes No
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Hi @KrisvanderMast

Checkout following link:
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
_Judy_ 95 on at

Like (0)

Report

Thank youuuuuu. You are my hero. 😀

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#first 😉

Was this reply helpful? Yes No