Connecting Airbyte to Sharepoint with limited access

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

How to connect Airbyte to Sharepoint with delegated access instead of full application access


Question

Hi,
I am having issues connecting Airbyte to Sharepoint, Airbyte requires an application to be created on Microsoft Entra (Azure AD) with application access (whcih is full access to the organization’s sharepoint), but my DevOps team does not want to grant application access (full access) to the organization’s sharepoint due to security concerns instead, they would prefer to grant delegated access. Has anyone encountered this before and or does anyone have a suggestion of how best to get sharepoint data in Airbyte with limited access to a specific sharepoint site?

I have gone through the different documentations for both Airbyte and Azure
https://docs.airbyte.com/integrations/sources/microsoft-sharepoint
https://learn.microsoft.com/en-us/graph/auth-v2-service?context=graph%2Fapi%2F1.0&view=graph-rest-1.0&tabs=http#1-register-the-app


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["airbyte", "sharepoint", "microsoft-azure", "delegated-access", "limited-access"]
2

SharePoint is a new connector <@U02BYFSC7NU>. It probably needs some improvements. Could you create a <Sign in to GitHub · GitHub request> to discuss the best way to enhance it?

3

Hi <@U02TQLBLDU4>, what about the OneDrive connector. Could it be used in place of SharePoint with limited access to a particular shared drive?

4

I’ll do a feature request once we try to see how it can work better