Python Forum

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.

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()