Department drop folder to the database
Staff save a weekly CSV in a SharePoint folder; SentraBridge loads the rows into SQL Server and archives the file.
Files & transfersConnector
SharePoint and OneDrive integration
for city records
SharePoint and OneDrive document libraries are where many city departments keep working files and records: contracts, reports, staff spreadsheets and scanned forms. They come with Microsoft 365.
Pre-built connector
SharePoint / OneDrive library
- Tier
- Pre-built connector
- Category
- Files & transfers
- Sign-in
- sharepoint
- Paging
- single response
§ Overview
What connecting SharePoint does.
SentraBridge reads, writes and archives files in a library through Microsoft Graph. Flows can file documents from other systems into the right folder, or load a spreadsheet staff drop in a folder into a database. Files pass through memory and SentraBridge keeps no copy.
- Files: Read CSV, JSON, XML, fixed-width and other files in a library folder; write new files.
- New files: Start or filter on files added since the last run.
- Archive: Move processed files to an archive folder.
What SentraBridge can do with SharePoint / OneDrive library
| resource | read | write | changes only | fields |
|---|---|---|---|---|
| Files | CSV, JSON, JSON Lines, XML, fixed-width, ACH, BAI2, GeoJSON, Shapefile | write files (including positive pay), transfer documents | yes (new files) | Columns from the file |
§ Use cases
What cities connect SharePoint for.
Signed contracts filed
Completed DocuSign agreements are written to the purchasing contracts library.
Agendas and minutes for records
Published CivicCA agendas and minutes are saved to the clerk's records library by board.
Daily report files
A morning summary of open 311 requests is written as a CSV to the operations team's library.
§ How it works
How to connect SharePoint
- 01Get accessRegister an app in Microsoft Entra ID with a client secret.
- 02Add the connectionGrant Graph Sites.Selected on the one site, or Files.ReadWrite.All.
- 03Preview real recordsHave a tenant admin consent and grant the app access to the site.
- 04Turn it onPick the library and folder, then list files to test.
§ Often connected with
SharePoint and the rest of city hall.
Systems cities commonly connect with SharePoint, each with its own connector page.
CivicCA§ FAQ
SharePoint integration questions
How does SentraBridge access SharePoint?
Through Microsoft Graph with an Entra ID app. Sites.Selected limits it to the sites you grant, which most IT teams prefer over tenant-wide access.
Can SentraBridge load an Excel or CSV file from SharePoint into SQL Server?
CSV files, yes: a flow reads new files in a folder, maps columns and writes rows to SQL Server, then archives the file.
What about SharePoint lists?
Lists use the Microsoft 365 (Graph) connection, which reads and creates list items.
Connect SharePoint / OneDrive library to the rest.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.