Skip to content

Summarize an incident CSV

Convert incident rows to objects, calculate useful counts with JSONata, and return a compact JSON summary.

Install in Serialize

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,Sam

Expected 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.

Navigation

Type to search…

↑↓ navigate↵ selectEsc close