How to merge output of array aggregator with many collections into a json?

I need to reduce the size of JSON, I only need 3 variables from the original.

I have an array aggregator output with 1 array, with 3 variables per collection: ts, user, text

I have tried multiple ways of merging this into a JSON, but it either outputs the first collection only, or something else.

The merge formula doesn’t seem to be working as expected with the collections.

Welcome to the Make community!

Could you please share screenshots of all the module fields and filters in question? It would really help other community members to see what you’re looking at.

You can also export the scenario blueprint file to allow others to replicate the issue. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.


Uploading it here will look like this:

blueprint.json (12.3 KB)

If possible, could you also please provide the input/output bundles of the modules by running the scenario, then clicking the bubble on the top-right of each module, taking screenshots of, and copying the contents into this discussion thread:


This will allow others to better assist you. Thanks!