Export JSON Test Results to CSV in GitHub Actions Pipelines

{
  "summary": {"passed": 142, "failed": 3, "skipped": 8, "duration": 47.3},
  "tests": [
    {"name": "test_user_login", "status": "passed", "duration": 0.23},
    {"name": "test_payment_flow", "status": "failed", "duration": 12.4,
     "error": "AssertionError: Expected 200, got 503"},
    {"name": "test_api_rate_limit", "status": "passed", "duration": 1.8}
  ]
}
# Product manager needs this in a spreadsheet
# QA manager wants trend data over time
# Manually copying is error-prone

name: Test and Report
on: [push, pull_request]

jobs:
  test-and-report:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4

      - name: Run tests with JSON output
        run: |
          # pytest with json-report plugin
          pip install pytest-json-report
          pytest tests/ --json-report --json-report-file=test-results.json

      - name: Convert JSON results to CSV
        run: |
          python3 << 'PYEOF'
          import json, csv, sys
          from datetime import datetime

          with open('test-results.json') as f:
              data = json.load(f)

          rows = []
          for test in data.get('tests', []):
              rows.append({
                  'run_date': datetime.utcnow().strftime('%Y-%m-%d'),
                  'commit': '${{ github.sha }}'[:8],
                  'branch': '${{ github.ref_name }}',
                  'test_name': test['nodeid'],
                  'status': test['outcome'],
                  'duration_s': round(test.get('call', {}).get('duration', 0), 3),
                  'error': test.get('call', {}).get('longrepr', '')[:200],
              })

          with open('test-results.csv', 'w', newline='') as f:
              writer = csv.DictWriter(f, fieldnames=rows[0].keys())
              writer.writeheader()
              writer.writerows(rows)

          print(f"Converted {len(rows)} test results to CSV")
          PYEOF

      - name: Upload CSV report as artifact
        uses: actions/upload-artifact@v4
        with:
          name: test-results-${{ github.run_id }}
          path: |
            test-results.json
            test-results.csv
          retention-days: 90

      - name: Post test summary to PR
        if: github.event_name == 'pull_request'
        run: |
          SUMMARY=$(python3 -c "
          import json
          d = json.load(open('test-results.json'))
          s = d.get('summary', {})
          print(f"✅ {s.get('passed',0)} passed | ❌ {s.get('failed',0)} failed | ⏭ {s.get('skipped',0)} skipped | ⏱ {s.get('duration',0):.1f}s")
          ")
          gh pr comment ${{ github.event.pull_request.number }} --body "$SUMMARY"
        env:
          GH_TOKEN: ${{ secrets.GITHUB_TOKEN }}