Parse JSON API python

Question

I have the following json:

    [{'errors': [],
  'configErrors': [],
  'summary': {'pullrequest': {'overall': {'count': 0,
     'lastUpdated': None,
     'stateCount': 0,
     'state': 'OPEN',
     'open': True},
    'byInstanceType': {}},
   'build': {'overall': {'count': 0,
     'lastUpdated': None,
     'failedBuildCount': 0,
     'successfulBuildCount': 0,
     'unknownBuildCount': 0},
    'byInstanceType': {}},
   'review': {'overall': {'count': 0,
     'lastUpdated': None,
     'stateCount': 0,
     'state': None,
     'dueDate': None,
     'overDue': False,
     'completed': False},
    'byInstanceType': {}},
   'deployment-environment': {'overall': {'count': 0,
     'lastUpdated': None,
     'topEnvironments': [],
     'showProjects': False,
     'successfulCount': 0},
    'byInstanceType': {}},
   'repository': {'overall': {'count': 0, 'lastUpdated': None},
    'byInstanceType': {}},
   'branch': {'overall': {'count': 0, 'lastUpdated': None},
    'byInstanceType': {}}}}

I need to retrieve value count. I've tried with a loop for:

for item in json['summary']['pullreqest']['overall']:
     value = item['count']

but I have an error must be integers or slices, not str .

Melferas · Accepted Answer · 2021-06-30 11:26:17Z

3

The json looks like an array, I fixed a typo (pulrequest) and simplified the retrieval of the item.

item = json[0]['summary']['pullrequest']['overall']
print(item)
value = item['count']
print(value)

When you loop through json[0]['summary']... what you are doing is taking the keys, but not the tuples, so you could not do item['count'].

All in all you are working with a Python dictionary and are bound by its rules.

edited Jun 30, 2021 at 11:26

answered Jun 30, 2021 at 11:05

Melferas

3701 gold badge2 silver badges13 bronze badges

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

4 Comments

Melferas Over a year ago

@inspiredd Is that the whole JSON? Now that I look at it it's not valid.

inspiredd Over a year ago

I've added the whole JSON.

Melferas Over a year ago

@inspiredd fixed my answer, is a bit different but I hope you find it useful. Also your new JSON is still missing the "]" at the end, just in case!

inspiredd Over a year ago

thanks a lot. I had 'key error 0' but I deleted 0 and it works perfect.

Collectives™ on Stack Overflow

Parse JSON API python

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related