Folder Renames Are Not Reflected in the Destination

Issue

After renaming a SharePoint folder, the corresponding file paths aren't updated in the destination. Files inside the renamed folder appear with their original paths.

Environment

Connector: SharePoint

Resolution

We recommend that you avoid renaming parent folders if you want updated paths reflected in your destination.

If you have already renamed a folder, you can:

• Manually re-sync the affected table. To learn how, see How to Trigger Historical Re-Syncs for Fivetran Tables. We will update the paths during the re-sync, and unchanged rows don't contribute to your Monthly Active Rows (MAR).
• Rename or move the individual files instead of the parent folder. This action generates change events that we can detect and sync.

Cause

When you rename a file, the Microsoft Graph API sends a delete-and-add event for the file's driveItem ID. When this happens, we soft-delete the existing row and insert a new row with the updated path.

However, when you rename a folder, the API doesn't change the driveItem IDs of the files inside it. As a result, we don't detect the change, and we don't update the file paths in your destination.