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 :

<script src="https://gist.github.com/926/48fcea8ae4343c009e23d5b4ae300558.js"></script>

Here is a stitch webhook template :

<script src="https://gist.github.com/926/192f8fca182d904717e06ec12d75a8d7.js"></script>

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