How to access specific parts of JSON for API call - Python

Question

I want to access 'employmentName' and 'jobTile' values. But I keep on getting this error - KeyError: 'jobTitle' and KeyError: 'employmentName'

Here is my code below, please note I am not sharing the api URL on this question but it is present and working in the code.

api_three_url = "https://xxxx"
json_data_three = requests.get(api_three_url, headers=my_headers).json()
#print(json_data_three) #this prints the whole json data (working!)

print("So you have previously worked in", json_data_three['employmentName'],"as a", json_data_three['jobTitle'])

This is what the JSON looks like in python dict:

{
    'hasAddedValue': False,
    'employments': [{
        'id': 527,
        'employmentName': 'Sallys hair',
        'jobTitle': 'Stylists',
        'jobStartDate': '2019-03',
        'jobEndDate': '2020-04',
        'jobType': 'PAID',
        'status': True,
        'isJobCurrent': False
    }]
}

Please guide me to where I am going wrong.

Many thanks :)

json_data_three["employments"][0]["employmentName"]

crissal
– crissal

2021-07-28 14:22:35 +00:00
Commented Jul 28, 2021 at 14:22 — crissal
– crissal, Commented Jul 28, 2021 at 14:22

MrJuicyBacon · Accepted Answer · 2021-07-28 14:25:26Z

1

The employmentName and jobType fields are not at the top level in your JSON, hence Python is giving you KeyError. They are actually in one of the objects inside employments.

So if you want to obtain those fields from the first object inside employments, it would be:

json_data_three['employments'][0]['employmentName']

answered Jul 28, 2021 at 14:25

MrJuicyBacon

3262 silver badges9 bronze badges

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

1 Comment

CodePrincess Over a year ago

Yes I understand, all working now many thanks!

Collectives™ on Stack Overflow

How to access specific parts of JSON for API call - Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related