# CSV Import Rehearsal Analyzer

> CSV Import Rehearsal Analyzer is a paid API for AI agents from mcp-factory.bowling-anthony.workers.dev, paid per call via x402, $0.03/call, status unknown (last checked 2026-09-15).

Validates and analyzes CSV data rows for import readiness, returning per-row errors, accepted/rejected status, normalized corrections, and a summary.

## Facts

- Endpoint: POST https://mcp-factory.bowling-anthony.workers.dev/csv-import-rehearsal/analyze
- Price: $0.03/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/csv-import-rehearsal-analyzer-4511baa6
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_4a_j7rhaqR66RYc9uEDGD

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-rehearsal-analyzer-4511baa6 -d '<json body>'
```

Example prompt: Can you rehearse this CSV import for me and tell me which rows would be accepted or rejected, what errors are in each row, and what normalizations were applied? Here's the CSV data: id,name,when,active,amount\n1,Doe Jane,2024-02-29,true,012.50\n2,,not-a-date,false,-3

## When to prefer this

Choose this endpoint when you need a structured, row-level validation report before committing a CSV to a real import — especially when you want to identify type mismatches, missing required fields, and applied normalizations in a single pass. It is ideal for agent-driven ETL pipelines, customer-data onboarding flows, or any workflow where you want a rehearsal/dry-run before writing data to a database.

## Known failure modes

- Malformed CSV input with no parseable headers returns an error response
- Rows with ambiguous date formats may produce type_mismatch errors even for borderline-valid inputs
- Payment failure (insufficient USDC balance on Base) results in a 402 response blocking execution
- Very large CSVs may time out if the Cloudflare Worker execution limit is hit
- Missing required columns in the schema definition may cause all rows to be rejected

## How this service works

Customer-input analysis tools with per-call x402 v2 USDC payments on Base. Discovery and examples are free.

## Output

A JSON object with per-row results (index, accepted boolean, parsed values, and a list of errors with code, line, column, and message), plus a headers array, a summary (total rows, accepted count, rejected count), and a corrections array detailing each normalization applied (before/after values, column, and reason).

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "ok": true,
  "rows": [
   {
    "index": 1,
    "errors": [],
    "values": {
     "id": "1",
     "name": "Doe, Jane",
     "when": "2024-02-29",
     "active": true,
     "amount": "12.50"
    },
    "accepted": true
   },
   {
    "index": 2,
    "errors": [
     {
      "code": "required_missing",
      "line": 3,
      "column": "name",
      "message": "required value is blank"
     },
     {
      "code": "type_mismatch",
      "line": 3,
      "column": "when",
      "message": "expected a valid YYYY-MM-DD date"
     }
    ],
    "values": {
     "id": "2",
     "name": null,
     "when": null,
     "active": false,
     "amount": "-3"
    },
    "accepted": false
   }
  ],
  "headers": [
   "id",
   "name",
   "amount",
   "active",
   "when"
  ],
  "summary": {
   "rows": 2,
   "accepted": 1,
   "rejected": 1
  },
  "corrections": [
   {
    "row": 1,
    "after": "12.50",
    "before": "012.50",
    "column": "amount",
    "reason": "normalized decimal format"
   },
   {
    "row": 2,
    "after": "",
    "before": " ",
    "column": "name",
    "reason": "trimmed whitespace"
   }
  ],
  "formula_cells": []
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/csv-import-rehearsal-analyzer-4511baa6/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from mcp-factory.bowling-anthony.workers.dev](https://www.zero.xyz/host/mcp-factory.bowling-anthony.workers.dev/llms.txt)