Parsing API Json (dictionary) response using python

Question

I'm trying to parse a nested dictionary looking json response from a API URL. I'm trying to get the 'id' and 'symbol' and put it in to a list so that I can merge it with another list later.

I have tried:

try:
response = session.get(url, params=parameters)
data = json.loads(response.text)
for x in data:
print(data['data'][0]['id'])

But it just returns "1" two times so i'm guessing the loop is not within the dictionary

print(type(data))
<class 'dict'>

I would need a loop to get every iteration of 'id' and 'symbol' and append it to a list.

   {
  "status": {
    "timestamp": "2021-11-13T20:50:29.375Z",
    "error_code": 0,
    "error_message": null,
    "elapsed": 11,
    "credit_count": 1,
    "notice": null
  },
  "data": [
    {
      "id": 1,
      "name": "Bitcoin",
      "symbol": "BTC",
      "slug": "bitcoin",
      "rank": 1,
      "is_active": 1,
      "first_historical_data": "2013-04-28T18:47:21.000Z",
      "last_historical_data": "2021-11-13T20:39:02.000Z",
      "platform": null
    },
    {
      "id": 2,
      "name": "Litecoin",
      "symbol": "LTC",
      "slug": "litecoin",
      "rank": 14,
      "is_active": 1,
      "first_historical_data": "2013-04-28T18:47:22.000Z",
      "last_historical_data": "2021-11-13T20:39:02.000Z",
      "platform": null
    },
    {
      "id": 3,
      "name": "Namecoin",
      "symbol": "NMC",
      "slug": "namecoin",
      "rank": 778,
      "is_active": 1,
      "first_historical_data": "2013-04-28T18:47:22.000Z",
      "last_historical_data": "2021-11-13T20:39:02.000Z",
      "platform": null
    },
    {
      "id": 4,
      "name": "Terracoin",
      "symbol": "TRC",
      "slug": "terracoin",
      "rank": 2062,
      "is_active": 1,
      "first_historical_data": "2013-04-28T18:47:22.000Z",
      "last_historical_data": "2021-11-13T20:39:03.000Z",
      "platform": null
    },
    {
      "id": 5,
      "name": "Peercoin",
      "symbol": "PPC",
      "slug": "peercoin",
      "rank": 707,
      "is_active": 1,
      "first_historical_data": "2013-04-28T18:47:23.000Z",
      "last_historical_data": "2021-11-13T20:39:02.000Z",
      "platform": null
    }
  ]
}

Any help is much appreciated.

Jeremy Caney · Accepted Answer · 2021-11-14 00:57:29Z

2

Here's one approach:

response = session.get(url, params=parameters)
data = json.loads(response.text)
for x in data:
    print(x['data'][0]['id'])

Here's another way:

response = session.get(url, params=parameters)
data = json.loads(response.text)
for x in data["data"]:
    print(x['id'])

And here's a beautiful way:

response = session.get(url, params=parameters).json()
for x in response:
    print(x['data'][0]['id'])

And, finally, a beautiful way if you need to use the response data in other ways:

response = session.get(url, params=parameters)
for x in response.json():
    print(x['data'][0]['id'])

edited Nov 14, 2021 at 0:57

Jeremy Caney

7,808115 gold badges58 silver badges86 bronze badges

answered Nov 13, 2021 at 22:48

Владислав Копяков

361 bronze badge

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

Collectives™ on Stack Overflow

Parsing API Json (dictionary) response using python

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