I’m trying to merge a list of JSON structures into a single JSON object using Make. My workflow starts with pulling data from a Google Sheets module. For example, if the section_ids are:
- Section_hero01
- Section_testimonials01
I want the final result to be a single JSON object in this format:
{
"Section_hero01": {
"section_hero01_headline": "Hero Headline",
"section_hero01_text": "Hero Text"
},
"Section_testimonials01": {
"section_testimonials01_headline": "Testimonials Headline",
"section_testimonials01_text": "Testimonials Text"
}
}
I’ve tried using various modules like Iterator, Aggregator, JSON parsing, and Set Variable, but I haven’t managed to get the desired result. Any guidance would be greatly appreciated, thanks!