json_path
Allows to navigate and retrieve specific data from JSON objects or arrays based on a specified path or query.
Syntax
json_path(<val>, <path>)
| Parameter | Type | Description |
|---|---|---|
| val | Text | The Val string value. |
| path | Text | The path or location. |
Return values
Text
Usage
Extracts the 'name' value from the 'collection' object in product meta fields.
json_path(products.meta_fields, "collection.name")
Extracts a value from a JSON object using a path expression.
json_path(order_items.properties, "#(name=""color"").value")