Expression to filter out elements with empty arrays using `jsonPath`

Question

I have a JSON payload of the form:

[
  {"id": 1, "list": [1], "name":"one"}, 
  {"id": 2, "list": [1,2], "name":"two"},
  {"id": 3, "list": [], "name":"three"}
]

And I want to filter out the element from the array the contains an empty "list" property. In other words, I want to discard the element with id=3 and process only the first and second element in my example above.

Currently, my filter looks like this:

<!-- ne == not equals -->
<int:filter id="filter" 
            input-channel="in" 
            output-channel="out" 
            expression="#jsonPath(payload, '$[*].list') ne '[]'"
            discard-channel="consoleOutputChannel" />

But this is not working, how should I indicate to my expression that I want to exclude elements with empty list properties?

How would the syntax go? I think I already tried it and didn't work — blurfus
– blurfus, Commented May 10, 2017 at 4:30

Viet · Accepted Answer · 2017-05-10 06:28:27Z

7

Change your expression to:

$.[?(@.list.length()> 0)]

[?(<expression>)] : filter expression
@ : The current node being processed by a filter predicate
list.length() : the length of list array

More detail at JsonPath

edited May 10, 2017 at 6:28

answered May 10, 2017 at 4:35

Viet

3,4191 gold badge20 silver badges35 bronze badges

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

9 Comments

blurfus Over a year ago

I will try when I get back at my desk (tomorrow) and report back.. .thx

JimHawkins Over a year ago

please look at How to Answer

Viet Over a year ago

I don't understand why it is not provide an answer? But nvm, i will update more details..

JimHawkins Over a year ago

do you think it's a good a idea to post a link which may become invalid?

Viet Over a year ago

what means invalid?

|

blurfus · Accepted Answer · 2017-05-10 18:55:26Z

With the help of @Jerry06, I was able to do what I wanted but only after splitting the payload array.

This is the complete solution but I could only do it because of his help (thx) so the credits are to him.

My code now looks like this:

<!-- Split payload into individual messages -->
<int:splitter id="splitter"
                  input-channel="in"
                  output-channel="toFilter"
                  expression="#jsonPath(payload, '$.[*]')"/>

<!-- Filters out messages with empty array of list -->
<int:filter id="filter"
            input-channel="toFilter"
            output-channel="out"
            discard-channel="consoleOutputChannel"
            expression="#jsonPath(payload, '$.list.length()') > 0"/>

Collectives™ on Stack Overflow

Expression to filter out elements with empty arrays using `jsonPath`

2 Answers 2

9 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related