CleanCSV API Documentation

curl -X POST https://your-domain.vercel.app/api/v1/clean \
  -F "file=@data.csv" \
  -F 'config={"format":"json","dedup":{"columns":["email"],"strategy":"most_complete"}}'

{
  "format": "json",
  "dedup": {
    "columns": ["email"],
    "strategy": "most_complete",
    "fuzzy": false,
    "threshold": 0.85,
    "normalize": true,
    "preview": false,
    "nulls_equal": true
  },
  "encoding": {
    "encoding": "auto",
    "fallback": ["windows-1252", "iso-8859-1"],
    "fix_mojibake": true,
    "normalize_unicode": "NFC",
    "strip_control_chars": true,
    "strip_invisible": true,
    "custom_mojibake_mappings": [
      { "from": "é", "to": "é" }
    ]
  },
  "null_handling": {
    "null_values": ["", "NULL", "N/A", "-"],
    "treat_empty_as_null": true,
    "type_inference": true,
    "fill": "leave",
    "per_column": {
      "age": { "cast": "int", "fill": "fill_median" },
      "status": { "fill": "fill_default:unknown" }
    }
  },
  "null_representation": ""
}

{
  "meta": {
    "rows": 142,
    "columns": 5,
    "removed": 8,
    "encoding_detected": "utf-8",
    "encoding_confidence": 0.99,
    "encoding_issues": ["mojibake_repaired: known_mojibake_replaced"],
    "null_profiles": [
      {
        "column": "email",
        "null_count": 3,
        "null_percentage": 0.021,
        "top_null_values": [{ "value": "N/A", "count": 2 }],
        "inferred_type": "string"
      }
    ],
    "null_warnings": [
      { "column": "age", "message": "Column \"age\" appears numeric but has non-numeric values", "severity": "warning" }
    ],
    "type_map": { "id": "int", "email": "string", "age": "int", "active": "boolean", "name": "string" }
  },
  "data": [
    { "id": 1, "email": "alice@example.com", "age": 30, "active": true, "name": "Alice" },
    { "id": 2, "email": "bob@example.com", "age": null, "active": false, "name": "Bob" }
  ],
  "duplicate_groups": [
    {
      "reason": "exact match on email",
      "confidence": 1.0,
      "rows": [
        { "id": 1, "email": "alice@example.com", "age": 30, "active": true, "name": "Alice" },
        { "id": 3, "email": "alice@example.com", "age": 30, "active": true, "name": "alice" }
      ],
      "kept": { "id": 1, "email": "alice@example.com", "age": 30, "active": true, "name": "Alice" },
      "kept_row_index": 0,
      "droppedIndices": [2]
    }
  ]
}

{
  "row_count": 150,
  "column_count": 5,
  "columns": ["id", "email", "name", "age", "active"],
  "suggested_rules": [
    {
      "dedupBy": ["id"],
      "fuzzy": false,
      "normalize": false,
      "reason": "\"id\" looks like a unique identifier"
    },
    {
      "dedupBy": ["email"],
      "fuzzy": false,
      "normalize": true,
      "reason": "\"email\" contains email addresses — normalizing for dedup"
    }
  ],
  "null_profiles": [
    { "column": "age", "null_count": 12, "null_percentage": 0.08, "top_null_values": [{ "value": "N/A", "count": 8 }], "inferred_type": "int" }
  ],
  "warnings": [
    { "column": "age", "message": "Column \"age\" has null-like placeholders: N/A", "severity": "info" }
  ]
}