cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jasmine2020
Microsoft
Microsoft

How to retrieve and update JSON value In LogicApp using 'For Each'

Background:


I wish to loop through, retrieve and update items within my document

I wish to locate and loop through values within an array, locate nested values and then update them using LogicApps. I know I am on the right path, I just need a little assistance.


1.

Here is the document. I wish to loop over A (it has many records in it) and retrieve all of the
categories.

"A":
            [

                {
                     "category": "1"
                  }

            ]

2.

Once I retrieve the categories, I wish to loop over each one of the categories I find and then update their id and status

 

"category":"1"
 "box":
               [
                    {
                         "id": "update"
                           "status": "update"

                      }

               ]


My approach and what I have done:

 

 

I believe I have to do a 'For Each' loop over the A's.
I am just not sure how to write in the logicApp that I want to retrieve all the "category" fields and then the fields within the box field.

Then once I obtain all the "category" fields, I must update the id and status within this array with
a string.


I want to change


"id": "update" to "id" : "number"


and change


"status": "update" to "status": "linked"


I believe I must: initialize, parse, and do a For Loop

 

jasmine2020_0-1597185775120.png

jasmine2020_2-1597185807653.png

 

 

 

 


I believe I must: initialize, parse, and do a 'For Each' Loop, but how do I tell the logicapp I wish to grab the "category" part of the "A" since its nested, and then once I have the "category" part to then update the nested fields of "id" and "status" within that?

Any help is great

0 REPLIES 0

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,961)