user3241408 user3241408 - 1 year ago 84
JSON Question

Recursive search values by key

I have a JSON like this:

"A": { "error": null },
"B": { "C": {"error": "error string"}},
"C": { "D": {"error": null}},
"D": { "error": "err str"}

end I want to find all values of error keys which are not null.

For my example it should return

"error string"
"err str"

How can I do it? Is it possible with jq?

Answer Source

Use .. to iterate recursively, and get all the .error values. If they're null, remove them:

jq '.. | .error? // empty'

Alternatively, instead of using empty you can select the elements that are strings with strings:

jq '.. | .error? | strings'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download