Nested ForEach and localVariable

Question

So, I am trying to capture and store nested data from USDA Database - API (image below) 
 
 Now I am trying to store this data in a record - fields being gtinUpc, number, name, amount, and unitName. I am trying to use the forEach-nested loop example from 
 https://docs.appian.com/suite/help/23.1/fnc_looping_a_foreach.html . 
 However, when I try to nest another forEach and iterate over the foodNutrients, I get errors. I have tried moving lines around - for example, move line 21 to outside the inner a!localVariables - nothing seems to work. 
 
 As always, any and all feedback/assistance would be appreciated. 
 Thanks

Richard Michaelis · Answer

Hello Mana, the ":" notation is just a declaration at the beginning of your form or expression rule to define your locals. not assignend values later: so here its lesse with the iteration lopping its with your ":" notation Do you want to create a new record value set or update an existing one?

Richard Michaelis · Answer

perhaps this one is helping you. So what I am saying: I see rather an issue how you create/update data IN your a!forEach than your a!foreach logic itself.

Mike Schmitt · Answer

MaNa said: That variable is declared on line 30 - and is being given a value on line 42 
 To reiterate and simplify upon the prior correct responses by Stefan and Richard: this is not how local variables work. You need to set the value of the local variable where you declare it. Any use of a local variable needs to be done inside the same a!localVariables() statement in which it was declared. The code snippets you've posted here all violate both of these tenets.

Nested ForEach and localVariable

Top Replies