Menu
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
Was this page helpful?
Related resources from Grafana Labs
Additional helpful documentation, links, and articles:
Video
GrafanaCON 2024 Keynote Recap
Catch up on GrafanaCON 2024 highlights! Explore Grafana 11 features, LGTM Stack innovations, and community achievements in this recap webinar.
Video
Getting started with the Grafana LGTM Stack
In this webinar, we’ll demo how to get started using the LGTM Stack: Loki for logs, Grafana for visualization, Tempo for traces, and Mimir for metrics.
Video
Getting started with Grafana dashboard design
In this webinar, you'll learn how to design stylish and easily accessible Grafana dashboards that tell a story.