Menu

Important: This documentation is about an older version. It's relevant only to the release noted, many of the features and functions have been updated or replaced. Please view the current version.

Open source

json_path

The json_path function lookup values using jsonpath syntax.

The function expects two strings. The first string is the JSON string used look up values. The second string is the JSONPath expression.

json_path always returns a list of values. If the JSONPath expression doesn’t match any values, an empty list is returned.

A common use case of json_path is to decode and filter the output of a local.file or remote.http component to an Alloy syntax value.

Remember to escape double quotes when passing JSON string literals to json_path.

For example, the JSON value {"key": "value"} is properly represented by the string "{\"key\": \"value\"}".

Examples

> json_path("{\"key\": \"value\"}", ".key")
["value"]


> json_path("[{\"name\": \"Department\",\"value\": \"IT\"},{\"name\":\"TestStatus\",\"value\":\"Pending\"}]", "[?(@.name == \"Department\")].value")
["IT"]

> json_path("{\"key\": \"value\"}", ".nonexists")
[]

> json_path("{\"key\": \"value\"}", ".key")[0]
value