Corona CA 311
Sync Corona 311 service requests into your warehouse.
The Corona CA 311 connector syncs Corona service requests into analytics-ready tables in your data warehouse. Pull service requests, the division and department that own each one and how long it stayed active from the Corona Open Performance Socrata API, with Ingest handling pagination and retries so the tables stay current.
Corona CA 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 Corona CA 311 data in your warehouse or lake, each as its own table on the schedule you pick:
- Service requests
- Request status and closure
- Request types
- Location and district
Authentication
None. The Corona 311 API is public and needs no credential.
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.
Resources
- Corona CA 311 API documentation: https://corstat.coronaca.gov/d/xfgz-r4un
- Every source Ingest connects
- The tables Ingest creates
- Request Corona CA 311