Issue with retrieving the data using Qlik OneDrive Connector V2

[Alyona]

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! 

[Alyona]

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? 

[chrisbrain]

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?

[Alyona]

Hi @chrisbrain!

I run the table "FilesSharedWithMe":

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

[chrisbrain]

@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.

[Alyona]

@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 🙂

[chrisbrain]

@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?

[Alyona]

@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.