Python - Skip over key if it doesn't exist in json array

Question

I have big json array that lists out certain key value pairs. Each element in the array should look like this:

{
   "id" : "tmp3269879718695646867",
   "owner" : "johndoe",
   "x11-display" : ":7",
   "x11-authority" : "/run/user/1676/dcv/tmp3269879718695646867.xauth",
   "num-of-connections" : 0,
   "creation-time" : "2019-05-15T20:05:46.170274Z",
   "last-disconnection-time" : "2019-07-19T15:14:37.349168Z"
 },

I then attach a beginning square braket and an end square bracket at the end to make it valid JSON. Sometimes, there are around 100 elements in the array. Due to an software upgrade, if the user has not disconnected then the last-disconnection-time key does not appear on this output. What I want to do is loop over each element in the array, but skip the entire element if the last-disconnection-time key does not exist. This is what I have so far in the loop:

for item in json_array:
        session_details = {"owner":None, "num-of-connections":None, "last-disconnection-time":None}
        session_details['owner'] = item['owner']
        user = item['owner']
        session_details['num-of-connections'] = item['num-of-connections']
        session_details['last-disconnection-time'] = item['last-disconnection-time']
        # Format date
        ...

What I would like to do is check for the item each time it loops. Something like this:

for item in json_array:
        session_details = {"owner":None, "num-of-connections":None, "last-disconnection-time":None}
        session_details['owner'] = item['owner']
        user = item['owner']
        session_details['num-of-connections'] = item['num-of-connections']
        if "last-disconnection-time" in json_array:
                session_details['last-disconnection-time'] = item['last-disconnection-time']
        else:
                print("last-disconnection-time does not exist in this array item")
        # Format date
        ...

However I still get the KeyError when running the script.

You want if "last-disconnection-time" in item, not in json_array. — John Gordon
– John Gordon, Commented May 28, 2020 at 14:07

Gribek · Accepted Answer · 2020-05-28 16:51:24Z

1

You need to check if "last-disconnection-time" is in item. json_array is your entire list. item is a dictionary where you want to find out if the key exists.

if "last-disconnection-time" in item:

edited May 28, 2020 at 16:51

answered May 28, 2020 at 14:29

Gribek

2011 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

Python - Skip over key if it doesn't exist in json array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related