{"uid":"cap_m9osozitgX2vu120OoawQ","slug":"reclypse-csv-cleanup-fb7def9f","name":"Reclypse CSV Cleanup","description":"A small CSV cleanup service with explicit rules, flagged exceptions and an audit trail.","url":"https://csv.reclypse.ai/v1/csv/import-cleanup?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","maxLength":65536,"description":"At most 64 KiB of UTF-8 CSV."},"trim":{"type":"array","items":{"type":"string"}},"columns":{"type":"array","items":{"type":"string"},"maxItems":20,"minItems":1,"uniqueItems":true},"mapping":{"type":"object","additionalProperties":{"type":"string"}},"required":{"type":"array","items":{"type":"string"}},"unique_key":{"type":["string","null"]}}},"responseSchema":{"type":"json","example":{"audit":{"rules":{"trim":[],"columns":["id","name"],"mapping":{"id":"ID","name":"Name"},"required":["id"],"unique_key":"id","formula_policy":"Quarantine = + - @ after leading whitespace/BOM, or initial tab/CR/LF; exception CSV uses apostrophe escaping."},"kept_rows":1,"duplicates":[],"input_rows":1,"input_sha256":"17c87163f1ba78f514c48ed219ed3929c3727d36b0c6d8321e96185ef2c0f557","cleaned_sha256":"bebda63964b9a0084a696f940a81ae1b0969d2284eb008b650bf509de06055e7","duplicate_rows":0,"kept_source_rows":[1],"quarantined_rows":0,"exceptions_sha256":"0b764761fe744d32aca0f04cd6896192d4ebb6eb3d608e023d609bebd612e09f","quarantined_source_rows":[],"unmapped_source_columns":[]},"cleaned_csv":"id,name\r\n001,Sample\r\n","exceptions_csv":"source_row,reason,input.ID,input.Name\r\n","quarantined_rows":[]}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"25","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":"$25/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"25","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"25","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_xn8pCsxqwW4fikSfebEiC","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"25","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Cleans, remaps, deduplicates, and validates CSV data according to explicit rules, returning a cleaned CSV, an exceptions CSV, and a full audit trail.","exampleAgentPrompt":"Can you clean up this CSV — keep only the 'id' and 'name' columns, rename 'ID' to 'id' and 'Name' to 'name', require the 'id' column to be present on every row, and use 'id' as the unique key to remove duplicates? Give me back the cleaned CSV plus a report of anything flagged or quarantined.","exampleUseCases":[{"title":"Pre-import data quality check","prompt":"I have this CSV from our vendor and I need to clean it before loading it into the database — keep only columns 'order_id', 'customer_email', and 'amount', make sure 'order_id' is always present and unique, and flag any rows that are missing required fields or look suspicious. Show me the cleaned version and a list of exceptions."},{"title":"Column remapping for schema migration","prompt":"Our upstream data export uses old column names like 'CustID' and 'CustName' but our new system expects 'customer_id' and 'customer_name'. Can you remap the columns in this CSV and trim any extra whitespace from every field, then give me an audit log of what changed?"},{"title":"Deduplication of user upload","prompt":"Users uploaded this CSV of contacts and I suspect there are duplicate entries — use 'email' as the unique key to deduplicate, keep only the columns 'email', 'first_name', and 'last_name', and send me a report showing which source rows were duplicates."}],"resultDescription":"Returns a JSON object containing: a cleaned CSV string with only the specified columns and rules applied, an exceptions CSV listing rows that were flagged (missing required fields, formula-injection attempts, etc.) with the reason and original values, and a detailed audit object including input/output SHA-256 checksums, row counts (kept, duplicate, quarantined), the applied ruleset, and lists of affected source row numbers.","failureModes":["CSV exceeds 64 KiB limit — request is rejected","Malformed CSV that cannot be parsed — error returned","Column names in 'required' or 'unique_key' not found in 'columns' — misconfiguration error","Payment not attached or insufficient — 402 Payment Required","Formula-injection characters (leading +, -, @, =) cause rows to be quarantined rather than kept","Mapping references columns not present in the input — unmapped columns reported in audit"],"whenToPreferThis":"Choose this endpoint when you need a deterministic, auditable CSV cleaning pipeline with explicit rules — column selection, column renaming, required-field enforcement, deduplication by unique key, and automatic quarantine of formula-injection rows. It is ideal for ETL pre-processing, vendor data ingestion, and any workflow where you need a SHA-256-verifiable audit trail of exactly what was changed and why. Prefer it over generic data-wrangling tools when you need structured exceptions reporting and reproducible transformations rather than ad-hoc scripting.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T00:31:33.283Z","isFirstParty":false,"canonicalSlug":"reclypse-csv-cleanup-f25d756d"}