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.
Validate CSV then CSV Filter
Validate raw CSV first, then run CSV Filter for a safe, repeatable pipeline.
Use case
Use this when incoming CSV quality is uncertain and you want a validation gate before running CSV Filter.
Clean CSV then CSV Filter
Normalize CSV structure before running CSV Filter to reduce downstream surprises.
Use case
Use this when exports have inconsistent spacing/quoting and you want better results from CSV Filter.
Validate YAML then Evaluate Path
Validate YAML syntax and then run a path lookup to verify required fields exist.
Use case
Use this for config audits where specific nested YAML values must be present.
Evaluate YAML Path then Detect Format
Run a YAML path check and inspect the resulting output type for downstream compatibility.
Use case
Use this when tuning YAML path expressions and verifying the extracted result shape.
Validate YAML then Run Query
Validate YAML and execute a query over the parsed structure for quick extraction checks.
Use case
Use this when YAML documents must be queried before shipping to downstream systems.
Run YAML Query then Detect Format
Execute a YAML query and inspect the output type to confirm compatibility with later steps.
Use case
Use this when designing YAML extraction queries and validating what they return.
JSON Filter Output Sanity Check
Run JSON Filter and immediately inspect the resulting payload format to verify the output is ready for the next handoff.
Use case
Use this when you want a quick confidence check that json filter produces the kind of payload you expect before wiring it into larger workflows or sharing results.
CSV Filter Output Sanity Check
Run CSV Filter and immediately inspect the resulting payload format to verify the output is ready for the next handoff.
Use case
Use this when you want a quick confidence check that csv filter produces the kind of payload you expect before wiring it into larger workflows or sharing results.
YAML Path Evaluator Output Sanity Check
Run YAML Path Evaluator and immediately inspect the resulting payload format to verify the output is ready for the next handoff.
Use case
Use this when you want a quick confidence check that yaml path evaluator produces the kind of payload you expect before wiring it into larger workflows or sharing results.
YAML Query Tool Output Sanity Check
Run YAML Query Tool and immediately inspect the resulting payload format to verify the output is ready for the next handoff.
Use case
Use this when you want a quick confidence check that yaml query tool produces the kind of payload you expect before wiring it into larger workflows or sharing results.
CSV Filter: Quality Gate
Run CSV Filter in a guardrailed pipeline that validates and prepares data for downstream consumption.
Use case
Use this when csv filter is part of a repeatable process and you want a quality check before/after the core transformation.
CSV Filter: Delivery Flow
Use CSV Filter as a middle step, then shape output for delivery to APIs, reports, or handoff files.
Use case
Use this when you need csv filter plus a final delivery-oriented output format.
YAML Path Evaluator: Quality Gate
Run YAML Path Evaluator in a guardrailed pipeline that validates and prepares data for downstream consumption.
Use case
Use this when yaml path evaluator is part of a repeatable process and you want a quality check before/after the core transformation.
YAML Path Evaluator: Delivery Flow
Use YAML Path Evaluator as a middle step, then shape output for delivery to APIs, reports, or handoff files.
Use case
Use this when you need yaml path evaluator plus a final delivery-oriented output format.
YAML Query Tool: Quality Gate
Run YAML Query Tool in a guardrailed pipeline that validates and prepares data for downstream consumption.
Use case
Use this when yaml query tool is part of a repeatable process and you want a quality check before/after the core transformation.
YAML Query Tool: Delivery Flow
Use YAML Query Tool as a middle step, then shape output for delivery to APIs, reports, or handoff files.
Use case
Use this when you need yaml query tool plus a final delivery-oriented output format.
Filter and Preview JSON Table
Filter JSON records and inspect the resulting rows as a table.
Use case
Use this when API payloads are record arrays and you need quick table-style quality checks.
XML Tree Before XPath
Inspect XML structure in a tree before writing XPath expressions.
Use case
Use this when payload shape is unknown and XPath targeting needs quick visual guidance.
Profile Filtered JSON
Filter JSON records and profile the resulting subset for type consistency.
Use case
Use this to inspect type quality in targeted slices of larger payloads.
XML Exploration Pipeline
Analyze XML structure, inspect tree hierarchy, then evaluate XPath.
Use case
Use this when onboarding unknown XML payloads before writing extraction queries.
Full CSV Data QA
Run end-to-end CSV quality checks with anomaly detection and filtering.
Use case
Use this to enforce stricter QA gates on CSV datasets before handoff.