json_extract
Extract specific data from JSON files using paths, filters, patterns, or slices to retrieve targeted values, transform data, and analyze specific elements.
Instructions
Extract specific data using paths, filters, patterns, or slices from JSON files. Always use this tool when you need to retrieve particular values, filter arrays/objects by conditions, search for patterns, or slice data. Ideal for targeted data extraction, data transformation, and focused analysis of specific JSON elements.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | Path to the JSON file | |
| path | No | Dot notation path to target | |
| filter | No | JS condition to filter results (e.g., 'item.age > 18') | |
| pattern | No | Regex pattern to search for | |
| search_type | No | What to search when using pattern | |
| start | No | Array slice start index | |
| end | No | Array slice end index | |
| keys | No | Specific object keys to extract | |
| default_value | No | Fallback if path not found |