Pymongo/bson: Convert python.cursor.Cursor object to serializable/JSON object

python json mongodb pymongo webapp2
Tarun Dugar picture Tarun Dugar · May 19, 2015 · Viewed 27.6k times · Source

New to MongoDb and Python (webapp2). So, I was fetching some data from a mongodb database. But I was unable to use json.dumps on the returned data. Here's my code:

exchangedata = db.Stock_Master.find({"Country": "PHILIPPINES"}, {"_id" : 0})        
self.response.write(json.dumps(exchangedata))

This throws an error:

TypeError: pymongo.cursor.Cursor object at 0x7fcd51230290 is not JSON serializable

The type of exchangedata is pymongo.cursor.Cursor. How can I convert it into a json object?

Answer

Bernie Hackett picture Bernie Hackett · May 22, 2015

Use dumps from bson.json_util:

>>> c = pymongo.MongoClient()
>>> c.test.test.count()
5
>>> from bson.json_util import dumps
>>> dumps(c.test.test.find())
'[{"_id": {"$oid": "555cb3a7fa5bd85b81d5a624"}}, {"_id": {"$oid": "555cb3a7fa5bd85b81d5a625"}}, {"_id": {"$oid": "555cb3a7fa5bd85b81d5a626"}}, {"_id": {"$oid": "555cb3a7fa5bd85b81d5a627"}}, {"_id": {"$oid": "555cb3a7fa5bd85b81d5a628"}}]'

Related questions

object is not JSON serializable

I'm having some trouble with Mongodb and Python (Flask). I have this api.py file, and I want all requests and responses to be in JSON, so I implement as such. # # Imports # from datetime import datetime from flask import Flask …

Read More
Unable to deserialize PyMongo ObjectId from JSON

I'm seemingly unable to deserialize my MongoDB JSON document with the BSON json_util. The json.loads function is choking on the ObjectId() string. I had understood json_util capable of handling MongoDB's ObjectId format and transforming into usable JSON. …

Read More
TypeError: ObjectId('') is not JSON serializable

My response back from MongoDB after querying an aggregated function on document using Python, It returns valid response and i can print it but can not return it. Error: TypeError: ObjectId('51948e86c25f4b1d1c0d303c') …

Read More