JSONPath filters are not supported ?

[freddieleeman]

Describe the bug
It appears that JSONPath filters do not work

Version
0.39.15

To Reproduce
Steps to reproduce the behavior:

1. Create a new watch with URL: https://build.fhir.org/location-example.json
2. Use CSS/JSON/XPATH Filter: json: json:*.[?(@.use=='work')]
3. Hit Save and Preview
4. See error '*.[?(@.use=='work')]' is not a valid JSONPath expression. (Parse error at 1:3 near token ? (?))

Expected behavior
Result:

[
  {
    "system": "phone",
    "value": "2328",
    "use": "work"
  },
  {
    "system": "fax",
    "value": "2329",
    "use": "work"
  },
  {
    "system": "url",
    "value": "http://sampleorg.com/southwing",
    "use": "work"
  }
]

Screenshots
Works with JSONPath Online Evaluator:

Additional context
Using :latest in Docker

[dgtlmoon]

@freddieleeman jsonpath queries work and are being automated tested

so i renamed your issue and put it into the discussions until we see exactly what the reasoning is

but otherwise "jsonpath filters not working" isnt quite an appropriate title

[dgtlmoon]

Could you setup a watch, and send me the 'share' link? that way I have the full configuration

[freddieleeman]

No, because I am unable to save the configuration due to the JSONPath filter. Just adding the URL and JSONPath filter should be enough to reproduce the issue.

[dgtlmoon]

so yes, that is correct, JSONpath filters are not supported by the library,

so what you can do is review this PR h2non/jsonpath-ng#74

[freddieleeman]

That doesn't seem to add filtering functionality but rather a work-a-round of some sort. I tried it, but unfortunately, it doesn't allow users to get an element that contains a specific value. Unfortunately, I do not have a python background, so I am probably unable to be of any great assistance in adding this feature. I did find the following URL that suggests that filtering should be possible with pythonpath-ng:

https://blogboard.io/blog/knowledge/jsonpath-python/

[freddieleeman]

Hold up. Using json:$.address[?(@.use="work")] does work. Maybe it is just a syntax issue.

[freddieleeman]

I found the issue:

json:$.address[?(@.use="work")] works
json:$.address.[?(@.use="work")] doesn't

Both work with the JSONPath Online Evaluator, which is odd. But it appears that this was a non-issue, and this discussion can be closed. Thank you.

[dgtlmoon]

@freddieleeman the answer was in the wiki the whole time.. I added your example just now at the bottom https://github.com/dgtlmoon/changedetection.io/wiki/JSON-Selector-Filter-help