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.
|Custom data||check||All tables and fields|
|API configurable||check||API configuration|
|Fivetran data models|
Follow our step-by-step Mirosoft Lists setup guide to connect your Microsoft lists with your destination using Fivetran connectors.
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.
This schema applies to all Microsoft Lists connectors.
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
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.