{"uid":"cap_P35iOM2EJFyb2S6vPxC8T","slug":"api-strale-io-a658f013","name":"CSV Cleaner – Fix Delimiters, Encodings & Formatting Issues","description":"Clean messy CSV: fix inconsistent delimiters, mixed encodings, BOM, trailing commas, quoted fields. Returns clean CSV with issues report.","url":"https://api.strale.io/x402/csv-clean","method":"GET","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method"],"properties":{"type":{"type":"string","const":"http"},"method":{"enum":["GET","HEAD","DELETE"],"type":"string"},"queryParams":{"type":"object","required":["csv"],"properties":{"csv":{"type":"string","description":"Messy CSV string to clean"}}}},"additionalProperties":false}}},"responseSchema":null,"example":{"request":{"csv":"name,age,city\r\nAlice,30,New York\r\nBob,25,Los Angeles\r\nCharlie,35,Chicago"},"response":{"csv":"name,age,city\nAlice,30,New York\nBob,25,Los Angeles\nCharlie,35,Chicago","_meta":{"payment":{"method":"x402","price_usd":0.0216,"settlement_id":"0x90c13478c6e24a0d0999b2ef752da1c4bb46604f684d609f9b5a90175dda84f7"},"capability":"csv-clean","latency_ms":0,"provenance":{"source":"algorithmic","fetched_at":"2026-06-13T04:25:59.380Z"}},"row_count":4,"column_count":3,"issues_fixed":[],"detected_delimiter":","}},"exampleRequest":{"csv":"name,age,city\r\nAlice,30,New York\r\nBob,25,Los Angeles\r\nCharlie,35,Chicago"},"tags":["x402"],"displayCostAmount":"0.0216","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"settled","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.0216/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.0216","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.0216","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_sdLrsvDfL_0YRo9iJJEEE","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.0216","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Cleans messy CSV strings by fixing inconsistent delimiters, mixed encodings, BOM markers, trailing commas, and malformed quoted fields, returning a clean CSV plus an issues report.","exampleAgentPrompt":"Can you clean up this CSV for me — it has inconsistent delimiters, some BOM characters, and a few malformed quoted fields? Here's the raw string: 'name,age,,city\\r\\nAlice,\"30,New York\\nBob;25;\"Los Angeles\"'","exampleUseCases":null,"resultDescription":"Returns a cleaned CSV string with all formatting issues resolved, along with a structured issues report detailing what problems were found and fixed (e.g. BOM removed, delimiters normalized, encoding corrected, trailing commas stripped).","failureModes":["Empty or missing 'csv' query parameter returns an error","Extremely large CSV strings may hit request size limits","Ambiguous delimiter cases may be resolved incorrectly if multiple delimiter types are equally distributed","Non-CSV binary data passed as input may produce unexpected output","Payment failure (402) if USDC balance is insufficient"],"whenToPreferThis":"Choose this endpoint when you have raw, dirty CSV data that needs normalization before ingestion, parsing, or storage — especially when dealing with files exported from multiple sources with inconsistent formatting, encoding issues, or BOM markers that break standard CSV parsers.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T00:48:04.162Z","isFirstParty":false}