parsing string or json in bash (shell)

Question

please help me.

I have the string (json request) :

{"jsonrpc":"2.0","result":[{"hostid":"10158"}],"id":1}

i try to parsing it with command :

reference_id2=`echo "$reference_id" | python -c 'import json, sys; print json.load(sys.stdin)["result"]'`

and still have [{u'hostid': u'10158'}]

How i can get only 10158 (like in example)

THanks.

P.S. this is doesn't work too :

reference_id2=`echo "$reference_id" | python -c 'import json, sys; print json.load(sys.stdin)["result"]["hostid"]'`

result is a list. You need to index into it before you can get hostid out. (The error for that second example should have tipped you off about that.) Try ...["result"][0]["hostid"]' — Etan Reisner
– Etan Reisner, Commented Feb 4, 2015 at 19:21

Pavel Reznikov · Accepted Answer · 2015-02-04 19:21:47Z

2

In your sample result is an array. To get hostid you need to specify item index:

json.load(sys.stdin)["result"][0]["hostid"]

So your code shoud be like:

reference_id2=`echo "$reference_id" | python -c 'import json, sys; print json.load(sys.stdin)["result"][0]["hostid"]'`

answered Feb 4, 2015 at 19:21

Pavel Reznikov

3,2181 gold badge20 silver badges17 bronze badges

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

Comments

John Kugelman · Accepted Answer · 2015-02-04 19:25:49Z

2

Give jq a try. It's the easiest way to parse JSON in the shell.

$ jq -r '.result[0].hostid' <<< "$json"
10158

answered Feb 4, 2015 at 19:25

John Kugelman

364k70 gold badges555 silver badges600 bronze badges