{"slug":"city-table-clean-onrender-com-v1-clean-27f4a9","title":"City Table Clean","host":"city-table-clean.onrender.com","method":"POST","resource":"https://city-table-clean.onrender.com/v1/clean","category":"other","description":"City Table Clean: send a Socrata or CKAN city open-data CSV URL (or upload) and get back a cleaned CSV plus a change report: trimmed whitespace, normalized headers, ISO dates, plain numbers, de-duplicated rows, and a per-cell change log.","price_listed":0.02,"price_asked":null,"state":"effects","state_label":"Not tested: has real-world effects","checks_7d":0,"answered_7d":0,"latency_ms_median":null,"reported_calls_30d":0,"reported_payers_30d":0,"networks":["eip155:8453"],"badge":"unverified","paid_checks_7d":0,"paid_ok_7d":0,"example_input":{"body":{"url":"https://data.cityofchicago.org/resource/ijzp-q8t2.csv?$limit=100"},"bodyType":"json","method":"POST","type":"http"},"output_schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"body":{"properties":{"dedupe":{"default":true,"type":"boolean"},"include_changes":{"default":true,"type":"boolean"},"max_rows":{"default":50000,"maximum":50000,"minimum":1,"type":"integer"},"url":{"description":"https URL of a public CSV: Socrata (/resource/xxxx-xxxx.csv, /d/xxxx-xxxx, rows.csv) or CKAN resource/download URL","format":"uri","type":"string"}},"required":["url"],"type":"object"},"bodyType":{"enum":["json","form-data","text"],"type":"string"},"method":{"enum":["POST","PUT","PATCH"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method","bodyType","body"],"type":"object"},"output":{"properties":{"example":{"properties":{"changes":{"items":{"properties":{"action":{"type":"string"},"after":{},"before":{},"column":{"type":["string","null"]},"row":{"type":"integer"}},"type":"object"},"type":"array"},"cleaned_csv":{"description":"Cleaned CSV text","type":"string"},"report":{"description":"Summary: header map, column types, change counts, duplicates removed","type":"object"},"source":{"type":"object"}},"required":["cleaned_csv","report"],"type":"object"},"type":{"type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"},"history":[],"description_full":"City Table Clean: send a Socrata or CKAN city open-data CSV URL (or upload) and get back a cleaned CSV plus a change report: trimmed whitespace, normalized headers, ISO dates, plain numbers, de-duplicated rows, and a per-cell change log.","last_updated":"2026-10-10T17:34:25.821Z","schemes":["exact"]}