Kedar Kedar - 1 year ago 152
JSON Question

PyMongo: BSON to JSON dict conversion (dumps returns a JSON string)

Snippet that fetches records from MongoDB using pymongo client

from bson.json_util import dumps

cursor = db.collections.find({"Test": "Sample"})

for msg in cursor:
json_msg = dumps(msg)

However, the json_msg is of type string. Is there a way to get JSON object which can be traversed in something like a dict? I want to process the retrieved JSON objects while traversing through them.

I tried
, but that converts the json_msg back to BSON format again.

Edit: I am not looking to just print (which is possible by printing string); however, to iterate and process the JSON object.

Answer Source

The value returned from collections.find is already a Python dict, which you can iterate. dumps will convert it to a string; so don't dump it, just use it.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download