Query JSON
json_queryFree, read-only. JSONPath-lite query on JSON from a URL or an inline string (one of the two). Returns matches as JSON: one match bare, several as an array. Supports $, .key, ['key'], [0], [-1], [*], ..key and [?(@.k op v)]; no slices or jq. Errors on invalid JSON or over 5 MB (json_query_xl: paid, 25 MB).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| url | No | JSON URL, max 5 MB. Not with json. | |
| json | No | Inline JSON text. Not with url. | |
| limit | No | Default 100, max 1000. Above it: {results,total,returned}. | |
| query | Yes | Starts with $: '$.users[*].name', '$..price', '$.items[?(@.price<10)].id'. Filter ops: = != > >= < <= =~. '$' = whole document. | |
| headers | No | Headers to forward (Authorization, Cookie…). |