{"uid":"cap_XO_7lf7f692XnFcIEeIb-","slug":"newbotlabor-csv-cleaner-ca0c3673","name":"NewBotLabor CSV Cleaner","description":"Pay-per-call utilities for autonomous agents, paid with x402 (USDC on Base; no account, no API key).","url":"https://newbotlabor--254ecdfcc2de11f19b541607ee4eb77e.web.val.run/api/csv/clean?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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)"}}},"responseSchema":{"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}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.005","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.005/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.005","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.005","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_sRQfN6ttXlupzDtLFeWoM","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.005","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Cleans, normalizes, and deduplicates CSV text, returning structured output with a summary of fixes and issues.","exampleAgentPrompt":"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.","exampleUseCases":[{"title":"Deduplicating a contact list export","prompt":"I have a CSV export of our mailing list that has a bunch of duplicate entries and messy headers — can you clean it up, remove the exact duplicate rows, normalize the column names to snake_case, and return both the cleaned CSV and JSON so I can review the changes?"},{"title":"Preparing pipeline data for downstream processing","prompt":"Before I load this semicolon-delimited CSV into our database, can you auto-detect the delimiter, trim all the cell whitespace, drop any columns that are completely empty, and give me back the cleaned JSON rows with a summary of what was fixed?"},{"title":"Auditing data quality issues in a spreadsheet export","prompt":"I exported this spreadsheet as a CSV and I want to know what problems are in it — can you run it through the cleaner with deduplication on and return the issues list and summary so I can see what rows had problems?"}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T12:40:54.191Z","isFirstParty":false,"canonicalSlug":"newbotlabor-csv-cleaner-ca0c3673"}