jsonpath_query
Extract specific values from a loaded JSON document by running a JSONPath expression against its alias, returning matched results as a list.
Instructions
Execute a JSONPath expression against a loaded JSON document.
Use standard JSONPath syntax to extract data. Examples:
$.users[*].email — all user emails
$.orders[?@.total>100] — orders over 100
$.config.database.host — specific nested value
Args: alias: The alias of the loaded document. expression: A JSONPath expression (must start with $).
Returns: The matched values as a list, or a message if nothing matched.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| alias | Yes | ||
| expression | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |