get-json
Extract and manipulate JSON data from a URL using JSONPath, enabling filtering, arithmetic operations, and text transformations to retrieve specific content efficiently.
Instructions
Extract JSON content from a URL using JSONPath with extended features. Supports extensions like len, keys, filtering, arithmetic operations, and more. If 'pattern' is omitted or empty, the entire JSON document is returned.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pattern | No | Extended JSONPath pattern supporting: Basic: 'foo[*].baz', 'bar.items[*]'; Extensions: '$.data.`len`', '$.users.`keys`', '$.field.`str()`'; Filtering: '$.items[?(@.price > 10)]', '$.users[?name = "John"]'; Arithmetic: '$.a + $.b', '$.items[*].price * 1.2'; Text ops: '$.text.`sub(/old/, new)`', '$.csv.`split(",")' | |
| url | Yes | The URL to get raw JSON from |
Input Schema (JSON Schema)
{
"properties": {
"pattern": {
"description": "Extended JSONPath pattern supporting: Basic: 'foo[*].baz', 'bar.items[*]'; Extensions: '$.data.`len`', '$.users.`keys`', '$.field.`str()`'; Filtering: '$.items[?(@.price > 10)]', '$.users[?name = \"John\"]'; Arithmetic: '$.a + $.b', '$.items[*].price * 1.2'; Text ops: '$.text.`sub(/old/, new)`', '$.csv.`split(\",\")'",
"type": "string"
},
"url": {
"description": "The URL to get raw JSON from",
"type": "string"
}
},
"required": [
"url"
],
"type": "object"
}