Navigation through json (python)

Question

I'm trying to navigation through a json file but cannot parse properly the 'headliner' node.

Here is my JSON file :

{  
   "resultsPage":{  
      "results":{  
         "calendarEntry":[  
            {
              "event":{  
                 "id":38862824,
                 "artistName":"Raphael",
               },
               "performance":[  
                  {  
                     "id":73632729,
                     "headlinerName":"Top-Secret",
                  }
               }
            ],
            "venue":{  
               "id":4285819,
               "displayName":"Sacré"
            }
         }
      }
   }

Here is what I my trying to do :

for item in data ["resultsPage"]["results"]["calendarEntry"]:
    artistname = item["event"]["artistName"]
    headliner = item["performance"]["headlinerName"]

I don't understand why it's working for the 'artistName' but it's not working for 'headlinerName'. Thanks for your help and your explanation.

Because "performance" is an array, not an object. You'd want to use something like: item["performance"][0]["headliner"] for the headliner within the first object. Or else roll out another loop there and use it instead of [0]. — UltraInstinct
– UltraInstinct, Commented Aug 7, 2019 at 20:38

R4444 · Accepted Answer · 2019-08-07 20:40:47Z

1

Notice your performance key:

"performance":[  
                  {  
                     "id":73632729,
                     "headlinerName":"Top-Secret",
                  }
               }
            ],

The json you posted is malformed. Assuming the structure is like:

"performance":[  
                      {  
                         "id":73632729,
                         "headlinerName":"Top-Secret",
                      }

              ],

You can do:

for i in item:
    i["headlinerName"]

or as @UltraInstinct suggested:

item["performance"][0]["headlinerName"]

answered Aug 7, 2019 at 20:40

R4444

2,1242 gold badges23 silver badges34 bronze badges

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

Comments

user1532172 · Accepted Answer · 2019-08-07 20:41:16Z

A few problems here. First, your JSON is incorrectly formatted. Your square brackets don't match up. Maybe you meant something like this? I am going to assume "calendarEntry" is a list here and everything else is an object. Usually lists are made plural, i.e. "calendarEntries".

{  
   "resultsPage": {
      "results": {  
         "calendarEntries": [  
            {
              "event": {  
                 "id": 38862824,
                 "artistName": "Raphael"
               },
               "performance": {
                  "id": 73632729,
                  "headlinerName": "Top-Secret"
               },
               "venue": {  
                  "id": 4285819,
                  "displayName": "Sacré"
               }
            }
         ]
      }
   }
}

Collectives™ on Stack Overflow

Navigation through json (python)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related