MongoDB: BSON to JSON

json node.js mongodb bson
johnny picture johnny · May 3, 2012 · Viewed 12.9k times · Source

I'm using the native mongoDB driver for node.js. I'd like to get some data from the database and send it as a JSON string via HTTP. Is there a way to convert the BSON to JSON or directly retrieve the data as JSON from the database?

Thanks!

Answer

Ivo Bosticky picture Ivo Bosticky · May 4, 2012

In python you can use the simplejson encoder to convert bson to json as follows:

result = db.mycol.find({ ....})
json = simplejson.dumps(result)

It will convert all simple objects, but will have difficulties with others, for example datetime will not work. To deal with this issue the following may work: MongoDB Object Serialized as JSON

Related questions

MongoDB can't update document because _id is string, not ObjectId

I'm doing a rest api to exchange data between a mongo database and a web app. These data are json formatted. I have a trouble when it comes to update a document: cannot change _id of a document. As a …

Read More
Return certain fields with .populate() from Mongoose

I'm getting returned a JSON value from MongoDB after I run my query. The problem is I do not want to return all the JSON associated with my return, I tried searching the docs and didn't find a proper way …

Read More
Reading, writing and storing JSON with Node on Heroku

I am building an App based on Node.js running on Heroku. The app uses a JSON file which at the moment is being pushed with the rest of the app, and we are reading and writing to it like …

Read More