Convert json structure into new structure

Getting Started
1

Hello All,

This is my first post and would value some help please. Thanks.

I want to convert this json (this is output from a parse json module)

[
{
“milestone-1”: “Market Analysis and Strategy Conceptualization”,
“timeline-1”: “2025-08-20T00:00:00.000Z”,
“milestone-2”: “Design and Development of Lead Generation Workflow”,
“timeline-2”: “2025-09-05T00:00:00.000Z”,
“milestone-3”: “Integration and Adaptation of make.com and airtable”,
“timeline-3”: “2025-09-20T00:00:00.000Z”,
“milestone-4”: “Testing, Validation, and Deployment of New Lead Generation Flow”,
“timeline-4”: “2025-09-30T00:00:00.000Z”
}
]

I want to create this structure and have tried for hours using “Create Json” module but no luck.

[
{
“milestone”: “Sample Milestone 1”,
“timeline”: “2025-01-01”
},
{
“milestone”: “Sample Milestone 2”,
“timeline”: “2025-02-01”
},
{
“milestone”: “Sample Milestone 3”,
“timeline”: “2025-03-01”
},
{
“milestone”: “Sample Milestone 4”,
“timeline”: “2025-04-01”
}
]

2

Welcome to the Make community!

You can use an Iterator and an Aggregate to JSON module.

From your screenshot/output bundle, it appears that you have an ARRAY of items. What do you do when you have an array?

“Looping” Through Array Items

When you SEE an array in your module’s output, think of using an Iterator module.

In this example, responses is an array of items (collections). You’ll want to map this array in an Iterator module.

345×487 12.5 KB

307×308 9.46 KB

Question: Have you tried mapping your array variable into an Iterator module, ran the scenario, and view the output?

Next,

Combining Bundles Using Aggregators

Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.

You can find out more about the other types of aggregator modules here:

Question: Which is the best aggregator do you think you’ll need for your use-case?

Example

Here is an example of how your scenario could look like:

This is just an example. Your final solution may or may not look like this depending on your requirements and actual data.

For more information, see “Mapping with arrays” in the Help Centre. You should also do the Make Academy, which also covers the use of Iterators & Aggregators.

Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

— @samliew

3

Thank you for the detailed information. I really appreciate it. I did not try the iterator first as I thought I could use the “Create Json” to achieve my objective.

I will definitely review in more detail and aim to get some more education and practice under my proverbial belt! :slight_smile:

1 Like