Skip to content
Utilerio
All endpoints

CSV Editor & Validator

POST/api/v1/tools/csv-editor-validator

Edit CSV data in a spreadsheet-like grid and check it for missing required fields or duplicate keys.

Authentication

Requires an API key in the X-API-Key header.

Try it

POST/api/v1/tools/csv-editor-validator

Parameters

headersstringrequired

Column header names (array).

rowsstringrequired

Rows, each an array of cell strings aligned to headers.

requiredColumnsstringoptional

Column names that must not be empty (array).

uniqueColumnstringoptional

Column name whose values must be unique.

Request body

{
  "headers": [
    "id",
    "email"
  ],
  "rows": [
    [
      "1",
      "a@example.com"
    ],
    [
      "2",
      ""
    ]
  ],
  "requiredColumns": [
    "email"
  ],
  "uniqueColumn": "id"
}

Response codes

  • 200Success.
  • 400Invalid request — check your body or parameters.
  • 401Missing or invalid API key.
  • 403The API key is not scoped to this endpoint.
  • 429Rate limit exceeded — retry after a short wait.

Language

cURL

Request

curl -X POST https://utilerio.com/api/v1/tools/csv-editor-validator \
  -H "X-API-Key: YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{"headers":["id","email"],"rows":[["1","a@example.com"],["2",""]],"requiredColumns":["email"],"uniqueColumn":"id"}'

Response

{ "valid": false, "issues": [{ "row": 2, "column": "email", "message": "\"email\" is required but empty." }], "issueCount": 1 }