Release Notes
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.
January 2024
Our Box 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 Box 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.
August 2022
We have added the Merge Mode functionality to our Box connector. For connectors created after August 25, 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.
February 2022
The Box connector now supports syncing Microsoft Excel spreadsheets to your destination. We sync each worksheet in the spreadsheet as a unique table in your destination. We are gradually rolling out this improvement to all our existing connectors.
October 2021
You can now configure your Box connector using the Fivetran REST API. This feature is available only for Standard, Enterprise, and Business Critical accounts.
August 2021
Our Box connector is now generally available.
Read our Box connector documentation.
October 2020
Box is an online file sharing and cloud content management service for businesses.