Release Notes
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_optionfield has its value set toupsert_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
pausedfield tofalsevia 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.