Keyerror when using Json in python

Question

I'm using a basic script to retrieve some trading data from an exchange, here is the response:

{'info': {'symbol': 'ETHBTC',
  'orderListId': -1,
  'price': '0.01083700',
  'origQty': '0.01800000',
  'executedQty': '0.00000000',
  'cummulativeQuoteQty': '0.00000000',
  'status': 'NEW',
  'timeInForce': 'GTC',
  'type': 'LIMIT',
  'side': 'BUY',
  'stopPrice': '0.00000000',
  'icebergQty': '0.00000000',
  'time': 1567078061338,
  'updateTime': 1567078061338,
  'isWorking': True}}

Now i want to print some parts of this response individually.

If i try:

tot = exchange.fetch_open_orders()
    for x in tot:
        print(x['symbol'])

I'll get: 'ETHBTC'. Until now, everything is normal.

But if i try:

tot = exchange.fetch_open_orders()
    for x in tot:
        print(x['origQty'])

I get a KeyError: 'origQty', which is weird, because this error should appear when i try to reference a parameter which doesn't exist, but it exists, since it is in my response. What am i doing wrong?

can you post the full script ? I tried with this json. I was able to get that origQty. — Ishan Arora
– Ishan Arora, Commented Aug 31, 2019 at 9:25
You'll need to show more of your code. What is tot? It can't be that dict you show, because iterating through a dict gives you just the keys. — Daniel Roseman
– Daniel Roseman, Commented Aug 31, 2019 at 9:26
What is tot? If it is the response dictionary then I would expect the first example to fail too — Iain Shelvington
– Iain Shelvington, Commented Aug 31, 2019 at 9:26
I'm sorry everyone. I just udated my question, now you can see where tot comes from — Jack022
– Jack022, Commented Aug 31, 2019 at 10:33

Akash Pagar · Accepted Answer · 2019-08-31 09:50:59Z

1

Here you iterating dictionary on keys, so each time you are trying to get value from key, that's why it is giving KeyError. This occurs when a key which is not present in a dictionary and still it accessed. This can be achieved by following way.

for x in tot:
    print(tot[x].get('symbol'))
    print(tot[x].get('origQty'))

Give output

ETHBTC
0.01800000

answered Aug 31, 2019 at 9:50

Akash Pagar

64711 silver badges28 bronze badges

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

Comments

Akash Kumar · Accepted Answer · 2019-08-31 09:29:04Z

0

I am not sure what is the format of tot. But you can try this.

for x, v in dict(tot).items():
    print(v['symbol'])
    print(v['origQty'])

Output:

ETHBTC
0.01800000

answered Aug 31, 2019 at 9:29

Akash Kumar

1,4061 gold badge13 silver badges30 bronze badges

Collectives™ on Stack Overflow

Keyerror when using Json in 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