Scalar FunctionsDynamic / JSON Functions

extract_json

Extract a value from a JSON string using a JSONPath expression.

Aliases: extractjson

Syntax

extract_json(path, source)

Prop

Type

Returns: dynamic

print extract_json("$.warrior", '{"warrior": "Bjorn Ironside"}')

print_0 (dynamic)
"Bjorn Ironside"

extract_dynamic

Extract a value from a dynamic value using a JSONPath expression.

pack_all

Create a property bag containing all column values.