I need to call mongoexport remotely and get the result from node.js

Question

I'm not sure how to go about this, I need to export a mongodb collection as an .csv. Calling mongoexport with spawn.child_process in node will accomplish this but my mongodb server and node server are currently on separate machines. How can I remotely call mongoexport on my mongo server from my node server and then get the .csv to the node server?

Accepted Answer

First, make sure the MongoDB port is opened and you can connect from the server. Then, use

```
mongoexport --username user --password pass --host host --db database --collection coll --type=csv --fields=displayName,emailAddress --query='{"status": "verified"}' -o users-YEAR-DAY-MONTH.csv
```

If the server it's in a public network make sure to use authentication.

https://docs.mongodb.com/manual/security/

Alternatively, it might be simpler to run an ssh command, run `mongoexport` on the MongoDb server and then `sftp` back the file (maybe zip it first).

More info on mongoexport

I need to call mongoexport remotely and get the result from node.js

Solution

Problem