Accessing values in json using python

Question

I have a JSON string as below

typ_json="{'FromPort': 80, 'IpProtocol': 'tcp', 'IpRanges': [{'CidrIp': '0.0.0.0/0'}], 'Ipv6Ranges': [{'CidrIpv6': '::/0'}], 'PrefixListIds': [], 'ToPort': 80, 'UserIdGroupPairs': []}"

I want to access FromPort and ToPort Values.

I have tried print(typ_json['FromPort'])

But I get the error:

TypeError: list indices must be integers or slices, not str

I'd also recommend that you use typ_json.get(key) instead of directly accessing the key, as it might not exist. — Luca Bezerra
– Luca Bezerra, Commented Apr 16, 2019 at 12:20
That's not valid JSON. It looks like a Python dictionary converted to str. — Mark Tolonen
– Mark Tolonen, Commented Apr 16, 2019 at 12:24
The question and the error is misleading. TypeError: list indices must be integers or slices, not str suggests it is a list, but what you showed is a str — han solo
– han solo, Commented Apr 16, 2019 at 12:48

Jeril · Accepted Answer · 2019-04-16 12:19:26Z

3

you need to convert the json to dictionary

import json
data = json.loads(typ_json)
print(data['FromPort'])

Sometimes json might give some error. In that case you can use ast.literal_eval

import ast
data = ast.literal_eval(typ_json)
print(data['FromPort'])

answered Apr 16, 2019 at 12:19

Jeril

8,6316 gold badges60 silver badges73 bronze badges

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

Comments

han solo · Accepted Answer · 2019-04-16 12:22:14Z

0

That is not valid JSON. You need to replace the quotes and load the resulting string like,

>>> import json
>>> typ_json
"{'FromPort': 80, 'IpProtocol': 'tcp', 'IpRanges': [{'CidrIp': '0.0.0.0/0'}], 'Ipv6Ranges': [{'CidrIpv6': '::/0'}], 'PrefixListIds': [], 'ToPort': 80, 'UserIdGroupPairs': []}"
>>> x = typ_json.replace("'", '"')
>>> json.loads(x) # now it is a `dict` and you can access the values
{u'PrefixListIds': [], u'FromPort': 80, u'IpRanges': [{u'CidrIp': u'0.0.0.0/0'}], u'ToPort': 80, u'IpProtocol': u'tcp', u'UserIdGroupPairs': [], u'Ipv6Ranges': [{u'CidrIpv6': u'::/0'}]}
>>> json.loads(x)['FromPort']
80

answered Apr 16, 2019 at 12:22

han solo

6,6501 gold badge20 silver badges22 bronze badges

4 Comments

Tushar Raichand Over a year ago

I get this error AttributeError: 'dict' object has no attribute 'replace'

han solo Over a year ago

Then your typ_json was already a dict then. But what you showed in the question, suggested it was an str

Tushar Raichand Over a year ago

Assuming it is already a dict how can i access FromPort Value?

han solo Over a year ago

typ_json['FromPort'] will give you that

cullzie · Accepted Answer · 2019-12-20 09:29:45Z

-1

import json
import ast

typ_json="{'FromPort': 80, 'IpProtocol': 'tcp', 'IpRanges': [{'CidrIp': '0.0.0.0/0'}], 'Ipv6Ranges': [{'CidrIpv6': '::/0'}], 'PrefixListIds': [], 'ToPort': 80, 'UserIdGroupPairs': []}"

port = ast.literal_eval(typ_json)
print(port['FromPort'])

edited Dec 20, 2019 at 9:29

cullzie

2,7652 gold badges19 silver badges22 bronze badges

answered Apr 16, 2019 at 12:28

Yash Shukla

1416 bronze badges

2 Comments

Jeril Over a year ago

how is this different from the other answer?

Yash Shukla Over a year ago

I didn't see your answer, so I thought it should be the right answer.

Collectives™ on Stack Overflow

Accessing values in json using python

3 Answers 3

Comments

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related