Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Alyona
Contributor III
Contributor III

Issue with retrieving the data using Qlik OneDrive Connector V2

Hi, Qlik experts!

 

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

 

Authentication is ok

Alyona_0-1601987336638.png

 

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! 

 

Labels (3)
7 Replies
Alyona
Contributor III
Contributor III
Author

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
Specialist II
Specialist II

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
Contributor III
Contributor III
Author

Hi @chrisbrain!

I run the table "FilesSharedWithMe":

Alyona_0-1601996794753.png

 

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

chrisbrain
Specialist II
Specialist II

@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
Contributor III
Contributor III
Author

@chrisbrain hi!

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

Alyona_0-1602059724513.png

So, you are right, it is really strange 🙂

 

 

chrisbrain
Specialist II
Specialist II

@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
Contributor III
Contributor III
Author

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