JSONPATH
Allows to navigate and retrieve specific data from JSON objects or arrays based on a specified path or query.
Syntax
JSONPATH(<val>, <path>)
Parameter | Type | Description |
---|---|---|
val | Text | |
path | Text |
Return values
Text
Examples
JSONPATH(products.meta_fields, "collection.name")
JSONPATH(order_items.properties, "#(name=""color"").value")