SharePoint is a file storage and collaboration service. Fivetran supports syncing files and lists from your SharePoint site to your destination. You can sync multiple files and lists as unique tables to your destination.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture Deletes | ||
| Custom Data | check | All tables and fields |
| Data Blocking | ||
| Column Hashing | ||
| Re-sync | check | Connector level |
| History | ||
| API Configurable | ||
| Priority-first sync | ||
| dbt Package |
Setup guidelink
Follow our step-by-step SharePoint setup guide to connect your SharePoint account with your destination using Fivetran connectors.
Sync overviewlink
The SharePoint connector is a Magic Folder connector. We retrieve all the files from the folder that you specify into your destination. Each file is synced as a separate table in the destination.
We only sync the files inside the specified folder. We ignore nested folders.
You can also use the SharePoint connector to sync your SharePoint lists. We retrieve all the lists from the site you select. Each list is synced as a separate table in the destination.
Schema informationlink
We use the file name (without the extension) as the destination table name. For example, a file called sample.csv is synced as SAMPLE table.
If we find more than one file of the same name, but with different extensions in the folder, we check the last modified dates of the files and sync only the most recently modified file.
For SharePoint lists, we append list_ to the destination table name. For example, a list called cars is synced as LIST_CARS table.