JQ add properties to nested object in nested array

Question

I have the following json:

{
  "first": {
    "second" : "A"
  },
  "array": [
    {
      "name" : "AAA",
      "something": {
        "hola": "hi"
      }
    },
    {
      "name" : "BBB",
      "something": {
        "hola": "hi"
      }
    }
  ]
}

I would like to trasform it adding a property to the something object, using the value from the name property of the parent, like:

I have the following json:

{
  "first": {
    "second" : "A"
  },
  "array": [
    {
      "name" : "AAA",
      "something": {
        "hola": "hi",
        "NEW_PROPERTY": "AAA"
      }
    },
    {
      "name" : "BBB",
      "something": {
        "hola": "hi",
        "NEW_PROPERTY": "BBB"
      }
    }
  ]
}

Which jq expression can do this?

oliv · Accepted Answer · 2018-09-21 11:38:26Z

6

Try this jq script:

<file jq '.array = [ .array[] | .something.NEW_PROPERTY = .name ]'

This is replacing the array by another one that is the same as the original one with one more key NEW_PROPERTY.

edited Sep 21, 2018 at 11:38

answered Sep 21, 2018 at 11:37

oliv

13.3k30 silver badges52 bronze badges

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

1 Comment

Inian Over a year ago

Nice! I was missing the final piece to add the .name field.

peak · Accepted Answer · 2018-09-21 14:20:01Z

1

You could simply use the filter:

.array |= map(.something.NEW_PROPERTY = .name)

or if map's not your thing (or if you want to save typing one character):

.array[] |= (.something.NEW_PROPERTY = .name)

answered Sep 21, 2018 at 14:20

peak

119k21 gold badges185 silver badges218 bronze badges

Collectives™ on Stack Overflow

JQ add properties to nested object in nested array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related