Remove multiple entries from an array of objects using jq

Question

I have the following json and want to remove multiple entries from the ebooks array if they are not in the following array ["Pascal", "Python"] (will eventually be dynamic array, this is just for example)

{
   "eBooks":[
      {

         "language":"Pascal",
         "edition":"third"
      },
      {
         "language":"Python",
         "edition":"four"
      },
      {
         "language":"SQL",
         "edition":"second"
      }
   ]
}

was hoping to do something like this, which if it worked would delete last one containing the SQL because it's not in the array, but this doesn't work

jq '.ebooks[] | select ( .language | in(["Pascal", "Python"]))' ebooks.json

pmf · Accepted Answer · 2021-12-16 16:01:53Z

2

You're almost there. Use del, IN and a capital B in eBooks :)

jq 'del(.eBooks[] | select(.language | IN("Pascal", "Python")))' ebooks.json

{
  "eBooks": [
    {
      "language": "SQL",
      "edition": "second"
    }
  ]
}

Demo

answered Dec 16, 2021 at 16:01

pmf

38.6k3 gold badges31 silver badges41 bronze badges

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

1 Comment

retroman Over a year ago

Fantastic, thank you :)

Collectives™ on Stack Overflow

Remove multiple entries from an array of objects 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