How to convert cursor list to JSON format in python?

Question

I am receiving an output like [<ColletionName: ColletionName object>]. But when I try using json dumps and loads as shown below, it returns only the heading of the table and not along with the body.

   return loads(dumps(cursor))

This returns only the table headers and not along with the value. How to get the complete values in JSON format from cursor list using python/pymongo?

Belly Buster · Accepted Answer · 2020-06-23 13:57:58Z

1

Convert the cursor to a list:

return loads(dumps(list(cursor)))

answered Jun 23, 2020 at 13:57

Belly Buster

8,9142 gold badges12 silver badges25 bronze badges

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

2 Comments

Navi Over a year ago

This too returns only the headers in a list

Belly Buster Over a year ago

How is cursor created?

Santhosh · Accepted Answer · 2020-06-24 11:53:11Z

0

Just use a for loop.

for i in cursor_list:
    print i.id (the header)

answered Jun 24, 2020 at 11:53

Santhosh

2292 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to convert cursor list to JSON format in python?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related