Script for converting Semgrep JSON output into CSV

index.mjs

import fs from 'fs';
import {format} from '@fast-csv/format';

const input = JSON.parse(fs.readFileSync(process.argv[2]));
const output = format();
output.pipe(process.stdout);

for(let result of input.results) {
    output.write([
        result.path.substring(result.path.lastIndexOf('/') + 1),
        result.start.line + ':' + result.start.col,
        result.extra.lines.trim(),
        result.extra.metadata.cwe || 'N/A',
        result.extra.message,
    ]);
}