Retrieve embedded values from MongoDB Object (Using CherryPy Framework)

Question

I've inserted the following document in MongoDB:

@cherrypyexpose
def create(self):
    client = MongoClient()
    db = client.database_name        
    result = db.users.insert_one({
        "email": "[email protected]",
        "company": {
            "name": "ABC Company"
        }
     })

I would now like to retrieve the company.name which is "ABC Company".

@cherrypy.expose
def result(self):
    client = MongoClient()
    db = client.database_name        
    cursor = db.users.find({"email":"[email protected]"})
    for document in cursor:
        value = document["company.name"]
    return value

I have tried to retrieve this value using the following syntax "company.name" as I would do on relational databases but I'm getting this error: "KeyError: 'company.name'"

What would be the correct syntax to retrieve "company.name" on Mongo?

Answer 1

That mongo document is returned as a standard nested python dictionary. So:

value = document["company.name"]

Should be

value = document["company"]["name"]