topic Re: Connecting to Office 365 Sharepoint in Connectivity & Data Prep

Connecting to Office 365 Sharepoint

Fri, 02 Apr 2021 07:56:49 GMT

Hello everyone,

I'm trying to load an excel document using the Office 365 sharepoint connector available within the qlik web connectors 2.2.0 but without success.

I entered the sharepoint base url then tried to Authenticate, but how should i get the authentication code?

The popup doesn't display anything, the client_id in the popup link doesn't work as a code neither.

Is there another way to connect (also some documents are not public, so they are accessible only for the logged in user)

stevedark‌

bal

chrisbrain

Appreciate getting your help.

Re: Connecting to Office 365 Sharepoint

chrisbrain — Tue, 25 Apr 2017 14:17:36 GMT

Hi - When you say the 'popup doesn't display anything' - what do you mean? Does a blank window open? Does nothing happen?

Re: Connecting to Office 365 Sharepoint

Tue, 25 Apr 2017 14:26:59 GMT

Hi Chris,

The page that opens displays the attached image (pic1).

And if I click on my name, I'd get the pic2 (attached).

Should I extract the authentication code from the link?

Thanks.

Re: Connecting to Office 365 Sharepoint

chrisbrain — Tue, 25 Apr 2017 14:29:57 GMT

You shouldn't need to extract anything from the browser address bar (if that's what you are suggesting).

Can you not click on the name in pic2 to continue with the auth flow?

Re: Connecting to Office 365 Sharepoint

Tue, 25 Apr 2017 16:20:38 GMT

Ok no problem

But can you please clarify how can I get the authentication code?

As nothing is happening in the web connector interface (image attached) nor in the opened popup.

Appreciate your help

Re: Connecting to Office 365 Sharepoint

Tue, 25 Apr 2017 19:25:27 GMT

In your screen shot there is no Client ID. How did you remove the client id?

What is your connector version? mine is 0.8.6.19733

Thank you!

Re: Connecting to Office 365 Sharepoint

chrisbrain — Wed, 26 Apr 2017 06:53:22 GMT

Client ID has been removed from the latest version.

Jean-Pierre - Can you not click on the name in pic2 to continue with the auth flow?

Re: Connecting to Office 365 Sharepoint

Wed, 26 Apr 2017 07:51:50 GMT

Chris,

Thanks for your follow-up.

I can assure you I am not clicking on anything

That's the url that's opened in the popup window:

https://login.microsoftonline.com/common/oauth2/authorize?client_id=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx&scope=user_impersonation&response_type=code&redirect_uri=https://connector.qlik.com/auth/oauth/v2.htm&state=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx&prompt=consent

Yesterday I tried taking the client_id part and use it as authentication code, but I was getting the below error:

An error occurred while trying to authenticate. (status code = 500, Invalid authentication code [1])

Vishnu,

That's the connector version 0.8.8.20138

It's found in the qlik web connectors 2.2.0.

Thanks

Re: Connecting to Office 365 Sharepoint

chrisbrain — Wed, 26 Apr 2017 09:03:55 GMT

I would like to do a quick screen share with you, but I can't figure out how to DM you.

Re: Connecting to Office 365 Sharepoint

ravireddyk — Wed, 26 Apr 2017 13:17:38 GMT

Hi Chris,

I am having some issues with connecting share point using QWC 220 office 365 SharePoint connector .below is the error I am getting.

There was an error running the table (status code = 500, Failed on attempt 1 to GET. (The remote server returned an error: (404) Not Found.), HttpStatusCode: NotFound, StatusCode: 404, StatusDescription: Not Found, Message: The remote server returned an error: (404) Not Found., ResponseBody: <?xml version="1.0" encoding="utf-8"?><m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><m:code>-2147024894, System.IO.FileNotFoundException</m:code><m:message xml:lang="en-US">File Not Found.</m:message></m:error>)

Can you please suggest.

Thanks,

Re: Connecting to Office 365 Sharepoint

Wed, 26 Apr 2017 20:26:58 GMT

Thanks Chris!

I downloaded it from the Qlik market.Where can i get the latest one?

Re: Connecting to Office 365 Sharepoint

drh — Thu, 27 Apr 2017 11:25:40 GMT

Hi Ravinder,

It's hard to say what the problem is when we don't know which table you are using and your input, but according to the error message there was no file found. Seems like you are trying to get a file which doesn't exists.

Re: Connecting to Office 365 Sharepoint

ravireddyk — Thu, 27 Apr 2017 13:22:25 GMT

Hi Adam,

I have a excel sheet in my share point and i am trying to get that working into Qliksense. when i am using Office 365 sharepoint connector it gives me the list and i don't see the excel file in that and when i copy the URL to Qliksene and trying to fetch it using web file it gives me internal server error. can you please assist me how to come over please.

Thanks

Re: Connecting to Office 365 Sharepoint

drh — Thu, 27 Apr 2017 13:42:45 GMT

Is Qlik Web Connector running when you are trying to load into Qlik Sense?

Re: Connecting to Office 365 Sharepoint

ravireddyk — Thu, 27 Apr 2017 13:45:28 GMT

Yes, it is running

Re: Connecting to Office 365 Sharepoint

drh — Thu, 27 Apr 2017 14:06:51 GMT

Please attach images from both the sharepoint connectors result script and also your webfile.

Re: Connecting to Office 365 Sharepoint

ravireddyk — Thu, 27 Apr 2017 14:37:00 GMT

Adam,

Sure i am going to bring some images.

Once more question like i have excel sheet in share point.

I have connected to share point and i can authenticate and i can run parameters and now i can see couple of list which are in share point but i don't see the excel file in lists.

Base URL : https://domain.sharepoint.com

Authentication code pasted and saved.

Original path: https://domain.sharepoint.com /team/Analytic_Consumption_Tools_Engagement_Portal/Shaerd%20documents/ xyz.xlsx

Coming to LISTS:

Base URL and Authentication Token will be remain same.

Sub Site Path : /team/Analytic_Consumption_Tools_Engagement_Portal/

I have saved runned and inputs and i can see the list of tables with some id's and list of fields and i am looking for excel file and how do i mention the particular excel file which is above orginal path URL.

Please suggest.

Thanks,

Ravinder

Re: Connecting to Office 365 Sharepoint

drh — Fri, 28 Apr 2017 06:11:05 GMT

Have you tried ListFiles table?

You can use this to get the UniqueId of you excel sheet and then go to GetFile Table and insert the UniqueId and run the table. You will get an URL link which you can use in Qlik Sense Web File.

Regards

Adam

Re: Connecting to Office 365 Sharepoint

drh — Fri, 05 May 2017 08:32:01 GMT

Hi Ravinder,

Did this solution solve your problem?

Re: Connecting to Office 365 Sharepoint

ravireddyk — Wed, 17 May 2017 13:42:57 GMT

Hi Adam,

Still i don't see the excel file getting from the QWC220 and this time when i am connecting to share point via QWC220 it was giving below error's

There was an error running the table (Failed on attempt 1 to GET. (The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.))