{"uid":"cap_ylSofQeNm620cyfXBfB4x","slug":"apiacre-com-data-cleaner-924ac5e1","name":"apiacre.com Data Cleaner","description":"Clean CSV, TSV, JSON, JSON Lines, or YAML records with collision-safe header normalization, deterministic integrity hashes, and exact transformation counts.","url":"https://apiacre.com/v1/data/clean","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"format":{"enum":["csv","tsv","json","jsonl","yaml"],"type":"string"},"content":{"type":"string"},"trim_strings":{"type":"boolean"},"empty_to_null":{"type":"boolean"},"normalize_headers":{"type":"boolean"}}},"responseSchema":{"type":"json","example":{"data":{"rows":1,"records":[{"name":"Ada","score":"98"}],"cleaning":{"version":"apiacre-data-clean/2","trimStrings":true,"sourceFormat":"csv","normalizeHeaders":true,"emptyStringsAsNull":true},"warnings":[],"inputSha256":"421bdab658ee74ca45a19d7f7dbeb56ca7a52f249d7a8a7270eb9c633b5b04c4","outputSha256":"952b31f519c09cf5c34d4ea6439175e6e77411228788aed1af6bec103155a465"},"meta":{"cached":false,"sources":[],"warnings":[],"duration_ms":42,"next_actions":[{"path":"/v1/data/schema","title":"JSON Schema generator","method":"POST","reason":"Infer a reusable Draft 2020-12 contract from the cleaned records.","service":"data.schema"}]},"service":"data.clean","version":"1","request_id":"018f1f54-7f38-7ba2-8dc3-5f90272d9f1a"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","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.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_k3m_761qTyQUuqh_shiNy","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Normalizes JSON record keys, whitespace, and empty values to produce clean, consistent structured data.","exampleAgentPrompt":"Clean this JSON record by normalizing the key names, trimming whitespace from all string values, and removing any empty or null fields: {\"First Name \": \"  Alice \", \"last-name\": \"Smith\", \"email\": \"\", \"phone_number\": null}.","exampleUseCases":[{"title":"Sanitize user form submissions","prompt":"I'm getting form submissions with inconsistent key names and lots of trailing spaces in the values — can you clean this JSON record by normalizing the keys and trimming all the whitespace before I save it to the database?"},{"title":"Normalize third-party API responses","prompt":"This API response I got back has a bunch of empty fields and weirdly formatted key names with dashes and mixed casing — can you clean it up so the keys are consistent and all the blank values are stripped out?"},{"title":"Prepare records for ETL pipeline","prompt":"Before I load these JSON records into our data warehouse, I need to normalize all the key names and remove any null or empty values — can you run this batch of records through a cleaner?"}],"resultDescription":"Returns the input record(s) with keys normalized to a consistent naming convention (e.g. snake_case), string values trimmed of leading/trailing whitespace, and empty or null fields removed, resulting in clean, consistently structured JSON.","failureModes":["Malformed JSON input returns a 400 error","Deeply nested or non-standard structures may not be fully normalized","Key collision after normalization (e.g. two keys that map to the same normalized form) may cause data loss","Non-string values treated as strings during whitespace trimming could cause type errors"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, pay-per-call solution to normalize JSON key formatting, trim string whitespace, and strip empty values without standing up custom ETL logic. Ideal for preprocessing records before database ingestion, API chaining, or schema validation when data arrives from inconsistent sources.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T12:48:30.958Z","isFirstParty":false}