How to extract all (also nested) key names with jq

user_1442357 0
Viewed 7036

How can I extract all key names, even in nested objects with jq? For example, I have json:

{ "a": 1, "b": { "c": 2 } }

and I want to get list: a, b, b.c

I know that for top level keys I can get this, with: . | to_entries[] | .key, but what about keys in nested objects?

jq json
2 Answers

Short jq solution:

jq -r '[paths | join(".")]'  jsonfile

The output:

[
  "a",
  "b",
  "b.c"
]

  • paths function outputs the paths to all the elements in its input

  • join(".") - to concatenate keys within hierarchical paths

user_31854590

Given input foo.json

{"a":1,"b":[{"c":2}]}

jq '[
paths |
map(select(type!="number")) |
select(length > 0) |
join(".")
] | unique' foo.json

outputs

[
  "a",
  "b",
  "b.c"
]
user_15071240
Related