Loop nested JSON array

Workflows
1

Hello
There is a way to execute a loop from a nested Json?
Here my situation, I call an API "getDogs" with this response:

{
"dogName": "Mello"
"ID_dogFavouriteFood": [
"4635275",
"6786768",
"5675675"
],
"favouriteParks": [
{
"parkName" : "Cascine",
"parkAddress": "Cascine street, 23"
}
{
"parkName" : "Vallombrosa",
"parkAddress" : "Contrada Vallombrosa, 1"
}
]
}

I'm trying to figure out how to loop "ID_dogFavouriteFood" and "favouriteParks" arrays (to write datas in different tables un mySQL db.

So I want to have something like that:

TABLE: DOGS

  1. Mello

TABLE: DOG_FAVOURITE_FOODS

  1. 4635275
  2. 6786768
  3. 5675675

TABLE: FAVOURITE_PARKS

  1. Cascine Cascine street, 23
  2. Vallombrosa Contrada Vallombrosa, 1

Thank you so much!

2

Yes, check out the following

https://docs.retool.com/docs/scripting-retool#promises-and-async-queries

You can add as many queries you want within the promise so that each of the tables will get updated. And read more about additionalScope here so you understand about how to pass data into the query.
https://docs.retool.com/docs/scripting-retool#trigger-a-query