cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Venkateswaran
Regular Visitor

Parse JSON - Array of objects

From the HTTP im getting below json:

{

    "dataList": [

        {

             "stateCd": "FL",

            "cntryCd": "US",

            "statusCd": "A",

            "timeZone": "ET"

        }

    ]

}

 

I just want to get the value of cntryCd. I tried with parse json and Apply to each but it is not giving me exact parameter.

1 ACCEPTED SOLUTION

Accepted Solutions
ekarim2020
Super User
Super User

Hi @Venkateswaran ,

 

You can use an expression to directly reference the cntryCd property. For example:

Snag_a520b19.png

 

We can use the following expression:

 

variables('varData')?['dataList']?[0]?['cntryCd']

 

Snag_a523dd1.png

Here is the sample runtime output:

Snag_a530d08.png

 

Hope this helps.

 


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

View solution in original post

1 REPLY 1
ekarim2020
Super User
Super User

Hi @Venkateswaran ,

 

You can use an expression to directly reference the cntryCd property. For example:

Snag_a520b19.png

 

We can use the following expression:

 

variables('varData')?['dataList']?[0]?['cntryCd']

 

Snag_a523dd1.png

Here is the sample runtime output:

Snag_a530d08.png

 

Hope this helps.

 


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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,762)