Kansas City 311
Sync Kansas City 311 service requests into your warehouse.
The Kansas City 311 connector syncs Kansas City service requests into analytics-ready tables in your data warehouse. Pull 311 call center reported issues with issue type and subtype, current status, report source, owning work group and days to close from the Socrata Open Data API on data.kcmo.org, with Ingest handling pagination and retries so the tables stay current.
Kansas City 311 is not a certified connector yet. Ingest authors one from the vendor's API documentation when a customer asks for it, runs it against the real API, and only then lists it as deployable. Request it and it moves up the queue.
What you can sync
Ingest lands the following Kansas City 311 data in your warehouse or lake, each as its own table on the schedule you pick:
- Service requests
- Request status and closure
- Issue types and subtypes
- Department work group
Authentication
None. The Kansas City 311 API is public and needs no credential. A Socrata app token is optional and only raises the rate limit.
Credentials go into a form, never into a chat, and are held in a secret store under your own path. Only the key NAMES ever reach the control database.