I got documents from MongoDB. I want to print this documents as a list of dictionary using Python. How can I do it?

Assuming you have retrieved the documents from MongoDB using a library such as PyMongo, you can iterate over the result cursor and create a list of dictionaries.

Here is an example code snippet:

import pymongo # Create a client to connect to MongoDB client = pymongo.MongoClient("mongodb://localhost:27017/") # Select a database and collection db = client["mydatabase"] collection = db["mycollection"] # Retrieve documents from the collection documents = collection.find() # Create a list of dictionaries from the documents result = [] for document in documents: result.append(dict(document)) # Print the result print(result)

I used your method, but the FastAPI replied error message ValueError: [TypeError("'ObjectId' object is not iterable"), TypeError('vars() argument must have __dict__ attribute')]

The error message you're seeing suggests that there might be an issue with the type of data you're trying to convert to a dictionary.

It's possible that one or more of the documents retrieved from MongoDB contain fields that cannot be directly converted to a dictionary, such as ObjectId objects.

To work around this issue, you can manually convert the fields that are causing the problem to a string or another appropriate type before converting the entire document to a dictionary. Here's an example of how you could modify the code to do this:

import pymongo # Create a client to connect to MongoDB client = pymongo.MongoClient("mongodb://localhost:27017/") # Select a database and collection db = client["mydatabase"] collection = db["mycollection"] # Retrieve documents from the collection documents = collection.find() # Create a list of dictionaries from the documents result = [] for document in documents: # Convert ObjectId to string document['_id'] = str(document['_id']) # Convert other problematic fields to appropriate types or strings # ... # Convert entire document to dictionary result.append(dict(document)) # Print the result print(result)