Pass-through integration for local government · records are never stored System status1-559-251-7767Sentra familySign in
SentraBridgeIntegration platform
ExampleTemplate

New pothole requests become Scheduler visits

Every 15 minutes, takes new or changed pothole requests from Sentra 311 and creates a visit for the street repair crew in Sentra Scheduler.

This flow

5 steps

StartsOn a schedule
SystemsSentra 311, Sentra Scheduler
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.

Flow diagram: New pothole requests become Scheduler visitsEvery 15 minutes, takes new or changed pothole requests from Sentra 311 and creates a visit for the street repair crew in Sentra Scheduler.Every 15 minutesOn a scheduleChanged 311 requestsGet records · Sentra 311Open potholesFilterShape as a visitMap fieldsCreate Scheduler visitSend records · Sentra Scheduler
StartReadFilesDatabaseChangeDecideWriteAct
§ Step by step

What each step does.

  1. 01 · Start · On a schedule

    Every 15 minutes

    • Every 15 minutes (workspace time zone)

    Then: Changed 311 requests

  2. 02 · Read · Get records · Sentra 311

    Changed 311 requests

    • Reads Service requests from Sentra 311
    • Only records changed since the last good run
    • At most 500 records per run

    Then: Open potholes

  3. 03 · Decide · Filter

    Open potholes

    • Keeps only records where category is Pothole and status is one of open, in_progress

    Then: Shape as a visit

  4. 04 · Change · Map fields

    Shape as a visit

    • Shapes each record into 6 fields: description, site_address, crew_id, priority, external_ref, scheduled_for

    Then: Create Scheduler visit

  5. 05 · Write · Send records · Sentra Scheduler

    Create Scheduler visit

    • Creates Visits in Sentra Scheduler
§ 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.