What it can do
- Parse a header-based CSV
- Aggregate rows without a spreadsheet
- Deduplicate and sort owner names
- Return report-ready JSON
How the recipe works
CSV to JSON
Use the header row as object property names.
Jsonata Query
Calculate counts and distinct owners with one JSONata expression.
JSON Beautify
Format the summary for copying into a ticket or report.
Demonstration
Sample input
id,severity,status,owner
INC-1,critical,open,Ada
INC-2,high,closed,Lin
INC-3,high,open,Ada
INC-4,medium,open,SamExpected result
A JSON summary with total 4, open 3, critical 1, and three distinct owners.When to use it
- Incident queue summaries
- Support exports
- Quick CSV quality checks
Adapt it
Change the JSONata expression to group by severity, team, service, or another column in your export.
Source and verification
Adapted from GCHQ CyberChef project and examples. The explanation and sample are written for Serialize, use synthetic or documentation-safe data, and are checked against the current operation catalogue. The workflow runs locally without an external API call.