ExampleTemplate
Nightly 311 export as a CSV file on SFTP
Every night, writes yesterday's changed Sentra 311 requests to a dated CSV file in an SFTP folder for another system to pick up.
This flow
4 steps
StartsOn a schedule
SystemsSentra 311, SFTP server
Branches0
Stored recordsNone: pass-through
§ The flow
The whole flow, as it appears on the canvas.
Scroll sideways on small screens. Colors show the kind of step: start, read, change, decide, write.
§ Step by step
What each step does.
- 01 · Start · On a schedule
Nightly at 11:30 pm
- Every night at 11:30 pm (workspace time zone)
Then: Changed 311 requests
- 02 · Read · Get records · Sentra 311
Changed 311 requests
- Reads Service requests from Sentra 311
- Only records changed since the last good run
Then: Columns for the file
- 03 · Change · Map fields
Columns for the file
- Shapes each record into 6 fields:
number,category,status,address,opened,closed
Then: Write CSV
- Shapes each record into 6 fields:
- 04 · Files · Write file · SFTP server
Write CSV
- Writes CSV file
sentra311-{{ $today }}.csvtooutbox - One file with every record
- Writes CSV file
§ Systems
Connectors used
Swap any of them for another system with the same kind of data.
Sentra 311Run this flow on your systems.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.