Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Microsoft Outlook

Answered
integrations team User

Currently, the Fivetran OneDrive connector requires an ID-based folder URL containing both id=<...%21...> and cid=<...> parameters.

However, when using personal/consumer OneDrive accounts, the folder URL displayed in the browser is typically path-based (e.g., https://onedrive.live.com/my?id=%2Fpersonal%2F...%2FDocuments%2FFivetran_Test), which is not accepted by the connector.

As a workaround, users must access Microsoft Graph Explorer to retrieve the folder's webUrl, manually extract the folder ID, and encode special characters (such as replacing ! with %21) to construct a URL that the connector accepts.

Requested enhancement:

We would like Fivetran to improve the OneDrive connector setup experience in one of the following ways:

  1. Automatic URL resolution: Allow users to provide the standard path-based folder URL from their personal OneDrive account and automatically resolve it into the required ID-based URL.

  2. Improved setup documentation: Update the OneDrive setup guide with explicit instructions for personal/consumer OneDrive accounts, including how to retrieve the required folder ID and construct a valid URL.

Ideally, supporting path-based URLs directly would eliminate the need for users to rely on Microsoft Graph Explorer and manually construct folder URLs.

This enhancement would simplify onboarding, reduce configuration errors, and make the connector more user-friendly for customers using personal OneDrive accounts.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Fivetran Fivetranner

    Hi there,

    Thanks for the suggestion! I'd like to understand this request in more detail before we evaluate it.

    Most of our Microsoft file usage today comes from SharePoint, which works with Microsoft 365 organization accounts. Can you help us understand your use case for syncing data from personal Microsoft accounts' OneDrive? Also, are any of the files you sync stored in SharePoint sites or in OneDrive for work or school?

    Any extra context on data volumes, sync frequency, and downstream uses would be helpful. It would also help to know whether your team sets up each connection or your end users do.

    Thank you,
    Parmeet