Unable to use JSON file using python

Question

{
  "id": "APA91bE9N6D9Tp79gv1kUgWLhsCmbKPKJQlzgtr1iGKlL5249bzD5DxySBiaIzDmk7rOAdrWcNcP0ZxPnaj7e6Esc _iGIYJlDte-E1pMO9GME4QufgdQQOIccM2tExMd9L9RsQthR3160KbQeRmtfxW6gvuPXYN0zw",
  "platform": "android",
  "user": ObjectId("545b2833b21e898413de9314"),
  "_id": ObjectId("545b5e76d6be01755625b284"),
  "createdAt": Date(1415274102856),
  "__v": 0
}{
  "__v": 0,
  "_id": ObjectId("545b67c4d6be01755625b2c1"),
  "createdAt": Date(1415276484321),
  "id": "APA91bFRxirYHIko33D1LiHODpBd77IlRhebK4tMRWecFxb5E6nfWSMFarr5mlwmY9bPQP56DGP7cnli4_jOrS8Ynn3Y9w9uaRoESoEPglqR-rA-3phsh8UtSxMC5lNoOqIrohz3hBjzzpCH_vExwo6B5yV6Mb8jyg",
  "platform": "android",
  "user": ObjectId("545b69a5d6be01755625b2d2")
}

Here is the content of the JSON File.

Code which i am using for importing is:

import json

with open("test.json") as json_file:
    json_data = json.load(json_file)
    print(json_data)

That's not JSON: "user" : ObjectId("545b69a5d6be01755625b2d2" ). — Ulrich Eckhardt
– Ulrich Eckhardt, Commented Nov 26, 2014 at 7:05
I was wondering the same. But this is what i got when i dumped the BSON file into JSON format in mongoDB. I'll try to make it if this is the problem. Thanx — Yash Rastogi
– Yash Rastogi, Commented Nov 26, 2014 at 7:08
you need to explain about your problem for us , if you expect we help you !!! Also as mentioned in above its not a valid JSON file ! — Kasravnd
– Kasravnd, Commented Nov 26, 2014 at 7:09
It looks like MongoDB query result. You have to handle ObjectId, Date, etc. — Puffin GDI
– Puffin GDI, Commented Nov 26, 2014 at 7:09
If that is what MongoDB gives you as "JSON", then others will have stumbled across the same problem and you should be able to find solutions if you add the term "MongoDB" to you search. — Ulrich Eckhardt
– Ulrich Eckhardt, Commented Nov 26, 2014 at 7:10

vatsal mevada · Accepted Answer · 2014-11-26 07:14:17Z

1

As @Puffin pointed out you need to handle ObjectId, Date etc if you are dumping a MongoDB BSON into JSON and accessing it.

If possible then use pymongo to access MongoDB directly from Python rather than dumping into JSON and accessing the data.

answered Nov 26, 2014 at 7:14

vatsal mevada

5,7368 gold badges48 silver badges74 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:20:31Z

1

Your first string is not valid JSON. It is not possible to ingest this directly to JSON parser. What I would do, is to write a preprocessor, which expands the non JSON elements like ObjectId or Date to e.g. strings. Something in the line of this answer.

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Nov 26, 2014 at 7:14

Joachim Rosskopf

1,2592 gold badges13 silver badges26 bronze badges

Collectives™ on Stack Overflow

Unable to use JSON file using python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related