Help Aggregating Different Collections into One

Hi guys. I’m stuck. I am trying to create a new Airtable record (a case Matter) from data in another system (FileVine in this case). In FV, Projects have Sections, and within each section are the fields for that section. It is not possible to fetch all Project fields at once any other way.

As you can see, I have written a custom Make connector to fetch the sections and then fetch all fields from sections. This part is working.

Obviously the data structure from section to section is different. I have been attempting to use the Array Aggregator to consolidate these different fields into one array, but this has not worked in two ways:

  1. It only shows the first bundle’s available fields in the custom aggregation target structure, and
  2. The mappable properties in the end module (Airtable upsert) do not allow you to map all of the fields either.

To resolve this, I was assuming I’d need to aggregate all of the fields from the separate bundles into a single collection of key:value properties, taking in each property from each of the 5 bundles.

The inability to select ALL fields (rather than just the first bundle’s fields) for aggregation has made this impossible. Additionally, I have tried to set the output as a variable and apply functions like merge(), flatten(), and map() to squish the properties into a single array, but this has not worked either.

Anyone (1) know how to aggregate/combine property key:value pairs from dissimilarly structured bundles into a single bundle consisting of 1 collection of all values, (2) find a way to aggregate in such a way that the collection items can be mapped into the end structure, even if the collection items are in the form of an array of key:value pairs, or (3) have some other idea?

Thanks all!

Hello! Welcome to the Make Community!

Can you please send me a sample Sections and Section Fields JSON, as well as the structure (or an example) of the target JSON doc? It will be easier to try and help you with it.

Btw, nice Custom App! :star_struck:

Benjamin