How to filter an array of objects based on values in an inner array with jq?

by

Very close! In your select expression, you have to use a pipe (|) before contains.

This filter produces the expected output.

. - map(select(.Names[] | contains ("data"))) | .[] .Id

The jq Cookbook has an example of the syntax.

Filter objects based on the contents of a key

E.g., I only want objects whose genre key contains “house”.

$ json='[{"genre":"deep house"}, {"genre": "progressive house"}, {"genre": "dubstep"}]'
$ echo "$json" | jq -c '.[] | select(.genre | contains("house"))'
{"genre":"deep house"}
{"genre":"progressive house"}

Colin D asks how to preserve the JSON structure of the array, so that the final output is a single JSON array rather than a stream of JSON objects.

The simplest way is to wrap the whole expression in an array constructor:

$ echo "$json" | jq -c '[ .[] | select( .genre | contains("house")) ]'
[{"genre":"deep house"},{"genre":"progressive house"}]

You can also use the map function:

$ echo "$json" | jq -c 'map(select(.genre | contains("house")))'
[{"genre":"deep house"},{"genre":"progressive house"}]

map unpacks the input array, applies the filter to every element, and creates a new array. In other words, map(f) is equivalent to [.[]|f].

More Related Contents:

  1. Add new element to existing JSON array with jq
  2. Accessing a JSON object in Bash – associative array / list / another model
  3. How to check if element exists in array with jq
  4. jq: recursively merge objects and concatenate arrays
  5. Select objects based on value of variable in object using jq
  6. Post an Array of Objects via JSON to ASP.Net MVC3
  7. Swift JSONDecode decoding arrays fails if single element decoding fails
  8. Can an array be top-level JSON-text?
  9. Using jsonb_set() for updating specific jsonb array value
  10. Swift 4 JSON Decodable with multidimensional and multitype array
  11. Assigning an Array Parsed With jq to Bash Script Array
  12. How to output serialized JSON view data as an array of objects, instead of wrapped in an outer object?
  13. Create a Single-Element Json Array Object Using PowerShell
  14. MongoDB rename database field within array
  15. Swift 4 JSON Codable – value returned is sometimes an object, others an array
  16. How can I decode a JSON response with an unknown key in Swift?
  17. How to parse json in flutter?
  18. How to deserialize dodgy JSON (with improperly quoted strings, and missing brackets)?
  19. YAML equivalent of array of objects in JSON
  20. How might I extract the property values of a JavaScript object into an array?
  21. Declare a constant array
  22. Django JSONField inside ArrayField
  23. Why do we use arrays instead of other data structures?
  24. Function pointer arrays in Fortran
  25. Get particular element from mongoDB array [duplicate]
  26. How do you create an immutable array in Swift?
  27. AJAX Post of JavaScript String Array to JsonResult as List Always Returns Null?
  28. How to iterate through a nested stdClass? [duplicate]
  29. Simple VBA array join not working
  30. ReDim Preserve “Subscript Out of Range”

Leave a Comment