+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Load JSON file data into mongodb using pymongo (/thread-19380.html)
Load JSON file data into mongodb using pymongo - klllmmm - Jun-26-2019
I want to load JSON data into MongoDB using pymongo library.
I found that JSON data can be directly load using mongoimport using the command prompt using the following command.
mongoimport --db myTestDB --collection myTestCollection_Table --jsonArray --file D:\path\myJson1.json
But I want to how to do this using python pymongo library(without specifying keys or values separately in the code. as it is done in the above method)
I managed to load the JSON file data into python.
with open(r'D:\path\example_2.json', 'r') as f: data = json.load(f)Appreciate if you can give some inputs on how to load above data into mongodb using python.
RE: Load JSON file data into mongodb using pymongo - klllmmm - Jun-28-2019
Managed to solve my issue.
import pymongo mng_client = pymongo.MongoClient('localhost', 27017) mng_db = mng_client['UNSdatabase'] # Replace mongo db name collection_name = 'UNS_Collection2' # Replace mongo db collection name db_cm = mng_db[collection_name] # Get the data from JSON file with open(r'D:\path\example_2.json', 'r') as data_file: data_json = json.load(data_file) #Insert Data db_cm.remove() db_cm.insert(data_json) # Query data db_cm.UNS_Collection2.find().pretty()