JSON format for MongoDB import

[simonengelke]

It would be great to get a JSON file which can easily be imported into MongoDB (at the moment I get only one document with "mongoimport" for an entire spreadsheets with multiple rows). Here is an example for a working JSON file from MongoDB: https://raw.githubusercontent.com/mongodb/docs-assets/primer-dataset/primer-dataset.json

[Synthoid]

Should be possible. In this case, each sheet row would be exported as a JSON blob confined to a single line of the exported file? Meaning that each line could be read in as a standalone JSON blob, correct?

[simonengelke]

Yes, exactly.

[flutter-painter]

Hi, Sacha found a way to push from spreadsheet to mongo through Stitch. There should be a way to broaden the code / scheme outside of our specific case

[flutter-painter]

Here is a google sheet script template :

Here is a stitch webhook template :

Doc from mongo on how to create the 3rd party service in mongo : https://docs.mongodb.com/stitch/getting-started/integrate-third-party-services/

@Synthoid please let me know if this works on your side