Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 (1)
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
Partner - Specialist II
Partner - 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?

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
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
Partner - Specialist II
Partner - 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.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
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
Partner - Specialist II
Partner - 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?

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
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.