St. Louis 311
Sync St. Louis 311 service requests into your warehouse.
The St. Louis 311 connector syncs Citizens' Service Bureau requests into analytics-ready tables in your data warehouse. Pull service requests, their status and closure, the hierarchical service list and service definitions, and request locations from the City of St. Louis CSB Open311 GeoReport v2 API, with Ingest handling auth, pagination, and retries so the tables stay current.
St. Louis 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 St. Louis 311 data in your warehouse or lake, each as its own table on the schedule you pick:
- Service requests
- Request status and closure
- Service list and definitions
- Request location
Authentication
API key. Request a free CSB API key on the City of St. Louis City API sign-up page at https://www.stlouis-mo.gov/government/departments/information-technology/web-development/city-api/sign-up.cfm; it is passed as the api_key query parameter.
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.