# Netzhandwerker Data Cleaner

> Netzhandwerker Data Cleaner is a paid API for AI agents from tools.netzhandwerker.de, paid per call via x402, $0.002/call, status unknown (last checked 2026-09-14).

Cleans, deduplicates, and normalizes CSV or row data by trimming whitespace, removing empty rows/columns, and inferring data types

## Facts

- Endpoint: POST https://tools.netzhandwerker.de/v1/data/clean
- Price: $0.002/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-14
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/netzhandwerker-data-cleaner-4a7258b2
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_CMEphf5HR3cwA7MIlNcce

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 netzhandwerker-data-cleaner-4a7258b2 -d '<json body>'
```

Example prompt: Clean this CSV for me — trim whitespace, remove duplicates, drop any empty rows and columns, and tell me what changed: datum,firma,umsatz_2025,notiz\n2026-03-01,Bau GmbH,1234.5,\n2026-04-15,Holz AG,980,\n2026-03-01,Bau GmbH,1234.5,

## When to prefer this

Choose this endpoint when you need lightweight, automated CSV or tabular data cleaning with type inference and a structured cleaning report — especially useful in ETL pipelines, before database imports, or when preparing datasets for analysis. It handles both raw CSV text and pre-parsed JSON row arrays, making it versatile for agent workflows that receive data in either format.

## Known failure modes

- Invalid or unparseable CSV text returns an error
- Exceeding 20,000 rows limit may cause rejection
- Ambiguous delimiter not auto-detected if malformed CSV
- Empty input with no csv or rows field returns error
- Conflicting csv and rows fields may cause unexpected behavior

## How this service works

x402-Werkzeuge für autonome Agenten.

## Output

Returns a JSON object containing: cleaned rows array, a report with counts of rows/columns in and out, duplicates removed, values trimmed, and empty rows/columns dropped, plus a schema object with inferred types and null counts for each column, and the source format detected.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "csv": {
   "type": "string",
   "description": "CSV-Text, Trennzeichen wird erkannt"
  },
  "rows": {
   "type": "array",
   "items": {
    "type": "object"
   },
   "maxItems": 20000,
   "description": "Alternativ: Liste von Objekten"
  },
  "trim": {
   "type": "boolean",
   "default": true
  },
  "dedupe": {
   "type": "boolean",
   "default": true
  },
  "delimiter": {
   "type": "string",
   "description": "Trennzeichen erzwingen"
  },
  "drop_empty_rows": {
   "type": "boolean",
   "default": true
  },
  "drop_empty_columns": {
   "type": "boolean",
   "default": true
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "rows": [
   {
    "datum": "2026-03-01",
    "firma": "Bau GmbH",
    "umsatz_2025": 1234.5
   },
   {
    "datum": "2026-04-15",
    "firma": "Holz AG",
    "umsatz_2025": 980
   }
  ],
  "report": {
   "rows_in": 3,
   "rows_out": 2,
   "columns_in": 4,
   "columns_out": 3,
   "type_changes": {},
   "values_trimmed": 0,
   "duplicates_removed": 1,
   "empty_rows_removed": 0,
   "empty_columns_removed": [
    "notiz"
   ]
  },
  "schema": {
   "datum": {
    "type": "date",
    "mixed": false,
    "null_count": 0
   },
   "firma": {
    "type": "string",
    "mixed": false,
    "null_count": 0
   },
   "umsatz_2025": {
    "type": "number",
    "mixed": false,
    "null_count": 0
   }
  },
  "source": "csv",
  "columns": [
   "firma",
   "umsatz_2025",
   "datum"
  ]
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/netzhandwerker-data-cleaner-4a7258b2/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from tools.netzhandwerker.de](https://www.zero.xyz/host/tools.netzhandwerker.de/llms.txt)