Creating a proper JSON string using python

Question

Hi I am new to python programming. Here I use dumps to get the output from my mongodb. But I get a malformed JSON string error in PostMan.

My Code is:

cursor = db.Details.find()
    for document in (yield cursor.to_list(length=100)):
        self.write(bson.json_util.dumps(document))

My output is:

{"Name": "Will","_id": {"$oid": "55a8f075a382c32392b75bad"}}
{"Name": "Alex", "_id": {"$oid": "55acc2205d8882ef8a667d34"}}
{"data": null, "status": "success"}

How I want my output to be:

{"data": [
   {"Name": "Will","_id": {"$oid": "55a8f075a382c32392b75bad"}},
   {"Name": "Alex", "_id": {"$oid": "55acc2205d8882ef8a667d34"}}
], "status": "success"}

Please help me.

Thanks in advance

My Output screenshot from PostMan enter image description here

see also stackoverflow.com/questions/31514500

John Mee
– John Mee

2015-07-21 05:45:49 +00:00
Commented Jul 21, 2015 at 5:45 — John Mee
– John Mee, Commented Jul 21, 2015 at 5:45

adrianus · Accepted Answer · 2015-07-21 05:55:00Z

2

How about you first save everything in a list and then dump that list to json?

data = []
cursor = db.Details.find()
    for document in (yield cursor.to_list(length=100)):
        data.append(document)

self.write(bson.json_util.dumps({"data": data}))

Edit: For getting the success variable like your desired output, you could try

data = []
status = ""

cursor = db.Details.find()
    for document in (yield cursor.to_list(length=100)):
        if 'status' in document: # check if key 'status' in document
            status = document[status]
        else:
            data.append(document)

self.write(bson.json_util.dumps({"data": data, "status": status}))

edited Jul 21, 2015 at 5:55

answered Jul 21, 2015 at 5:39

adrianus

3,2411 gold badge25 silver badges42 bronze badges

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

5 Comments

Blakes Seven Over a year ago

Good luck. But you get my vote. Various people have tried to tell the OP the same thing now for days. Add a "success" key and value in the final dict and it should mirror exactly what is asked for.

adrianus Over a year ago

Ok...? I just noticed the success key was missing in my output :) @tony-roczz Does this work for you?

Tony Roczz Over a year ago

@adrianus Thanks for the help it works. My output is as desired. But I am getting this {"status": "success", "data": null} additionally. Anyway to solve that

adrianus Over a year ago

@TonyRoczz I'm sorry, I mistyped (key success instead of status), could you try again?

Tony Roczz Over a year ago

@adrianus It works thank you after my output I am getting the {"status": "success", "data": null}. Is there way to avoid this.

Collectives™ on Stack Overflow

Creating a proper JSON string using python

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related