Inspecting and Querying Data
The Data Inspector is a unified subsystem for exploring structured data. It powers the Raw Query kit for standalone data analysis and acts as the response viewer for API and Database clients.
Loading data
In the Raw Query kit, you can load data through several methods:
- Paste button: Click the Paste button to load text directly from your clipboard.
- Open button: Click Open to browse and select a local file.
- Drag and Drop: Drag a file from your file system and drop it onto the editor area.
- Manual Entry: Type or edit data directly in the editor.
Supported file formats include .json, .xml, .txt, .md, .log, and Base64-encoded JSON.
Data formats and conversion
The inspector auto-detects the format of loaded data but lets you override it manually:
- JSON: The default format for structured data.
- XML: View XML with syntax highlighting and formatting. Switch to Preview mode to view XML as a traversable JSON object.
- Base64 JSON: Decodes Base64-encoded JSON strings into JSON automatically.
Exploration tools
Raw mode
The Raw mode uses a Monaco-based editor with syntax highlighting.
- Format tools: Use the Format/Expand, Collapse, and Minimize buttons to adjust data presentation.
- Search: Find specific keys or values across the object.
- Copy JSONPath: Click any key in a JSON object to copy its JSONPath.
- Copy Value: Click the Copy icon in the editor's top-right corner to copy the entire input to your clipboard.
Preview mode
Switch to Preview mode to visualize data:
- Table: Renders JSON arrays as sortable and resizable data grids.
- Image: Renders Base64-encoded images or byte arrays as inline images.
- PDF: Displays Base64 or binary PDFs using an inline viewer or a full-screen overlay for large files.
Compare mode (Diff)
Click the Compare mode icon to view a side-by-side diff between the current data and the version that existed when the editor was first focused. This tracks manual edits or changes in updated API responses.
JSONPath Queries
Use the Query section to filter and extract data from the loaded source in real-time.
- Run Queries: Enter a JSONPath expression (e.g.,
$.items[*].id) to filter data. Results update as you type. - Multiple Queries: Run several queries simultaneously using multiple rows.
- Query Diff: Toggle Compare mode to see how result sets have changed since the last execution.
- Extract to Variable: Click the Options (...) menu on a query row and select Extract to variable. Enter a variable name; the query result will be automatically assigned to this variable on each execution.
- Tagging: Click the Options (...) menu and select Add tag to categorize queries. You can then use the tag filter at the top of the list to show only specific groups.
- Navigation: Click any key in a query result to copy its JSONPath to your clipboard.