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

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 meeting metadata. Each municipality sets its own boards-to-folders value map; boards without a folder go to the data-quality alert instead of being misfiled.

Try it on your dataAll examples
This flow

8 steps

StartsOn a schedule
SystemsCivicCA, Laserfiche Cloud
Branches2
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: File CivicCA agendas and minutes in LaserficheEvery hour, files each newly published CivicCA agenda and set of minutes in the city's Laserfiche repository, in the folder for that board, with meeting metadata. Each municipality sets its own boards-to-folders value map; boards without a folder go to the data-quality alert instead of being misfiled.Every hourOn a scheduleChanged meetingsGet records · CivicCAAgenda publishedFilterFind the board's folderApply rulesData quality alertRun another flowFile the agendaTransfer file · LaserficheMinutes ready?If / elseFile the minutesTransfer file · LaserficheInvalidYes
StartReadFilesDatabaseChangeDecideWriteAct
§ Step by step

What each step does.

  1. 01 · Start · On a schedule

    Every hour

    • Every hour (workspace time zone)

    Then: Changed meetings

  2. 02 · Read · Get records · CivicCA

    Changed meetings

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

    Then: Agenda published

  3. 03 · Decide · Filter

    Agenda published

    • Keeps only records where agenda_status is published and agenda_pdf_url is not empty

    Then: Find the board's folder

  4. 04 · Change · Apply rules

    Find the board's folder

    • body: copy lf_folder
    • lf_folder: translate with the value map Laserfiche folders by board (else “No Laserfiche folder for this board”)
    • meeting_date: date Y-m-d
    • Records that fail a check leave by the Invalid output

    Then: Invalid → Data quality alert; File the agenda; Minutes ready?

  5. 05 · Files · Transfer file · Laserfiche Cloud

    File the agenda

    • Downloads {{agenda_pdf_url}} in memory
    • Uploads it as {{meeting_date}} {{body}} Agenda.pdf to Laserfiche Cloud, with metadata
    • The file is never stored
  6. 06 · Decide · If / else

    Minutes ready?

    • Yes when minutes_pdf_url is not empty

    Then: Yes → File the minutes

  7. 07 · Act · Run another flow

    Data quality alert

  8. 08 · Files · Transfer file · Laserfiche Cloud

    File the minutes

    • Downloads {{minutes_pdf_url}} in memory
    • Uploads it as {{meeting_date}} {{body}} Minutes.pdf to Laserfiche Cloud, with metadata
    • The file is never stored
§ Value maps

Code tables that ship with it.

Each client edits its own copy, so one template fits every municipality.

Laserfiche folders by board
fromto
City Council101
Planning Commission102
Parks & Recreation Commission103
Which Laserfiche folder (entry ID) holds each board's agendas and minutes. Set per municipality.
§ Systems

Connectors used

Swap any of them for another system with the same kind of data.

§ Next

Keep exploring

SolutionRecords managementSolutionAgendas to the websiteExampleMake a Laserfiche folder for each new Accela permitExamplePublish agendas on the website after the clerk approves

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.

Request a demoBrowse live examples