Extract values from JSON by path
mend_query_jsonUse when you need specific fields from a JSON document without reading all of it: $.users[0].name, $.items[*].id, $.a.b[-1], $.list[1:3], $..email (recursive). Returns each match with its exact path, type and value. Repairs the JSON first if needed, so broken input still works. Up to 100,000 characters.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| max | No | Maximum matches to return. Default 50. | |
| path | Yes | Path such as $.users[*].email, data.items[0], $..id, $.list[-1], $.list[1:3]. | |
| text | Yes | The JSON (or JSON-ish text). |