Hello,
I have a JSON file with this format:
{
"Place": {
"Name": "Louvre Museum",
"Google_place_id": "",
"City": "Paris",
"Region": "Ile-de-France",
"Country": "France",
"Cultural_type": "Museum",
"Facts": {
"Historical_facts": [
"Originally built as a medieval fortress by King Philip II in the late 12th century.",
"Transformed into a royal palace by Francis I in the 16th century.",
"Officially became a public museum during the French Revolution in 1793.",
"Home to Napoleon Bonaparte’s extensive art collections during his rule.",
"Expanded significantly in the 19th century under Napoleon III.",
"The Louvre Pyramid entrance was inaugurated in 1989, designed by architect I. M. Pei."
],
"Architectural_facts": [
"Features medieval fortress foundations still visible in the museum.",
"Renovated in Renaissance style under Francis I and Henry IV.",
"Louis XIV expanded the Louvre, adding the classical Colonnade of the east façade.",
"The Grand Gallery, one of the longest museum halls in the world, spans over 1,200 feet.",
"The Louvre Pyramid, made of glass and metal, serves as the main entrance.",
"Incorporates Baroque, Renaissance, and Neoclassical architectural elements.",
"The Cour Napoléon houses the central glass pyramid entrance structure.",
"The Richelieu Wing was added in the 19th century to house additional artworks.",
"The Arc de Triomphe du Carrousel, near the Louvre, was built by Napoleon in 1806.",
"The underground Carrousel du Louvre shopping area was completed in 1993."
],
"Geographical_facts": [],
"Historicalfigure_facts": [],
"Art_facts": [],
"Political_military_facts": [],
"Cultural_facts": [],
"Daily_life_tradition_facts": [],
"Religious_facts": [],
"Scientific_facts": [],
"Mystery_legends_facts": [],
"Restauration_preservation_facts": [],
"Community_local_facts": [],
"Economic_commercial_facts": []
}
}
}
I have a collection of Facts, sorted in categories as array, with multiple facts in them
I want to extract each Facts and parse them in airtable.
I think I should use a double iterator to do so - The first one to go through each category and the second to go through each item of the array.
I have this simple scenario with my JSON module
Problem:
I cannot access the value
If I put this value in my first iterator:
Then in my second iterator I don’t see anything despite seeing the bundle in the output of my first iterator:
And if I try to convert my collection to an array, then I can see an item Value in my Second iterator
I can manage to access the data in the array
But I cannot retreive the name of my category, the Key of the object:
And I need both, the value and the key to map correctly in Airtable.
What do I do wrong?
Thanks in advance
