Query hub
Extract targeted values and records with JSONPath, XPath, and query expressions.
Hub intro and use cases
Use this hub when you need to locate, filter, or project only the data that matters.
- Extract key fields from large JSON payloads.
- Run XPath/XQuery lookups against XML documents.
- Prototype ad-hoc query logic before workflow automation.
On this page
Jump to each section quickly.
Workflows in this hub
Touching = workflows with at least one query tool. Primary = first step is query or most steps are query.
Merge and Filter JSON Dataset
Merge two JSON sources, filter records, then format the final output.
Use case
Use this when combining data from two JSON sources and extracting only relevant records for downstream API or app usage.
XPath to JSON Extraction
Evaluate XPath paths in XML payloads and convert selected structures to JSON for analysis.
Use case
Use this when auditing XML feeds and quickly extracting nested nodes for modern JSON tooling.
XQuery Investigation Flow
Run a practical XQuery subset against XML and normalize the resulting report as readable JSON.
Use case
Use this when exploring legacy XML payloads and you need quick extraction before moving to full query engines.
JSON Pointer and Patch Cycle
Inspect precise JSON paths, generate a patch between versions, and apply patch operations.
Use case
Use this when reviewing fine-grained document changes and preparing repeatable RFC 6902 update operations.
API Hotfix Pointer and Patch Loop
Format a payload, inspect target paths, generate patch operations, and apply them for rapid hotfix validation.
Use case
Use this when preparing minimal payload corrections under time pressure and documenting exact patch operations.
API War Room Unified Query
Detect input shape, run cross-format queries, and produce a normalized report for debugging teams.
Use case
Use this in multi-service incidents where some systems emit JSON while others emit XML or YAML.
Cross-Format Regression Gate
Detect payloads, compare files, and run focused queries to validate that critical fields did not regress.
Use case
Use this before releases when QA must validate behavior across mixed-format API and config payloads.
XML Query Parity Check
Run XPath and XQuery-subset checks, then compare outputs to confirm extraction parity.
Use case
Use this while migrating XML query logic to ensure two query styles return equivalent business data.
JSON Batch Audit SQL Export
Split large JSON payloads, inspect key paths, and export records as SQL batches for audit trails.
Use case
Use this when compliance or operations teams need chunked SQL evidence from large JSON datasets.
Format Detect and Query Starter
Detect payload format first, then run a unified query in a single beginner-friendly flow.
Use case
Use this when learning query tools and unsure whether incoming payloads are JSON, XML, or YAML.
XPath Quick Extract and Format
Run an XPath extraction and format the JSON result for readable review.
Use case
Use this as a simple starter flow when learning XML querying and inspecting extracted values.
XML Query to YAML Brief
Run practical XQuery extraction, convert selected XML to YAML, and normalize formatting.
Use case
Use this when generating concise YAML handoff artifacts from larger XML payloads.
Format Detect, Query, and Export SQL
Detect payload format, run unified extraction queries, then emit SQL insert statements.
Use case
Use this when mixed-format incident data must be triaged and quickly loaded into relational analysis tables.
JSON Filter and Format
Filter JSON records down to relevant fields, then pretty-format the result.
Use case
Use this when large payloads need a smaller, readable subset for debugging or handoff.
API Format and Query
Normalize raw API responses, then run a unified query for focused extraction.
Use case
Use this during first-pass API debugging when payloads are noisy and you need targeted values quickly.
XQuery Output Validate
Run a practical XQuery extraction and validate the resulting JSON output.
Use case
Use this while learning XQuery workflows to ensure extracted output stays parseable.