Connecting to Office365/Sharepoint via REST and OAuth

juraj_misina — Thu, 11 Oct 2018 08:12:33 GMT

Hi everyone,

I'm struggling to connect Qlik Sense to Sharepoint Online (O365) via REST API using OAuth authentication method. I've done this successfully before, but this time it does not work. I have followed this article to set up the authentication. I’ve obtained Access Token and Refresh Token, but when I try to access any data using that Access Token (for example: https://domain.sharepoint.com/sites/pwa/_api/ProjectData/Projects), I get error 403 with additional response header

X-MSDAVEXT_Error →917656; Access denied. Before opening files in this location, you must first browse to the web site and select the option to login automatically.

I’ve googled around and found a few articles with possible solutions, but nothing helped. Did anyone faced/solved this issue?

PS: I know this is not Qlik specific issue, but if anybody here could point me in the right direction, that would be great.

Thanks a mile.

Juraj

Re: Connecting to Office365/Sharepoint via REST and OAuth

AlexOmetis — Wed, 12 Dec 2018 13:37:45 GMT

Any reason you're not using the Qlik Web Connector for this? https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-Source-Connectors/Office-365-Sharepoint-Connector.htm

topic Connecting to Office365/Sharepoint via REST and OAuth in Connectivity & Data Prep

Connecting to Office365/Sharepoint via REST and OAuth

Re: Connecting to Office365/Sharepoint via REST and OAuth