# CSV Import Preflight Validator

> CSV Import Preflight Validator is a paid API for AI agents from www.mahastrategies.com, paid per call via x402, $0.0135/call, status unknown (last checked 2026-10-13).

Validates up to 500 CSV records for quoting errors, column count mismatches, duplicate headers, spreadsheet-formula injection prefixes, and declared scalar type conformance before import.

## Facts

- Endpoint: POST https://www.mahastrategies.com/api/v1/demand/csv-import-preflight?utm_source=zero.xyz
- Price: $0.0135/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-13
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/csv-import-preflight-validator-5ba09402
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_ZzW-CMkkNIBEqDgRjYxld

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability csv-import-preflight-validator-5ba09402 -d '<json body>'
```

Example prompt: Before I load this CSV into the database, run a preflight check on it — it uses comma delimiters, I've declared three columns (name, age, email), the data class is synthetic, and I need you to flag any quoting errors, duplicate headers, formula injection prefixes, or type mismatches.

## When to prefer this

Use this endpoint when you need a lightweight, deterministic structural check on CSV data before committing it to an import pipeline, database, or ETL process — especially when you want formula-injection detection, integrity hashes for audit trails, or column-type conformance checks without executing any cell content or modifying the data. Prefer this over full ETL tools when the goal is pre-import validation only, not transformation or repair.

## Known failure modes

- CSV string exceeds 24,000 character limit — request rejected
- columns array is empty or exceeds 64 items — validation error
- invalid delimiter value (must be comma, semicolon, or tab) — schema error
- dataClass not one of 'public' or 'synthetic' — enum validation failure
- malformed JSON body — 400 bad request
- CSV contains more than 500 rows — truncated or rejected
- missing required fields in body — validation error

## How this service works

Check up to 500 supplied CSV records for quoting, column counts, duplicate headers, spreadsheet-formula prefixes and caller-declared scalar types. Return bounded row/column findings and input integrity hashes. No cell execution, automatic repair, PII detection or import-success guarantee.

## Output

Returns a structured object containing row- and column-level findings (quoting errors, column count mismatches, duplicate headers, formula-prefix detections, scalar type violations), an input integrity hash, a result hash, a receipt digest, a product and version identifier, and a list of limitations (e.g. no PII detection, no cell execution, no automatic repair).

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "$schema": "https://json-schema.org/draft/2020-12/schema",
 "required": [
  "input"
 ],
 "properties": {
  "input": {
   "type": "object",
   "required": [
    "type",
    "method",
    "bodyType",
    "body"
   ],
   "properties": {
    "body": {
     "type": "object",
     "required": [
      "dataClass",
      "csv",
      "delimiter",
      "columns"
     ],
     "properties": {
      "csv": {
       "type": "string",
       "maxLength": 24000,
       "minLength": 1
      },
      "columns": {
       "type": "array",
       "maxItems": 64,
       "minItems": 1
      },
      "dataClass": {
       "enum": [
        "public",
        "synthetic"
       ],
       "type": "string"
      },
      "delimiter": {
       "enum": [
        ",",
        ";",
        "\t"
       ],
       "type": "string"
      }
     },
     "additionalProperties": false
    },
    "type": {
     "type": "string",
     "const": "http"
    },
    "method": {
     "enum": [
      "POST"
     ],
     "type": "string"
    },
    "bodyType": {
     "enum": [
      "json",
      "form-data",
      "text"
     ],
     "type": "string"
    }
   },
   "additionalProperties": false
  },
  "output": {
   "type": "object",
   "required": [
    "type"
   ],
   "properties": {
    "type": {
     "type": "string"
    },
    "example": {
     "type": "object",
     "required": [
      "version",
      "productId",
      "inputHash",
      "resultHash",
      "receiptDigest",
      "result",
      "limitations"
     ],
     "properties": {
      "result": {
       "type": "object"
      },
      "version": {
       "type": "string",
       "const": "maha-demand6/1.0.0"
      },
      "inputHash": {
       "type": "string"
      },
      "productId": {
       "type": "string",
       "const": "csv-import-preflight"
      },
      "resultHash": {
       "type": "string"
      },
      "limitations": {
       "type": "array",
       "maxItems": 16,
       "minItems": 1
      },
      "receiptDigest": {
       "type": "string"
      }
     },
     "additionalProperties": false
    }
   }
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/csv-import-preflight-validator-5ba09402/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from www.mahastrategies.com](https://www.zero.xyz/host/www.mahastrategies.com/llms.txt)