JSON from flat key-value pair to nested object

Question

How can I change a flat key-value pair (with concatenated key) to a nested group. I want to split a key at the ___ and use the new sub-key as key of the nested object.

I have tried map and split("___") and the operator |= but was not able to get it, with jq

Source (Input) file, with flat key-value pair

{
  "key1___subkey1-2-foo": "Value 1a",
  "key1___subkey1-2-bar": "Value 1b",
  "key2___subkey2-2___subkey2-3": "Value 2, Level 3",
  "key3": "Value 3"
}

Target format, as nested object

{
  "key1": {
      "subkey1-2-foo": "Value 1a",
      "subkey1-2-bar": "Value 1b"
  },
  "key2": {
      "subkey2-2": {
        "subkey2-3": "Value 2, Level 3"
      }
  },
  "key3": "Value 3"
}

Does this answer your question? Trying to use jq to update a value with a variable path — Botje
– Botje, Commented Nov 15, 2021 at 10:17

Botje · Accepted Answer · 2021-11-15 10:28:40Z

1

jq 'to_entries | map(.key |= split("___")) | reduce .[] as $obj({}; setpath($obj.key; $obj.value))'

The reduce builds up the object by applying setpath with input element's key/value in turn

answered Nov 15, 2021 at 10:28

Botje

32.1k4 gold badges36 silver badges47 bronze badges

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

1 Comment

KargWare Over a year ago

Wow, thanks I have not worked with reduce before. Great.

Collectives™ on Stack Overflow

JSON from flat key-value pair to nested object

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