ExampleTemplate
Publish OpenGov permits to the open-data portal
Nightly, upserts changed OpenGov permit records into a Socrata / Tyler Data & Insights dataset.
This flow
4 steps
StartsOn a schedule
SystemsOpenGov Permitting & Licensing, Socrata / Tyler Data & Insights
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 3 am
- Every night at 3:00 am (workspace time zone)
Then: Changed OpenGov records
- 02 · Read · Get records · OpenGov Permitting & Licensing
Changed OpenGov records
- Reads Records from OpenGov Permitting & Licensing
- Only records changed since the last good run
Then: Public fields only
- 03 · Change · Map fields
Public fields only
- Shapes each record into 5 fields:
record_number,record_type,status,address,updated
Then: Upsert into the dataset
- Shapes each record into 5 fields:
- 04 · Write · Send records · Socrata / Tyler Data & Insights
Upsert into the dataset
- Creates Dataset rows (set the dataset variable, e.g. abcd-1234) in Socrata / Tyler Data & Insights
§ Systems
Connectors used
Swap any of them for another system with the same kind of data.
Run this flow on your systems.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.