JSON Path evaluator tool not working as expected

kdfreeman · January 31, 2025, 8:00pm

What problem are you observing?

JSON path evaluator is not working as expected. It is not filtering as desired.
For example, User the following json in the evaluator tool. I am using “Account Aggregation Completed” trigger.Triggers - SailPoint Identity Services
Use the json filter query, $[($.source.id=="4e4d982afddff4267ab12f0f1e72b5e6d")]

What is the correct behavior?

The output should be whole json. Instead, I am getting empty array.

What product feature is this related to?

Filter Expression Creation.

What are the steps to reproduce the issue?

Use this filter for above mentioned sample json.
$[?($.source.id=="4e4d982afddff4267ab12f0f1e72b5e6d")]

Do you have any other information about your environment that may help?

The outside json path evaluator is working and filtering as expeted. The sailpoint json evaluator is not working as expected for above scenario for example.

colin_mckibben · January 31, 2025, 8:34pm

Hi Kapil,

I had to make a slight modification to your query to be correct syntax. You forgot the question mark.

$[?($.source.id=="4e4d982afddff4267ab12f0f1e72b5e6d")]

However, this isn’t a bug. Our JSONPath evaluator supports two implementations, workflows and event triggers. It defaults to workflows, which returns an empty array for this query. If you switch to event triggers, it will return the object.