jq add element to each object inside array of objects

Question

If I have an array of objects like this:

[
    {
        "remote" : [
            {
                "id" : 1
            },
            {
                "id" : 2
            },
            {
            "   id" : 3
            }
        ],
        "text_id" : 1
        },
    {
        "remote" : [
            {
                "id" : 4
            },
            {
                "id" : 5
            },
            {
                "id" : 6
            }
        ],
        "text_id" : 2
    }
]

How would you add "text_id" field to every object inside .[].remote[] array so it would become

[
    {
        "remote" : [
            {
                "id" : 1,
                "text_id" : 1
            },
            {
                "id" : 2,
                "text_id" : 1
            },
            {
            "   id" : 3,
                "text_id" : 1
            }
        ]
        },
    {
        "remote" : [
            {
                "id" : 4,
                "text_id" : 2
            },
            {
                "id" : 5,
                "text_id" : 2
            },
            {
                "id" : 6,
                "text_id" : 2
            }
        ]
    }
]

I have already spent several hours trying to figure this out. It looks like there has to be a way to do this using foreach directive, but after I checked the manual for it, it seemed to me pretty obscure so I though maybe someone could give an example. Thanks.

oguz ismail · Accepted Answer · 2021-05-13 08:14:05Z

6

You don't need map for that.

.[] |= (.remote[] += {text_id} | del(.text_id))

^{Online demo}

answered May 13, 2021 at 8:14

oguz ismail

51.8k16 gold badges64 silver badges83 bronze badges

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

2 Comments

krop Over a year ago

Thanks, your answer looks shorter, although I used jq '.[] | {remote, text_id} | .remote[] + {text_id}' json.log in the end, but it was inspired by your version=) It seems I had those freaking dots messed up when composing objects, because I was trying to do that and only got jq's error messages, which were not helpful at all.

oguz ismail Over a year ago

@krop Good. .[] | .remote[] + {text_id} would do the same thing though.

choroba · Accepted Answer · 2021-05-13 07:51:36Z

2

jq 'map( .text_id as $t
         | .remote |= map( . + {text_id : $t} )
         | del(.text_id)
    )'

answered May 13, 2021 at 7:51

choroba

245k27 gold badges221 silver badges304 bronze badges

Comments

Edwin · Accepted Answer · 2021-05-13 07:47:28Z

0

I think you should use array.map() You have two levels of array so it should look like this :

const fatArray = [
    {
        remote : [
            {
                id : 1
            },
            {
                id : 2
            },
            {
                id : 3
            }
        ],
        text_id : 1
        },
    {
        remote : [
            {
                id : 4
            },
            {
                id : 5
            },
            {
                id : 6
            }
        ],
        text_id : 2
    }
];
const finalArray = fatArray.map( arr => {
  return arr.remote.map(elem => { return {text_id: arr.text_id, id: elem.id}})
}
)
console.log(finalArray);

answered May 13, 2021 at 7:47

Edwin

374 bronze badges

2 Comments

krop Over a year ago

THanks but I meant this jq: stedolan.github.io/jq/manual/#example28

Edwin Over a year ago

oops my bad sorry !

Collectives™ on Stack Overflow

jq add element to each object inside array of objects

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related