When a long API JSON response hides sku, id, trace.id, or order-line fields across unknown nesting levels, format the payload first, use JSONPath recursion and wildcards to discover the field, then verify the stable path with Pointer, key paths, or diff checks.
JSONPath field discovery topic
JSONPath recursive field discovery, wildcard paths, and API response debugging tools
A local workflow for $..field recursive discovery, [*] array wildcards, bracket notation for special keys, and API field lookup.
JSONPath recursive field discoveryJSONPath $..skuJSONPath wildcard array pathJSONPath special keyJSONPath bracket notationAPI response field lookupJSONPath empty result debugging
Common lookup scenarios
Discover nested sku, id, or error-code fields when you do not know the level
Sweep deep item or line arrays with [*] wildcards
Read dotted or hyphenated metadata keys with bracket notation
Explain why an old JSONPath turned empty after a release
Export discovered fields to CSV for QA or ops review
Recommended workflow
- Format the JSON and confirm the root shape
- Use recursive expressions such as $..sku or $..id for field discovery
- Add [*] or a narrower parent path when arrays are deep
- Use ['trace.id'] or ['request-id'] for special keys
- Once stable, verify the final path with Pointer, key paths, or diff checks
Related tool entries
A local workflow for $..field recursive discovery, [*] array wildcards, bracket notation for special keys, and API field lookup.
JSONPath viewer
Use this jsonpath viewer tool to inspect, convert, or generate a clear result directly in your browser.
LookupToolChakanJSON key path extractor
Extract JSON key paths with node types, depth, and path formats to speed up field inventory and mapping preparation.
LookupToolChakanJSON Pointer viewer
Resolve a JSON Pointer against pasted JSON to inspect one exact field, array item, or root node with a path trace.
LookupToolChakanJSON formatter
Use this json formatter tool to inspect, convert, or generate a clear result directly in your browser.
LookupToolChakanJSON deep diff
Use this json deep diff tool to inspect, convert, or generate a clear result directly in your browser.
LookupToolChakanCSV and JSON converter
Convert CSV to JSON or JSON to CSV in the browser with delimiter detection, header handling, and preview rows for imports and docs.
LookupToolChakanFAQ
When a long API JSON response hides sku, id, trace.id, or order-line fields across unknown nesting levels, format the payload first, use JSONPath recursion and wildcards to discover the field, then verify the stable path with Pointer, key paths, or diff checks.
When should I start with recursive JSONPath?
Start with recursion when you know the field name but not the nesting level. After discovery, narrow it to a more stable path.
Why combine this with Pointer or key paths?
Recursive lookup is best for discovery. Fixed paths are better for docs, tests, and post-release regression checks.
Continue with these topics
Searchable topic pages that group related tools, answer specific lookup intents, and make Chakan easier for search engines and AI systems to understand.
Upload file format error, import failed, and unsupported file type troubleshooting
A local workflow for unsupported file type errors, CSV import failures, JSONL line errors, text encoding problems, extension allow-lists, and upload size limits.
Open topicFile signature, extension mismatch, and disguised file troubleshooting
A local workflow for checking magic numbers, extension meaning, file headers, suspicious archive entries, upload type mismatches, and the safety boundary before sharing files.
Open topicFilename, path privacy cleanup, and pre-share file checks
A local workflow for filename cleanup, batch rename planning, path parsing, file signature checks, extension lookup, file size conversion, and archive review before sharing.
Open topic