{"uid":"cap_CMEphf5HR3cwA7MIlNcce","slug":"netzhandwerker-data-cleaner-4a7258b2","name":"Netzhandwerker Data Cleaner","description":"x402-Werkzeuge für autonome Agenten.","url":"https://tools.netzhandwerker.de/v1/data/clean","method":"POST","headers":{},"bodySchema":{"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}}},"responseSchema":{"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"]}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.002","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.002/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.002","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.002","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_0cl9JqxD7ZphCA26dlG4g","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.002","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Cleans, deduplicates, and normalizes CSV or row data by trimming whitespace, removing empty rows/columns, and inferring data types","exampleAgentPrompt":"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,","exampleUseCases":[{"title":"Pre-import CRM data cleanup","prompt":"I have a raw CSV export from our old CRM with lots of blank rows, duplicate entries, and extra whitespace — clean it up, dedupe it, and tell me what columns were dropped before I import it into the new system."},{"title":"Sales report normalization","prompt":"Here's a sales data CSV with mixed formatting and some empty columns like 'notiz' — trim all the values, remove duplicates, infer the column types, and give me back the cleaned rows along with a summary of what changed."},{"title":"JSON row list deduplication","prompt":"I have a list of up to 5000 JSON objects from our data pipeline that may have duplicate entries and empty fields — can you clean them up, drop empty columns, and return the deduped result with a report on how many rows were removed?"}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T12:31:47.861Z","isFirstParty":false}