How to parse parameter's name from JSON with python

Question

I want to parse in bash the json-string like this:

{"710":{"sysKey":"ENTER"},"230":{"sysKey":"DELETE"},"804":{"sysKey":"ADD"}}

My task is to find the value of key {"sysKey":"DELETE"} and get 230

My try:

echo '{"710":{"sysKey":"ENTER"},"230":{"sysKey":"DELETE"},"804":{"sysKey":"ADD"}}' | python -c 'import json,sys;obj=json.load(sys.stdin);print obj["sysKey"]["DELETE"];'

Help me please!

So are you limited to bash or can you use python? Your tags are confusing. — Anonymous
– Anonymous, Commented Aug 3, 2015 at 23:42
I can use python in bash commands like this: echo '{"key":"value"}' | python -c 'import json,sys;obj=json.load(sys.stdin);print obj["key"];' — user3025172
– user3025172, Commented Aug 3, 2015 at 23:50
if you can advice me how to parse this string without python, I would be very grateful — user3025172
– user3025172, Commented Aug 3, 2015 at 23:51
230 is the key not the value. You can't lookup by value. You need to walk for values. So you get to walk all the values looking for a value that is a dictionary with a sysKey key that has DELETE as its value. — Etan Reisner
– Etan Reisner, Commented Aug 3, 2015 at 23:52
Look into the jq utility. stackoverflow.com/questions/18592173/… — engineerC
– engineerC, Commented Aug 4, 2015 at 0:18

Patrick Maupin · Accepted Answer · 2015-08-04 00:26:09Z

1

If the only 'DELETE' you will pipe in is the one under 'sysKey', you could do this:

echo '{"710":{"sysKey":"ENTER"},"230":{"sysKey":"DELETE"},"804":{"sysKey":"ADD"}}' | python -c 'import json,sys;obj=json.load(sys.stdin);obj=dict((z,x) for x, y in obj.items() for z in y.values());print obj["DELETE"];'

But that's pretty ugly by just about anybody's standard, I think...

answered Aug 4, 2015 at 0:26

Patrick Maupin

8,1672 gold badges25 silver badges44 bronze badges

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

1 Comment

user3025172 Over a year ago

on the advice of Etan Reisner, my decision was:

echo {"710":{"sysKey":"ENTER"},"230":{"sysKey":"DELETE"},"804":{"sysKey":"ADD"}} | python -c $'import json,sys;obj=json.load(sys.stdin);\nfor key in obj.keys():\n\tif obj[key]["systemName"]=="DELETE":  print key'

Collectives™ on Stack Overflow

How to parse parameter's name from JSON with python

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related