How to filter an array of objects based on value of a element in the Json in JQ

Question

I am trying to get a value from the Json using JQ.

I have to get a ID from the inputJson , (activeItem) and use that ID to get the name of the element from list of items below.

Can this be done in single query ?

{
"amazon": {
"activeitem" : 2, 
"items": [
  {
    "id" : 1,
    "name": "harry potter",
    "state": "sold"
  },
  {
    "id" : 2,
    "name": "adidas shoes",
    "state": "in inventory"
  },
  {
    "id" : 3,
    "name": "watch",
    "state": "returned"
  }
]
}
}

Now i am getting the value first and the filtering, instead i want to do in single query.

peak · Accepted Answer · 2018-12-28 19:19:18Z

1

With your data, the filter:

.amazon
| .activeitem as $id
| .items[]
| select(.id == $id)
| .name

produces:

"adidas shoes"

(Use the -r command-line option if you want the raw string.)

answered Dec 28, 2018 at 19:19

peak

119k21 gold badges185 silver badges218 bronze badges

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

Collectives™ on Stack Overflow

How to filter an array of objects based on value of a element in the Json in JQ

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related