Parsing json - get first item of an array

(3) 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 (9)

Answers (1)

Verified answer

DeepakS 2,301 Most Valuable Professional on at

Like (11)

Report
Copy link

Link copied!

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 27 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 27 on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

Thank youuuuuu. You are my hero. 😀

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
JS-15030026-0 2 on at

Like (0)

Report
Copy link

Link copied!

I tried the recommended solution above but it is no working for me

I am using a Compose action with this content body('ParseJSON')[0]['RunStatus']

Here is output of previous ParseJSON step

{

  "Table1": [

    {

      "RunStatus": "Succeeded",

      "JobMessage": "The job succeeded.  The Job was invoked by Schedule 14 (Monthly ACTIVE_INDIVIDUALS).  The last step to run was step 8 (SP_MTH_ACTIVE_INDIV7)."

    }

  ]

}

I get this error message:

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language expression 'body('ParseJSON')[0]['RunStatus']' cannot be evaluated because property '0' cannot be selected. Object properties can only be selected by names.

What am I doing wrong?

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

In your case, body('ParseJSON') is not an array.

Was this reply helpful? Yes No