Files still run government.
Move them safely.
Read and write CSV, JSON, JSON Lines and XML over SFTP, and move documents such as agendas, minutes and permit PDFs between systems with their metadata, in memory.
| file | format | contents | after the run |
|---|---|---|---|
| payments-2026-11-10.csv | CSV | 412 rows | read → archive/ |
| payments-2026-11-09.csv | CSV | 388 rows | archive/ |
| inspections.jsonl | JSON Lines | 57 records | read |
| lockbox.xml | XML | <payment> × 96 | waiting |
Bank files, billing exports, inspection drops.
Read files that match a pattern, turn rows into records, and after a good run leave, move or delete them. Write one file per run or one per record, with dated names. Every connection checks the server's saved host key, so a swapped server is refused.
- CSV with any separator, JSON, JSON Lines and XML
- Adds the source file name to each record
- Only files changed since the last good run
Agendas to Laserfiche, PDFs to libraries.
The Transfer file step downloads a document, from a public link or signed in with a connection, and uploads it as a form upload with a metadata part, as a raw body, or to SFTP. The bytes pass through memory and are never stored.
- Laserfiche, SharePoint document libraries, S3 and Azure Blob
- Metadata from the record: board, meeting date, document type
- A test checks that file contents never reach the database
| field | value |
|---|---|
| Board | Planning Commission |
| Meeting date | 2026-11-12 |
| Document type | Agenda |
| Folder | /Clerk/Agendas/Planning Commission |
Email the records as a file.
Send email can attach the records as CSV or JSON: bad rows to finance, a weekly export to a department, a summary to the operations team.
- Summary or one email per record
- Templates in the subject and body
- Failure alerts link to the run
ACH, BAI2, positive pay, fixed-width.
Read NACHA ACH and BAI2 bank files into records, with batch and account totals checked so a short file is refused, not half-loaded. Write positive pay files for your bank, and read or write fixed-width layouts from a simple column spec.
- Control totals checked on read
- Positive pay as CSV or fixed layout
- Fixed-width: start-end or width per column
See it in real flows.
File CivicCA agendas and minutes in Laserfiche
Every hour, files each newly published CivicCA agenda and set of minutes in the city's Laserfiche repository, in the folder for that board, with…
SFTP server → PostgreSQL / PostGISLoad the bank's daily payment file into the city database
Every morning, reads new payment CSV files from the bank's SFTP folder, cleans and checks them, loads them into a database table, and archives the…
Sentra 311 → Amazon S3 / S3-compatibleNightly backup: Sentra 311 requests to S3
Every night, copies all Sentra 311 requests to a dated JSON file in the city's own S3 bucket. The backup lives in the city's storage; SentraBridge…
Questions, answered
Are files kept after transfer?
No. Files are streamed through memory to the destination. Run history records the file name, size and outcome, not the contents.
What about SFTP security?
SentraBridge pins each server's host key and checks it on every connection, and can archive or delete files after a good run.
See your own systems connected.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.