Release Notes

January 2025

We have renamed the Folder Path field to Base folder path in the following connector setup forms:

• Amazon S3
• Azure Blob Storage
• Google Cloud Storage
• SFTP
• SharePoint

New connectors created on or after January 2, 2025, will have this change. We are gradually rolling it out to all existing connectors.

December 2024

We have improved the setup experience for Sharepoint connectors. New connectors created on or after December 20, 2024, will have the following changes in the connector setup form:

• Added a new configuration option, Preview Files to perform an intermediate test during configuration
• Added support for displaying fields based on the file type
• Added a new field, Quote character, to use an enclosing character
• Reorganised fields to make the setup form more intuitive
• Removed Infer as an option from the File Type field
• Removed the Enable Advanced Options toggle
• Changed the Null Sequence field to a toggle
• For the Delimiter character(s) field, we now use , as the default value
• For the Line Separator field, we now use \n as the default value

For more information, see our setup instructions and REST API configuration.

We are gradually rolling out these changes to all existing connectors.

November 2024

The SharePoint connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

September 2024

We now restrict API users from triggering File connectors to sync if:

• the append_file_option field has its value set to upsert_file_with_primary_keys
• and the primary keys are not defined in the schema configuration

We also restrict the following actions for such connectors:

• Creating a new connector in an un-paused state via API;
• Updating the connector's paused field to false via API request;
• Forcing the connector sync or re-sync via API request.

July 2024

We have added a new configuration option, Primary Key used for file process and load, in the connector setup form to support syncing files with custom primary keys. You can now select the custom primary keys during the connector configuration and use them to update or insert new rows in your destination. We process the most recently modified files to your destination. For more information, see our setup instructions.

May 2024

Our SharePoint connector now supports syncing Microsoft Excel spreadsheets in Merge Mode. For more information, see our setup instructions.

August 2023

We have updated our sync strategy regarding the Excel files containing formula cells. We now sync the date values of the formula cell results as TIMESTAMP. Previously, we synced them as DOUBLE in our destination.

July 2023

We have changed the default value of the JSON Delivery Mode feature to Packed in the connector setup form. Previously, we used Unpacked as the default value for this feature.

We now support syncing XML files to your destination in Merge Mode. We have added a new option, xml, to the File Type drop-down menu of the connector setup form. We load your XML data into the _data column without flattening it. For more information, see our setup instructions.

We now support custom line separators for CSV files in Merge Mode. You can specify a custom line separator in the Line Separator field of the connector setup form. For more information, see our setup instructions.

We now support multi-character delimiters for CSV files in Merge Mode. You can specify a multi-character delimiter in the Delimiter field of the connector setup form. For more information, see our setup instructions.

June 2023

Our SharePoint connector can now sync packed JSON files in Merge Mode. We have added a new drop-down menu, JSON Delivery Mode, to the connector setup form. The drop-down menu provides you the option to choose how Fivetran should handle your JSON data. For more information, see our setup instructions.

January 2023

Our SharePoint connector is now generally available. Read our SharePoint connector documentation.

We have added a new accessibility option, Access to Limited Sites, to our SharePoint connector. You can now provide access to a specific SharePoint site. For more information, see our setup instructions.

October 2022

We have added the Merge Mode functionality to our SharePoint connector. For connectors created after October 5, 2022, you can now opt to sync multiple files into a single table in your destination. In the connector setup form, select your sync strategy as Merge Mode or Magic Folder. For more information, see our setup instructions.

May 2022

SharePoint is a file storage and collaboration service.

Read our SharePoint connector documentation.