Daily reads to utility billing
Each morning the Neptune 360 export is read from the SFTP folder and good reads are posted to the billing system's meter read import.
Advanced metering infrastructure (AMI) systems such as Neptune 360 and Sensus FlexNet collect water meter reads by radio. Utilities use them for daily reads, leak and no-flow alarms, and the billing read file each cycle.
SentraBridge reads AMI export files or API data, checks each read and sends good reads to the utility billing system. This connector is built from public documentation, such as Neptune's file layout, and is confirmed with the utility's own export and account during setup.
| resource | read | write | changes only | fields |
|---|---|---|---|---|
| Daily reads | list | — | yes | Read ID, Meter number, MIU (radio) ID, Account number, Read at, Reading… |
| Meters (endpoints) | list, read one | — | — | Meter number, MIU (radio) ID, Account number, Route, Dials, Unit… |
| Alarms (leak, tamper, no flow) | list | — | yes | Alarm ID, Meter, Type, Raised, Cleared |
Each morning the Neptune 360 export is read from the SFTP folder and good reads are posted to the billing system's meter read import.
Reads with 35 days of no flow, a skipped read or a read error go to the meter team as a list, not into billing.
Leak alarms create a service order in utility billing or a ticket in Zendesk, so staff can call the customer.
Meters reported by AMI are compared with meters in billing to find radio IDs that don't match an account.
Systems cities commonly connect with AMI meter data, each with its own connector page.
Neptune and Sensus license their APIs per utility. Most utilities use the daily export file instead, which SentraBridge reads over SFTP. The Neptune 360 file layout is publicly documented.
Read the export file, check each read for errors and zero flow, map fields to the billing system's read import layout, then post the reads or write the import file.
It is built from public documentation and tested on a SentraBridge sandbox. Paths and file columns are confirmed with your own export and account before anything runs.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.