Skip to main content

JSON Path Evaluator

Overview​

The JSON Path Evaluator is a SailPoint-maintained tool that lets you test JSONPath expressions against a JSON document and see the matching results instantly. It gives you a seamless way to validate your expressions without relying on a third-party website.

JSONPath is used throughout Identity Security Cloud (ISC) to pull values out of JSON data. Two of the most common places you'll write JSONPath are:

  • Workflows — to reference data from a trigger or from earlier steps.
  • Event trigger filters — to decide whether a trigger event should be delivered to your subscription.

Because these two features use different underlying JSONPath engines, an expression that works in one won't always behave the same in the other. The evaluator lets you choose which implementation to test against so you can validate your expression in the same way ISC will evaluate it.

Launch the JSON Path Evaluator →

How to use it​

  1. Open the JSON Path Evaluator.
  2. Paste your JSON into the input panel on the left. The tool opens with a sample access-request payload so you can try it right away.
  3. Enter your expression in the JSONPath query field.
  4. Select the implementation (Workflows or Event Trigger) you want to evaluate against.
  5. Click Run.
  6. Review the matches in the result panel on the right. If the expression matches nothing, you'll see No match; if the query or JSON is malformed, an error message explains the problem.

You can adjust the editor's font size with the dropdown in the action bar.

Example​

Using the sample access-request payload, the query:

$.requestedItemsStatus[*].name

returns the name of every requested item:

[
  "Engineering Access"
]

Using the CLI​

The JSON Path Evaluator is also available in the SailPoint CLI for the Workflows implementation. Evaluate an expression against a JSON file with sail jsonpath eval:

sail jsonpath eval -f attributes.json -p "$.identity"
{
  "id": "ee769173319b41d19ccec6cea52f237b",
  "name": "john.doe",
  "type": "IDENTITY"
}
  • -f / --file — path to the JSON file to evaluate.
  • -p / --path — the JSONPath expression to apply.