JSONPath how to filter out objects that contains lists of empty objects?

Question

I'm trying to use JSONPath (Jayway implementation), to get objects that contains a values array, that contains at least 1 non empty value. This is a simplified data I get from some service:

[
  {
    "feature" : "city",
    "values" : [
      {
        "value" : "cba"
      },
      {},
      {
        "value" : "abc"
      }
    ]
  },
  {
    "feature" : "country",
    "values" : [
      {},
      {}
    ]
  }
]

I've dozens of crazy approaches.

Get the objects with the value attribute

$.[?(@..value)]

but this filters nothing I can still see both objects instead of only one.

I've also tried to filter by the length of the filtered values array but it doesn't work either, and returns an empty list:

$.[?(@.values[?(@.value)].length()>1)]

I'm trying to work it out using online evaluator from jsonpath.herokuapp.com I've been searching a lot and it seems that getting the length of the filtered array isn't possible, but the first approach looks like something that should work. Any ideas?

Wouldn't it work to ensure there is at least a first value element in values? Try: $[*][?(@.values[0].value)] — wp78de
– wp78de, Commented Aug 11, 2021 at 0:35

Akshay G · Accepted Answer · 2022-08-08 08:49:46Z

3

With Jayway-JSONPath you can use the empty Filter Operator

Filter the object

$.[?(@..value empty false)]

edited Aug 8, 2022 at 8:49

answered Aug 8, 2022 at 8:44

Akshay G

2,3601 gold badge19 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

JSONPath how to filter out objects that contains lists of empty objects?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related