I’m working on an automation in Make where I fetch data from TimeTonic (airtable like), aggregate it using an Array Aggregator, and then send it as JSON in an HTTP request. However, when I try to map the data in the JSON module, all I get is "Array[]" without any details (no RowID, coordinates, etc.).
What I’ve Tried:
- Direct Mapping: I mapped the Array Aggregator output directly into JSON, but it only returns
"Array[]".
- Using “Map” toggle: Enabling “Map” in the JSON module doesn’t help. It still doesn’t extract the details.
- RTMO (Real-time Output Monitoring) Limitations: I can’t see a detailed RTMO from the Array Aggregator, making debugging difficult.
- Iterator Alternative: I tried adding an Iterator after the Array Aggregator to inspect the data, but I’m unsure how to properly re-aggregate it for the JSON structure.
Question:
How can I correctly extract and map the detailed values from the Array Aggregator into the JSON module, so that it includes each job’s details (ID, location, etc.) instead of just "Array[]"?
Any insights or workarounds would be greatly appreciated! 
Welcome to the Make community!
Why do you need to aggregate then iterate again?
What does the output of the trigger module look like?
To allow others to assist you with your scenario, please provide the following:
1. Scenario Blueprint
Please export the scenario blueprint. Providing your scenario blueprint file will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return - this would greatly benefit you in implementing our suggestions as you can simply paste module exports back into your scenario editor!
To export your scenario blueprint, click the three dots at the bottom of the editor then choose ‘Export Blueprint’.
You can upload the file here by clicking on this button:
2. Output Bundles of Modules
Please provide the output bundles of each of the relevant modules by running the scenario (you can also get this without re-running your scenario from the History tab).
Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.
A. Upload as a Text File
Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.
You can upload the file here by clicking on this button:
B. Insert as Formatted Code Block
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:
-
Method 1: Type code block manually
Add three backticks ``` before and after the content/bundle, like this:
```
content goes here
```
-
Method 2. Highlight and click the format button in the editor
Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved.
Sharing these details will make it easier for others to assist you.
Hi @samliew first I want to thank you for helping. I’ll do my best to provide you with information in the right format.
I am providing my client with an optimised road tool for when he goes on the field to collect information. I want him to put a starting point and a destination using latitude and longitude. Then I want to pass this information to an HTTP module using Openrouteservice. This should return an order from 1 to 10. I am using chatgpt.
At the beginning I had a " get table rows " module with all data in the output (as you can see enclosed). Then I wanted to pass those information in JSON to HTTP. The array aggregator was supposed to help me separate information into different section so the ORS module understand that there are many destination. But data never went through. I’ve never been able to separate them and send them to HTTP. I only had an array.
Then chatgpt told me to add a trigger so I replace "get table rows " with " watch records ".
I just want to pass that route to ORS in JSON in a way that it understands.
And now I am lost.
attachment](upload://m54vubsLhf8uXrXiUHvOIpijatw.pdf) (285.2 KB)
output bundle http2.txt (3.0 KB)
Hey Yannick,
from the screenshot it looks like you are aggregating the Get Table Rows module, then you are iterating the aggregator, then you are aggregating to json but doing it on the Get Table Rows module again and not on the iterator. Either delete the Array Aggregator and Iterator modules and use Aggregate to JSON directly on the Get Table Rows module, or change it to aggregate on the iterator instead.
