topic Re: Qlik Web Connector Office 365 Sharepoint Connector Issue in Connectivity & Data Prep

Qlik Web Connector Office 365 Sharepoint Connector Issue

Rehan — Fri, 02 Apr 2021 09:07:58 GMT

We are currently using Qlik Web Connectors March 2020. I am trying to connect to the Office 365 sharepoint and running into issues. Below are the steps done so far.

Completed the authentication using the Base URL https://Domain.sharepoint.com/

The web URL is https://domain.sharepoint.com/sites/ABC/Lists/OM%20Approved%20Funding/OM%20Funding%20Datasheet%20View.aspx#, which I can successfully access using the web browser.

I then tried using the ListFolders options with the Sub Site Path as /sites/ABC/Lists/ and when I try to execute getting the message

"There was an error running the table (Failed on attempt 1 to GET. (The remote server returned an error: (404) Not Found.))"

Please see attached message.

Any idea what am I missing here

Re: Qlik Web Connector Office 365 Sharepoint Connector Issue

stevedark — Tue, 26 Jan 2021 07:54:07 GMT

Hi @Rehan

I believe that the SharePoint files folder structure is a tree, so start with no value in the sub site path and then try adding one branch at a time to see if you can find what you need.

It may be that ABC needs to be your site parameter and lists your sub site.

Steve

Re: Qlik Web Connector Office 365 Sharepoint Connector Issue

chrisbrain — Wed, 27 Jan 2021 06:40:19 GMT

@Rehan Yes - to agree with and add to what @stevedark said a little - I would start with the SubSites table with no parameters and confirm the subsite path.

It looks to me like /sites/ABC 'may' be the subsite but I am just guessing a little - the SubSites table might help you here assuming you have the permissions to enumerate sites.

Re: Qlik Web Connector Office 365 Sharepoint Connector Issue

nategreen — Thu, 10 Jun 2021 18:20:12 GMT

@Rehan I am getting the same error - did you ever find a solution?

Re: Qlik Web Connector Office 365 Sharepoint Connector Issue

PadmaPriya — Fri, 11 Jun 2021 22:17:46 GMT

Hello @Rehan

Please refer to below articles:

https://community.qlik.com/t5/Knowledge-Base/Qlik-Web-Connectors-and-Google-Analytics-quot-Failed-on-attempt/ta-p/1775971

https://support.qlik.com/articles/000106463

Thanks,

Padma Priya

Qlik Support

Re: Qlik Web Connector Office 365 Sharepoint Connector Issue

ab9503 — Thu, 17 Aug 2023 15:05:48 GMT

PadmaPriya's links are for different errors. They don't relate to the OP's error. It should not be marked as the answer.

Has anyone solved the OP's question? I'm hitting the same problem.