how to parse a JSON output?

Question

I am trying to parse the output a command which is in JSON format and running into below error?I provided a sample output of the command aswell,any pointers on how to fix it?

import subprocess,json
user = 'user1'
gerrit = '1234567'
branch_cmd = "ssh -l %s -p 29418 review-android.quicinc.com gerrit query %s --format=JSON"%(user,gerrit)
proc = subprocess.Popen(branch_cmd.split(' '), stdout=subprocess.PIPE, stderr=subprocess.PIPE)
(output, error) = proc.communicate()
print output["branch"]

OUTPUT:-

{"project":"platform/system/technology","branch":"technology.lnx.2.1-dev","topic":"","id":"Id1ca6a5167c8e7269b154824e5a5dd2389a2d1cf","number":"1234567","subject":"Bluetooth:HOGP Write Scan Interval Window characteristic","owner":{"name":"Firstname Kumar name","email":"[email protected]","username":"sname"},"url":"https://review-android.company.com/1234567","createdOn":1471052441,"lastUpdated":1480706360,"sortKey":"004195870019d68b","open":false,"status":"ABANDONED"}
{"type":"stats","rowCount":1,"runTimeMilliseconds":1}

ERROR:-

  File "strip_dev_rel.py", line 10, in <module>
    print output["branch"]
TypeError: string indices must be integers, not str

Neapolitan · Accepted Answer · 2016-12-06 01:40:40Z

2

Need to convert the string into json, like the following:

for line in output.split('\n'):
    print json.loads(line)

To access the first one:

line1 = output.split('\n')[0]
print json.loads(line)["branch"]

answered Dec 6, 2016 at 1:40

Neapolitan

2,17312 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

how to parse a JSON output?

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