Municipal utilityFastAPICIS InfinityAzure

Vendor Data Access Portal for a Municipal Utility

Waste-hauling vendors now check resident eligibility against the utility billing system in real time, instead of emailing spreadsheets back and forth.

The challenge

A municipality's solid waste transfer station relied on an Excel spreadsheet to manually track which utility customers were eligible to use the facility and whether they had already visited. Third-party vendors had no direct way to check eligibility, so staff were fielding lookups by hand against an outdated utility billing customer information system.

What we built

A custom FastAPI web application that lets approved third-party vendors securely fetch customer and account data directly from the municipality's utility billing system, replacing the spreadsheet with a live, authoritative source of truth.

The result

Eligibility and visit checks that used to require a manual lookup are now instant and self-service for vendors, and staff no longer maintain a spreadsheet that could drift out of sync with the source system.

Before and after comparison: before, spreadsheets emailed back and forth with a ~2 day typical turnaround; after, a GET /eligibility API request returns a 200 OK response in under 2 seconds.
Let's talk

Have a manual process slowing your team down?

Tell us what your team copies, re-keys, or emails around every week. We'll show you what it would take to automate it.