JsonExtract

Description

JsonExtract extracts a value from JSON text by path.

Syntax

JsonExtract(json_text, path)

Parameters

Parameter	Required	Type	Description
json_text	Yes	String or JSON	JSON content.
path	Yes	String	JSON path to extract.

Notes

Use this function in calculated fields, metric expressions, or query expressions where the function category is supported.

Example

JsonExtract(ProfileJson, "$.city")

The expression returns the calculated result according to the current query context.