jq : mapping array in object to another object while keeping parent keys and adding new ones

Question

I would like to map the following structure

{
    "id" : "OUTER_ID",
    "name" : "OUTER_NAME"
    "items" : [ 
        {   
            "id" : "INNER_ID_1",
            "name" : "INNER_NAME_1",
        },
        {   
            "id" : "INNER_ID_2",
            "name" : "INNER_NAME_2",
        }
    ]   
}

into this

{
    "payload": [
        {   
            "key" : "INNER_NAME_1_KEY",
            "data" : { 
                "id" : "OUTER_ID",
                "name" : "OUTER_NAME",
                "items" : [ 
                    {   
                        "id" : "INNER_ID_1",
                        "name" : "INNER_NAME_1"
                    }   
                ]   
            }   
        },  
        {   
            "key" : "INNER_NAME_2_KEY",
            "data" : { 
                "id" : "OUTER_ID",
                "name" : "OUTER_NAME",
                "items" : [ 
                    {
                        "id" : "INNER_ID_2",
                        "name" : "INNER_NAME_2"
                    }
                ]
            }
        }
    ]
}

So, for each item in the initial items array, I want to create an entry in the output's payload, i.e I want to map items[i] to payload[i].data.items while also creating the payload, key and data keys in the output, and setting payload[i].data.id and payload[i].data.name to the input's outer id and name.

Can this be done with jq?

Aaron · Accepted Answer · 2019-03-28 11:03:04Z

3

Sure, you can use the following filter :

.id as $id | .name as $name | {payload : [ .items[] | {key:.id, data:{id:$id, name: $name, items:[.]}} ] }

You can try it here.

answered Mar 28, 2019 at 11:03

Aaron

24.9k2 gold badges41 silver badges61 bronze badges

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

1 Comment

user5325596 Over a year ago

Wonderful! Thanks!

Collectives™ on Stack Overflow

jq : mapping array in object to another object while keeping parent keys and adding new ones

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related