How do I import json file using pymongo?

Question

I try using this but it won't work.

from pymongo import MongoClient
import json
client = MongoClient('localhost', 27017)
client('mongoimport --db myDatabase --collection restaurants --file c:\restaurants\restaurants.json')
print ('json import sucessfully')

Greatly appreciate of any helps. Thanks

Answer 1

Similar to this answer, mongoimport is a command-line program and not in the PyMongo API.

However you can use a different approach:

from pymongo import MongoClient
import json
client = MongoClient('localhost', 27017)
with open('restaurants.json') as f:
    data = json.load(f)
client['myDatabase']['restaurants'].insert_many(data)

If your json file is too big, you can use the subprocess lib to run the command-line program inside a python program. Check some SO answers here or here