The other JSON is a more complicated but it has objects with matching "externalId" keys.

Is this a one-time thing, our is it a growing collection of data?

If it is the latter, i recommend a couple of tables in a database. Just add the new data to the db, and export as needed.

With a proper example of BOTH files WITH the matching IDs, i could probably cobble together a simple example of scripts.