How do you merge arrays from different bundles

I’m having a hell of a time mapping the outputs of different operations and bundles and then updating them.

I’m trying to import items from Scrivener which are exported in content-metadata pairs. The filename of the content is in the form “Content whatever” and that of the the metadata is “Content whatever MetaData”. I’ve managed to import them into a datastore with content files in rows and the metadata files in their rows with the metadata nicely parsed etc. I’ve also tagged the content with the name of its matching metadata by appending " MetaData" to its filename and store it in the “MetaData” column. This part is in
blueprint_6.3.json (58.5 KB).

The problem I’m stuck on is merging the parsed metadata columns (in the METADATA rows) with the content rows. My latest attempt is in
blueprint_7.json (19.7 KB).

I’ve viewed a crap load of help articles, posts, How to’s and videos, and am now spinning my wheels in circles.

Any help would be vastly appreciated.

Thanks!
Marc A.

Hi @Marc_A

To merge data, you can use the Array Aggregator module.

To merge in a customized manner, please create a JSON with the required structure. This will populate the same in the Array Aggregator module.

For more details, refer to the below link:
https://www.make.com/en/help/tools/json#transforming-data-records-to-json

Regards,
Msquare Automation - Gold Partner of Make

Book a Free Consultation | Connect Live

Explore our YouTube Channel for valuable insights and updates!

Read it more than once. I might be missing some fundamental concept because I’ve read tons of little tidbits like that and none of them helped with this particular problem.

Can you elaborate?

Thanks

1 Like

Hi again @Msquare_Automation,

I’ve done as you suggested but don’t see how I’m any further ahead.
blueprint_7.1.json (19.7 KB)

What I can’t get me head around is how to access, modify, etc. the object that contains all 4 bundles – from 4 different operations – so that I can merge (for example) the collection in bundle 1 from operation 1 with the one from operation 2 into a single object (collection/array) containing ‘MD Title’ (the record ‘key’), ‘MD ID’ and ‘Content ID’.

The resulting JSON presents me with the same issue.

Thanks again!
Marc