Make Array aggregator: combine records into one list

An array is a list of values. This Make Free exercise uses Array aggregator to combine two fictional order records into one array, keeping their item names and quantities.

1. Create the two source records

1. In Scenarios, click Create scenario. Name it Array regrouping practice at the top left.
2. Add JSON > Parse JSON. Leave Data structure empty and paste the sample below into JSON string.
3. Save the module and scenario. For a warning that only says the output is unused, choose Save anyway.
4. Click Run once, then Run anyway for that warning. Inspect the source result for two bundles.

Enlarge image

Full Make editor with two fictional order records in a JSON array

×

Open full-size image

This top-level JSON array already supplies separate bundles. You do not need an Iterator for this source. A list nested inside a field is a different starting point; see the Iterator guide.

2. Choose what to keep in the list

1. Close the result panel. Click the plus to the right of JSON and choose Flow Control > Array aggregator.
2. Set Source Module to JSON - Parse JSON [1].
3. Keep Target module set to Custom. Under Aggregated fields, select item and quantity.
4. Save the module and scenario.

Enlarge image

Full Make editor with Array aggregator source and item and quantity fields selected

×

Open full-size image

3. Expand both output items

1. Click Run once. Handle an unused-output warning as above.
2. Open the result bubble above Array aggregator.
3. Under Output, expand Bundle 1, then Array. Expand items 1 and 2.
4. Check that item 1 contains Notebook and quantity 2, and item 2 contains Pencil and quantity 1.

Enlarge image

Full Make editor with both aggregated array items expanded showing Notebook and Pencil quantities

×

Open full-size image

There is one output bundle containing a two-item array. A later module that expects the whole list needs the aggregator's Array token, rather than one item inside it.

If the list is empty or a field is missing

Check the source's actual bundle count. Run the source with representative data before reopening the aggregator. Confirm the selected source and Aggregated fields.

If a filter removes every record, the default setting still produces an empty array and the next module can run. To stop that route, open Array aggregator, turn on Show advanced settings and select Yes for Stop processing after an empty aggregation. Save the module and scenario.

Enlarge image

Make Array aggregator with the empty-aggregation stop option enabled.

×

Select Yes to stop the route when no records reach the aggregator.

Open full-size image

Check the empty case in this practice scenario before connecting a real action:

1. Add a filter between JSON and Array aggregator. Choose Text operators: Equal to, with 1 in the first field and 0 in the second. Keep JSON - Parse JSON [1] as the aggregator source and leave Group by empty.
2. With Stop processing after an empty aggregation off, run once and inspect the aggregator: it returns an empty Array inside one output bundle. Turn the option on, save and run again. The route stops before the next module.
3. Change the filter's second field to 1 and run again with the stop option still on. Expand the output array and confirm Notebook, 2 and Pencil, 1 return.

Use a spreadsheet for a one-off list. Check the Free-plan limits before scheduling this in Make.

Sources: Make aggregator documentation (opens in a new tab); Make JSON documentation (opens in a new tab). Screenshots show fictional practice data.