JQ convert json array to object properties

Question

I have a json structured like this:

[
    { 
      "name": "object1",
      "prop": "prop1",
      "props": [
        { "prop1": "value1" },
        { "prop2": "value2" },
        { "prop3": "value3" }
      ]
    },
    { 
      "name": "object2",
      "prop": "prop2",
      "props": [
        { "prop1": "value4" },
        { "prop2": "value5" },
        { "prop3": "value6" }
      ]
    }
]

I would like to extract the content of the props variable and have it as extra object properties, looking like this:

[
    { 
      "name": "object1",
      "prop": "prop1",
      "prop1": "value1",
      "prop2": "value2",
      "prop3": "value3"
    },
    { 
      "name": "object2",
      "prop": "prop2",
      "prop1": "value4",
      "prop2": "value5",
      "prop3": "value6"
    },
]

I've been trying to use map but I can't seem to be able to get rid of the array.

choroba · Accepted Answer · 2021-02-18 21:23:02Z

3

Use add to merge the propN objects into one, del to remove the original props:

jq '[.[] | . + (.props | add) | del(.props)]' file.json

You can indeed use map to shorten it a bit:

jq 'map(. + (.props | add) | del(.props))' file.json

edited Feb 18, 2021 at 21:23

answered Feb 18, 2021 at 19:01

choroba

245k27 gold badges221 silver badges304 bronze badges

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

3 Comments

hobbs Over a year ago

Equivalently jq 'map(. + (.props | add) | del(.props))'

Federico Nafria Over a year ago

If I wanted to do something else with the rest of the object properties I would need to do it separately, right? jq '{...} | map(...)' file.json.

choroba Over a year ago

@FedericoNafria: You can process the result of the map, e.g. map(. + (.props | add) | del(.props)) | .[].name |= ascii_upcase.

Collectives™ on Stack Overflow

JQ convert json array to object properties

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related