How to convert objectid to string

Question

I want to get the string character from an ObjectId object. I use pymongo. eg: ObjectId("543b591d91b9e510a06a42e2"), I want to get "543b591d91b9e510a06a42e2".

I see the doc, It says ObjectId.toString(), ObjectId.valueOf().

So I make this code: from bson.objectid import ObjectId.

But when I use ObjectId.valueOf(), It shows:

'ObjectId' object has no attribute 'valueOf'.

How can I get it? Thanks.

I had made it with `str(ObjectId)`. It works well. – Simon Oct 14 '14 at 18:33 — Simon, Oct 14 '14 at 18:33

score 132 · Answer 1 · answered Mar 12 '15 at 09:16

132

ObjectId.toString() and ObjectId.valueOf() are in Mongo JavaScript API.

In Python API (with PyMongo) proper way is to use pythonic str(object_id) as you suggested in comment, see documentation on ObjectId.

answered Mar 12 '15 at 09:16

rutsky

3,900
2
31
30

score 20 · Answer 2 · answered Mar 12 '15 at 11:49

20

ObjectId.toString() returns the string representation of the ObjectId() object.

In pymongo str(o) get a hex encoded version of ObjectId o.

Check this link.

answered Mar 12 '15 at 11:49

Kaushal

908
1
8
19

score 4 · Answer 3 · answered Sep 09 '21 at 23:29

What works for me is to "sanitize" the output so Pydantic doesn't get indigestion from an _id that is of type ObjectId...here's what works for me... I'm converting _id to a string before returning the output...

# Get One
@router.get("/{id}")
def get_one(id):
    query = {"_id": ObjectId(id)}
    resp = db.my_collection.find_one(query)

    if resp:
        resp['_id'] = str(resp['_id'])
        return resp
    else:
        raise HTTPException(status_code=404, detail=f"Unable to retrieve record")

score 2 · Answer 4 · answered Aug 24 '21 at 22:49

2

Use str(ObjectId), as already mentined in the comment by @Simon.

@app.route("/api/employee", methods=['POST'])
def create_employee():
    json = request.get_json()
    result = employee.insert_employee(json)
    return { "id": str(result.inserted_id) }

answered Aug 24 '21 at 22:49

Evandro Pomatti

13,341
16
97
165

score 2 · Answer 5 · edited Jan 24 '23 at 11:03

2

In python (Pymongo) there's no inbuilt method to do it so iterate over the result you fetched from db and then typecast _id to str(_id)

result = collection.find({query})

for docs in result:
    docs[_id] = str(docs[_id])

edited Jan 24 '23 at 11:03

Fedor

17,146
13
40
131

answered Jan 21 '23 at 12:02

Sanskar Gubreley

21
1

score 0 · Answer 6 · answered Jan 04 '23 at 15:06

0

This is an old thread, but as the existing answers didn't help me:

Having run

new_object = collection.insert_one(doc)

I was able to get the ObjectID with the inserted_id property:

print(f"{new_object.inserted_id}")

answered Jan 04 '23 at 15:06

DobbyTheElf

604
6
21

score -2 · Answer 7 · answered Nov 02 '22 at 05:05

-2

first you have to assign the Object Id value to a variable for example:

let objectId = ObjectId("543b591d91b9e510a06a42e2");

then use the toString method like this

let id = objectId.toString();

answered Nov 02 '22 at 05:05

Kalimuthu K

5
2

This would only work on JavaScript but assuming one is working with Python then objectID won't have toString(). If using python just do str(ObjectId) – user8291021 Mar 01 '23 at 06:22

How to convert objectid to string

7 Answers7