I want to determine the length of an json array with the length() function.
According to the knime documentation the jsonpath implementation is based on the Jayway library, whoch supports the length function.
I have the follwoing JSON array:
[
{“refId”:“1”,“groupRef”:“1-0”},
{“refId”:“2”,“groupRef”:“2-0”},
{“refId”:“3”,“groupRef”:“3-0”}
]
In a JSONPATH node I have applied the following JSONPATH Query:
$.length()
When testing the above example with the Jayway JsonPath Evaluator at https://jsonpath.herokuapp.com
I get the expected result 3.
When using the same JSON path query in Knime, I get a missing value result.
Can you either check if this is a bug or give any advice on how to get the length of json arrays?
Thanks for your efforts in advance!