# NewBotLabor CSV Cleaner

> NewBotLabor CSV Cleaner is a paid API for AI agents from newbotlabor--254ecdfcc2de11f19b541607ee4eb77e.web.val.run, paid per call via x402, $0.005/call, status unknown (last checked 2026-10-22).

Cleans, normalizes, and deduplicates CSV text, returning structured output with a summary of fixes and issues.

## Facts

- Endpoint: POST https://newbotlabor--254ecdfcc2de11f19b541607ee4eb77e.web.val.run/api/csv/clean?utm_source=zero.xyz
- Price: $0.005/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-22
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/newbotlabor-csv-cleaner-ca0c3673
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_XO_7lf7f692XnFcIEeIb-

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 newbotlabor-csv-cleaner-ca0c3673 -d '<json body>'
```

Example prompt: Clean up this CSV for me — trim whitespace, remove duplicate rows, drop any fully empty columns, normalize headers to snake_case, and give me back both the cleaned CSV and the JSON rows so I can see what changed.

## When to prefer this

Choose this endpoint when you need a lightweight, pay-per-call (no API key, no account) CSV cleaning utility that handles whitespace trimming, deduplication, header normalization, empty column removal, and delimiter auto-detection in a single call. It is ideal for autonomous agents that process untrusted or user-supplied CSV data before further pipeline steps, especially when you want a structured issues/fixes audit trail alongside the cleaned output.

## Known failure modes

- CSV exceeds 2,000,000 character limit — request rejected
- Malformed CSV that cannot be parsed — returns parse error
- Payment not included or insufficient — 402 Payment Required response
- Invalid enum value for output or headerCase fields — validation error
- Empty CSV input — may return empty output with zero rows

## How this service works

Pay-per-call utilities for autonomous agents, paid with x402 (USDC on Base; no account, no API key).

## Output

A JSON object containing: the cleaned CSV string, an array of JSON row objects (depending on output mode), a columns array with name and type info, a fixes array describing groups of applied transformations, an issues array with per-row problem details (row number, code, detail), and a summary string showing input/output row counts and issue/fix tallies.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "csv": {
   "type": "string",
   "description": "CSV text, max 2,000,000 chars"
  },
  "trim": {
   "type": "boolean",
   "description": "trim cell whitespace (default true)"
  },
  "dedupe": {
   "type": "boolean",
   "description": "remove exact duplicate rows (default true)"
  },
  "output": {
   "enum": [
    "csv",
    "json",
    "both"
   ],
   "type": "string",
   "description": "what to return (default both)"
  },
  "delimiter": {
   "type": "string",
   "description": "field delimiter (default: auto-detect , ; tab |)"
  },
  "headerCase": {
   "enum": [
    "snake",
    "keep"
   ],
   "type": "string",
   "description": "header normalisation (default snake)"
  },
  "dropEmptyColumns": {
   "type": "boolean",
   "description": "drop fully empty columns (default true)"
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "csv": "name,e_mail\nalice,a@x.io\n",
  "fixes": [
   "normalized headers to snake_case",
   "removed 1 duplicate row(s)",
   "trimmed whitespace in 2 cell(s)"
  ],
  "issues": [
   {
    "row": 3,
    "code": "DUPLICATE_ROW",
    "detail": "exact duplicate of row 2; removed"
   }
  ],
  "columns": [
   {
    "name": "name",
    "type": "string",
    "empty": 0
   },
   {
    "name": "e_mail",
    "type": "string",
    "empty": 0
   }
  ],
  "summary": "2 input rows -> 1 output rows, 2 columns; 1 issue(s), 3 fix group(s)",
  "outputRows": 1
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/newbotlabor-csv-cleaner-ca0c3673/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from newbotlabor--254ecdfcc2de11f19b541607ee4eb77e.web.val.run](https://www.zero.xyz/host/newbotlabor--254ecdfcc2de11f19b541607ee4eb77e.web.val.run/llms.txt)