Making an array of objects from json using jq

Question

[
  {
    "username": "new",
    "attributes": [
      {
        "name": "attr1",
        "value": "value1"
      },
      {
        "name": "attr2",
        "value": "value2"
      }
    ]
  },
  {
    "username": "new2",
    "attributes": [
      {
        "name": "attr2",
        "value": "value3"
      },
      {
        "name": "attr1",
        "value": "value4"
      }
    ]
  }
]

I have a json as above. From this json, I would like to get the following:

[
  {
    "username": "new",
    "value": "value1"
  },
  {
    "username": "new2",
    "value": "value4"
  }
]

The value I want to have in this object is the value for attribute named attr1. How I can achieve this with jq?

Edit: Fixed errors in the qn. I have tried

echo $USERS | jq ['.[] | {username:username, value: jq '.attributes[]  | select(.name == "attr1") | .value'}'];

where $USERS contains the json data

The shown expected output is inconsistent with the stated requirements. Please fix and also show at least one attempt you’ve made to solve the problem. As they say, SO is not a free programming service. — peak
– peak, Commented Aug 31, 2020 at 7:33
if attr1 is always present you can use map({ username, value: .attributes | map(select(.name == "attr1"))[0].value }) — Aaron
– Aaron, Commented Aug 31, 2020 at 9:18
@nanoticket - What if attr1 does not occur in the array, or occurs more than once? — peak
– peak, Commented Aug 31, 2020 at 9:34

peak · Accepted Answer · 2020-08-31 14:00:52Z

1

 map({ username,
       value: first(.attributes[]
                    | select(.name == "attr1")
                    | .value) })

answered Aug 31, 2020 at 14:00

peak

119k21 gold badges185 silver badges218 bronze badges

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

1 Comment

peak Over a year ago

@dan1st - It's just four lines of very straightforward code, so there's really nothing more to be said other than perhaps: please check the jq tutorial if you're unfamiliar with jq, and please check the jq manual if you're unfamiliar with map or select.

Collectives™ on Stack Overflow

Making an array of objects from json using jq

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