Site List Fails to Load During Setup

Issue

While adding a connection, the Sync Lists From Site drop-down menu takes too long to load or crashes the page after loading.

Environment

Connector: Microsoft Lists

Resolution

To resolve this issue, do the following:

1. In Fivetran, go to your Microsoft Lists connection page.
2. Select the Setup tab.
3. Click Edit connection.
4. Set the Use Input Field for Site toggle to ON.
5. The Sync Lists From Site field changes from a drop-down menu to a text input field. Enter the site using the format {hostname},{siteCollectionId},{siteId}.

Cause

This issue may occur when you have access to a large number of SharePoint sites, such as more than 10,000.

Each time we load the Sync Lists From Site drop-down menu, we call the Microsoft API to fetch all sites available to the user. The API returns approximately 220 to 230 sites per call. If you have access to thousands of sites, we must make many sequential API calls, which can cause significant delays or browser crashes while populating the list.