How to not overwrite index in json.loads

Question

I have the followin json and I want to load it in python without overwriting the multiple index:

{
  "data": [
    {
      "HOSTNAME": "test",
      "STATUS": "200",
      "TYPE": "linux",
      "CPU": {
        "SRC": "src",
        "LINK": "link",
        "LABEL": "cpu"
      },
      "CPU": {
        "SRC": "src",
        "LINK": "link",
        "LABEL": "cpu"
      },
      "MEMORY": {
        "SRC": "src",
        "LINK": "link",
        "LABEL": "cpu"
      }
    }
  ]
}

I'm using:

 json.loads("HERE COMES THE JSON")

The result overwrite the index, example:

 {
 data:
     [
     {
      "HOSTNAME": "test",
      "STATUS": "200",
      "TYPE": "linux",
      "CPU": {
             "SRC": "src",
             "LINK": "link",
             "LABEL": "cpu"
             },
      "MEMORY": {
                "SRC": "src",
                "LINK": "link",
                "LABEL": "cpu"
                }
      }
      ]
 }

Note that is only one CPU.

Is there any way to not overwrite it?

score 3 · Accepted Answer · edited May 23 '17 at 12:29

3

The file is not valid JSON and you cannot use the json module to parse it the way you want to.

UPDATE: it seems that it's possible after all with the help of the object_pairs_hook parameter to json.load(s); see SimpleJson handling of same named entities for an example.

edited May 23 '17 at 12:29

Community

1
1

answered Oct 01 '13 at 11:48

Erik Kaplun

37,128
15
99
111

I edited, now is a valid, rsrs sorry – brunozrk Oct 01 '13 at 11:50
2

It's invalid JSON because it has repetitive keys—this is not allowed by the JSON specification; anyway, I've provided a link to a solution that works even with your quasi-JSON data. – Erik Kaplun Oct 01 '13 at 11:52
"It worked" is usually expressed on Stack Overflow by accepting the question ;) – Erik Kaplun Oct 01 '13 at 11:57
Im waiting the time to accept rsrs – brunozrk Oct 01 '13 at 11:59

How to not overwrite index in json.loads

1 Answers1