Remove BSON Object ID when querying mongo DB using pymongo

Question

I'm using Pymongo and flask to build a rest API, and the documents are stored in the following BSON format:

{'_id': ObjectId('123'), 'title':"test"}

how can I query the Mongo DB to get the document in the following format or convert the query result to the following format?

{'_id':'123', 'title':"test"}

Possible duplicate of Return .str of ObjectID using pymongo

Gustavo Bezerra
– Gustavo Bezerra

2019-06-12 03:16:05 +00:00
Commented Jun 12, 2019 at 3:16 — Gustavo Bezerra
– Gustavo Bezerra, Commented Jun 12, 2019 at 3:16

Gustavo Bezerra · Accepted Answer · 2019-06-12 03:09:22Z

4

You can apply str to your ObjectId:

item = {'_id': ObjectId('123'), 'title':"test"}
item['_id'] = str(item['_id'])

answered Jun 12, 2019 at 3:09

Gustavo Bezerra

11.2k4 gold badges45 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

vkt Over a year ago

thanks for the reply, yes I ended up doing this, was wondering if there any better way to achieve this using BSON API?

Gustavo Bezerra Over a year ago

You can change the type used by the document through the MongoClient constructor document_class parameter (defaults to dict), but I am not aware of any way to change the serialization of a specific field.

Bryce Wayne · Accepted Answer · 2019-06-12 20:42:05Z

1

I am assuming that you wish to rename the _id of the document in the collection. You can do this by querying the database collection then replacing the document in the collection.

myquery = {'title':"test"}
# _ = col.find(myquery)
# To check if it exists
y = db['my collection'].update_one(myquery, {"$set": {'_id': '123'}})

Hope it helps. If you give me more info about database and collection I could help more.

edited Jun 12, 2019 at 20:42

answered Jun 12, 2019 at 2:56

Bryce Wayne

3515 silver badges18 bronze badges

3 Comments

vkt Over a year ago

Hi Bryce, thanks for the reply. No, I don't want to update the database, I need to convert the document to a proper JSON format when sending the result via rest API {'_id':'123', 'title':"test"}

Bryce Wayne Over a year ago

Ah, ok. Well, this will replace your ObjectID('123') to '123'

vkt Over a year ago

Yes, I don't want to make changes to Database. I want to keep the data in BSON format in the mongo but want to convert that to above-expected format when sending to the client.

Collectives™ on Stack Overflow

Remove BSON Object ID when querying mongo DB using pymongo

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related