Skip to content

Structured data

Parse, format, query, extract, sort, and convert common structured data.

Structured data

Beginner1 stepsBeautify and sort JSONIndent compact JSON and sort object keys for easier comparison.Beginner1 stepsConvert JSON to YAMLTurn a JSON object into a readable YAML document.Beginner1 stepsConvert CSV records to JSONUse the header row as property names and produce an array of objects.Intermediate1 stepsQuery JSON with JsonataSelect products from orders whose prices exceed a threshold.Beginner1 stepsBeautify XMLIndent a compact XML document so element nesting is easy to inspect.Beginner2 stepsSort and deduplicate linesOrder text lines case-insensitively and remove exact duplicate rows.Beginner1 stepsExtract unique email addressesFind email addresses in prose, sort them, and remove duplicates.Beginner1 stepsExtract unique domainsCollect domain names from prose while removing duplicates.Advanced7 stepsTurn Apache access logs into readable reportsNormalize whitespace, convert timestamps to UTC, capture fields, and render a labelled request summary for every line.Intermediate3 stepsRender CSV as a complete HTML tableTurn cells into table columns, rows into table records, and wrap the result in a valid HTML document.Advanced4 stepsUnwrap URL-encoded Base64 Gzip JSONRemove a URL layer, decode Base64, decompress Gzip, and format the recovered JSON document.Intermediate3 stepsDecode an AWS CloudWatch Logs eventRemove the Base64 and Gzip transport layers from a CloudWatch Logs subscription event, then format its JSON payload.Advanced3 stepsSummarize an incident CSVConvert incident rows to objects, calculate useful counts with JSONata, and return a compact JSON summary.Advanced3 stepsDecode a chunked Gzip JSON responseReassemble HTTP chunked transfer data, decompress its Gzip body, and format the recovered JSON.
Navigation

Type to search…

↑↓ navigate↵ selectEsc close