{"uid":"cap_JNgfsMPAVqI9X18BIZTzA","slug":"tinydata-api-clean-csv-ebcb00fb","name":"TinyData API — Clean CSV","description":"Hash text, encode or decode Base64, and clean CSV. Pay $0.001–$0.01 per successful request in USDC on Polygon via x402.","url":"https://cleanrows-api.lyra-lavende-7298.chatgpt.site/api/clean-csv?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","required":["csv"],"properties":{"csv":{"type":"string","description":"CSV with a header row."},"options":{"type":"object"}}},"responseSchema":{"type":"object","required":["ok","csv","stats"],"properties":{"ok":{"type":"boolean","const":true},"csv":{"type":"string"},"stats":{"type":"object","required":["inputRows","outputRows","duplicateRowsRemoved","emptyRowsRemoved","columns"],"properties":{"columns":{"type":"integer"},"inputRows":{"type":"integer"},"outputRows":{"type":"integer"},"emptyRowsRemoved":{"type":"integer"},"duplicateRowsRemoved":{"type":"integer"}}}}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"registry","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.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_ptygb0gD4B8JrMD0zLAMS","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":null,"unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Cleans a CSV string by removing duplicate and empty rows, returning the sanitized CSV along with row and column statistics.","exampleAgentPrompt":"Clean this CSV for me — remove any duplicate rows and empty rows, and tell me how many were removed: [paste CSV here].","exampleUseCases":[{"title":"Deduplicate exported CRM data","prompt":"I exported our contacts from the CRM and there are a ton of duplicate entries. Can you clean up this CSV, remove all the duplicate and empty rows, and tell me how many were stripped out?"},{"title":"Prepare survey results for analysis","prompt":"I have raw survey response data as a CSV with a header row. Please clean it up by removing blank and duplicate submissions before I run my analysis."},{"title":"Validate ETL pipeline input","prompt":"Before loading this CSV into our database, can you run it through a deduplication pass and show me the stats on how many rows came in versus how many clean rows came out?"}],"resultDescription":"Returns a JSON object with ok: true, the cleaned CSV string, and a stats object containing inputRows, outputRows, duplicateRowsRemoved, emptyRowsRemoved, and columns counts.","failureModes":["Missing or malformed CSV input — validation error returned","CSV with no header row may produce unexpected column stats","Very large CSVs may time out or exceed payload limits","Payment failure (insufficient USDC balance) blocks the request","Malformed options object may cause processing errors"],"whenToPreferThis":"Choose this endpoint when you need a quick, pay-per-use CSV cleaning operation that removes duplicates and empty rows and returns row-level statistics — especially useful in automated data pipelines where lightweight programmatic cleaning is preferable to a full ETL tool.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T04:21:00.497Z","isFirstParty":false,"canonicalSlug":"tinydata-api-clean-csv-ebcb00fb"}