topic Office 365 SharePoint Connector - specific site authentication in Connectivity & Data Prep

Office 365 SharePoint Connector - specific site authentication

IuliaM — Fri, 17 Feb 2023 07:37:22 GMT

Hello Everyone,

I would like to retrieve data from a 365 SharePoint site. I first tried the normal REST API path which does not work due tot he new authentication method that Microsoft introduce for those sites. I then tried via the web connectors but the Office 365 SharePoint connector requires to authenticate with admin rights against the base URL which in big organizations where everyone is creating a site for different reasons it's just not possible due to the sensitivity of the data.

Has anyone found a way to autheticate/retrieve data without having admin access to all the sites? Maybe using the simple General Web Connector?

Many Thanks

Iulia

Re: Office 365 SharePoint Connector - specific site authentication

Jay_Brown — Thu, 27 Apr 2023 19:21:06 GMT

You should be able to read this data, only using Consent if you are an administrator:

Select a Prompt/consent level:

Consent: Choose this option if you are an administrator.
None: Choose this option if you are a user and your administrator has already consented on your behalf.
select_account: Choose this to select which account to use. This will interrupt single sign-on. It provides a list of all the accounts either in session or any remembered account. Or you can choose a different account entirely.

https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Storage%20provider%20connectors/Office365-Sharepoint-storage-provider-connector.htm