topic Re: Issue with One Drive v2 connector after upgrading to March 2020 in Connectivity & Data Prep

Issue with One Drive v2 connector after upgrading to March 2020

martinmichalski1 — Fri, 02 Apr 2021 08:57:26 GMT

Hi,

I was using the One Drive v2 connector from May 2019 release (beta) and it was working fine until it expired.

Now, after upgrading to March 2020 and becoming Standard I am receiving an error message when using one of the functions (the rest of the functions are working fine).

The fuction is "Shared Files" and it brings all the files that have been shared to the user. I use it to retreive the folder id where the files I need are.

The error message I get is: "Could not load connector table parameters. (status code = 500. Sequence contains no matching element)"

I was looking at https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-Source-Connectors/OneDrive-V2-Connector.htm and I saw that the function there is called FilesSharedWithMe, instead of SharedFiles. However, if the name of the function changed after the upgrade, I am still seeing the name "Shared Files" at localhost:5555.

I also tried executing the LOAD sentence using

http://localhost:5555/data?connectorID=OneDriveConnectorV2&table=FilesSharedWithMe&appID=

instead of http://localhost:5555/data?connectorID=OneDriveConnectorV2&table=SharedFiles&appID=

but it didn't work.

Can you please help me?

Thanks in advance

Re: Issue with One Drive v2 connector after upgrading to March 2020

chrisbrain — Thu, 04 Jun 2020 07:01:15 GMT

Hi,

So just to clarify - are you saying that in the Qlik Web Connectors web UI in the list of tables you see a table named 'SharedFiles' but not a table named 'FilesSharedWithMe'?

What error do you get when you try running:

http://localhost:5555/data?connectorID=OneDriveConnectorV2&table=FilesSharedWithMe&appID=

Can you also confirm:

Did you upgrade a previous version of qlik web connectors or do a clean install?
A long shot, but can you try clearing your browser cache and seeing if the list of tables changes?

Re: Issue with One Drive v2 connector after upgrading to March 2020

martinmichalski1 — Thu, 04 Jun 2020 13:27:57 GMT

Thanks for your response.

I have tried again using http://localhost:5555/data?connectorID=OneDriveConnectorV2&table=FilesSharedWithMe&appID= and it worked!

It seems that the problem is only with the Qlik Web Connectors web UI. After cleaning cache, I am still seeing the old function, not the new one.

I didn't do a clean install, I followed these instructions: https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Setup-deploy/Upgrading_Qlik_Web_Connectors.htm.

I had to merge the old deploy.config and login.xml files with the new ones (btw, this is very annoying, Qlik should improve the process) and copy the contents of the backed-up version of App_Data and paste it into the new App_Data folder.

Thanks again!

Re: Issue with One Drive v2 connector after upgrading to March 2020

chrisbrain — Thu, 04 Jun 2020 15:10:47 GMT

Hi - OK thanks for checking. I still can't really understand why it would show the old table name but I would recommend trying a clean install rather than having the product in some slightly odd state.