jq map object key value to array of objects containing both

Question

I would like to put an object parent key inside the object itself and convert each key value pair to an array

Given:

{
  "field1": {
    "key1": 11,
    "key2": 10
  },
  "field2": {
    "key1": 11,
    "key2": 10
  }
}

Desired output

[
   {"name": "field1", "key1": 11, "key2": 10},
   {"name": "field2", "key1": 11, "key2": 10}
]

I know that jq keys would give me ["field1", "field2"] and jq '[.[]]' would give

[
  { "key1": 11, "key2": 10 },
  { "key1": 11, "key2": 10 }
]

I cannot figure out a way to combine them, how should I go about it?

oguz ismail · Accepted Answer · 2020-06-12 17:02:04Z

7

Generate an object in {"name": <key>} form for each key, and merge that with the key's value.

to_entries | map({name: .key} + .value)

or:

[keys_unsorted[] as $k | {name: $k} + .[$k]]

answered Jun 12, 2020 at 11:26

oguz ismail

51.8k16 gold badges64 silver badges83 bronze badges

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

Comments

Inian · Accepted Answer · 2020-06-12 11:27:30Z

2

Something like below. Get the list of keys in the JSON using keys[] and add the new field name by indexing key on each object.

jq '[ keys[] as $k | { name: $k } + .[$k] ]'

If you want the ordering of keys maintained, use keys_unsorted[].

answered Jun 12, 2020 at 11:27

Inian

87k15 gold badges166 silver badges183 bronze badges