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

Publish agendas on the website after the clerk approves

Every morning, finds upcoming meetings with a published agenda in CivicCA and asks the city clerk to approve them. Approved agendas become pages on the Sentra CMS website; nothing is published without a yes.

This flow

6 steps

StartsOn a schedule
SystemsCivicCA, Sentra CMS
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: Publish agendas on the website after the clerk approvesEvery morning, finds upcoming meetings with a published agenda in CivicCA and asks the city clerk to approve them. Approved agendas become pages on the Sentra CMS website; nothing is published without a yes.Weekdays at 8 amOn a scheduleGet meetingsGet records · CivicCAUpcoming, agendapublishedFilterClerk approvesWait for approvalShape as a web pageMap fieldsCreate website pageSend records · Sentra CMS
StartReadFilesDatabaseChangeDecideWriteAct
§ Step by step

What each step does.

  1. 01 · Start · On a schedule

    Weekdays at 8 am

    • Cron 0 8 * * 1-5 (workspace time zone)

    Then: Get meetings

  2. 02 · Read · Get records · CivicCA

    Get meetings

    • Reads Meetings from CivicCA
    • Only records changed since the last good run

    Then: Upcoming, agenda published

  3. 03 · Decide · Filter

    Upcoming, agenda published

    • Keeps only records where meeting_date is after {{ $today }} and agenda_status is published

    Then: Clerk approves

  4. 04 · Decide · Wait for approval

    Clerk approves

    • Pauses and emails [email protected]: “Publish {{count}} agendas to the website”
    • Only record IDs are kept while it waits
    • On approval, the records are read again from the source
    • Expires after 48 hours without an answer

    Then: Shape as a web page

  5. 05 · Change · Map fields

    Shape as a web page

    • Shapes each record into 5 fields: title, path, type, status, body

    Then: Create website page

  6. 06 · Write · Send records · Sentra CMS

    Create website page

    • Creates Pages in Sentra CMS
§ 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.