topic Re: Issue with retrieving the data using Qlik OneDrive Connector V2 in Connectivity & Data Prep

Issue with retrieving the data using Qlik OneDrive Connector V2

Alyona — Thu, 23 Dec 2021 15:08:19 GMT

Hi, Qlik experts!

I have the issue with retrieving the data using Qlik OneDrive Connector V2.

Authentication is ok:

But when I try to retrieve some data, I receive the following error message:

There was an error running the table (Failed on attempt 1 to GET. (The remote server returned an error: (403) Forbidden.){ "error": { "code": "accessDenied", "message": "Access denied", "innerError"...

Could anybody help me to fix this issue and retrieve the data from One Drive?

Thanks in advance!

Re: Issue with retrieving the data using Qlik OneDrive Connector V2

Alyona — Tue, 06 Oct 2020 12:57:53 GMT

As one of the solution, I added the following statement to the deploy.config file:

<FileSystemAccessAllowedPaths>*</FileSystemAccessAllowedPaths>

Then I stopped and restarted the "Qlik Web Connector" service. And this change doesn't help me.

Any ideas about other solutions?

Re: Issue with retrieving the data using Qlik OneDrive Connector V2

chrisbrain — Tue, 06 Oct 2020 14:56:39 GMT

Hi Alyona,

The 403 error you are getting looks like it's from the OneDrive API - so not related to the FileSystemAccessAllowedPaths setting which is more to do with reading/writing local files.

Can you provide more info on what table you were running to get the error? Do any of the tables work other than CanAuthenticate?

Re: Issue with retrieving the data using Qlik OneDrive Connector V2

Alyona — Tue, 06 Oct 2020 15:09:15 GMT

Hi @chrisbrain!

I run the table "FilesSharedWithMe":

The same problem I have with other tables, for example, "Drives" and "RecentFiles".

Re: Issue with retrieving the data using Qlik OneDrive Connector V2

chrisbrain — Wed, 07 Oct 2020 07:17:24 GMT

@Alyona Strange. I know this sounds obvious, but can you confirm when you log into the OneDrive web UI with the exact same account you are able to see Drives, recent files, shared files etc.

If possible, it would be great if you could try Microsoft's graph API explorer which should allow you to test the API using a different tool - I could leave some notes here if you are willing.

Re: Issue with retrieving the data using Qlik OneDrive Connector V2

Alyona — Wed, 07 Oct 2020 08:38:33 GMT

@chrisbrain hi!

Yes, in One Drive UI I see all these files. For example, Shared with me:

So, you are right, it is really strange 🙂

Re: Issue with retrieving the data using Qlik OneDrive Connector V2

chrisbrain — Wed, 07 Oct 2020 08:53:44 GMT

@Alyona This is a business account I presume?

When you authenticated with the connector, did you get any step asking you to choose between school/work or other account types?

Re: Issue with retrieving the data using Qlik OneDrive Connector V2

Alyona — Wed, 07 Oct 2020 13:15:59 GMT

@chrisbrain, yes, this is the business account.

During authentication via connector, the system don't ask me about any accounts, because it takes my current business account.