Microsoft Lists is a Microsoft 365 application for work management and tracking. A list is a collection of data that you can share with your team. Fivetran supports syncing lists from your SharePoint site to your destination. You can sync multiple lists as unique tables to your destination.
NOTE: To sync documents from your SharePoint site, use our SharePoint connector. We retrieve every document from your SharePoint folder and sync each document as a seperate table in the destination.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | |
| Custom data | check | All tables and fields |
| Data blocking | ||
| Column hashing | ||
| Re-sync | check | Connector level |
| History | ||
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
Setup guidelink
Follow our step-by-step Mirosoft Lists setup guide to connect your Microsoft lists with your destination using Fivetran connectors.
Sync overviewlink
Use the Microsoft Lists connector to sync your lists. We retrieve all the lists from the site you select. Each list is synced as a separate table in the destination.
We add a metadata table to your destination. The metadata table contains the metadata of the lists that we sync.
Schema informationlink
This schema applies to all Microsoft Lists connectors.
To zoom, open the ERD in a new window.
We use a combination of the site name and list name as the destination table name. For example, a list called cars in a site site is synced as SITE_CARS table.
For the metadata table, we use the site name as the destination table name.
For more information about the schema and table naming rule set, see our naming conventions documentation.