Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
johngouws
Partner - Specialist
Partner - Specialist

Qlik Sense Business - OneDrive Connector

Good morning. 

I have been loading excel files from Dropbox, but have someone who wants to load their files from OneDrive. I wonder if anyone has managed to connect to OneDrive? 

@stevedark have you had any experience with OneDrive? 

Thank you. 

Labels (3)
4 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi John,

OneDrive is conspicuous by its absence on Qlik Sense Business, which is odd as it is present and correct on Qlik Web Connectors and the connectors in the Cloud are simply using QWC with a nice front end.

Without a specific connector I think you might struggle here.

As both are Microsoft there may be a way to link between OneDrive and AzureStorage.

There may be a way to loosely couple, by having files which appear in OneDrive be automatically sent elsewhere, such as to a mailbox where it can be retrieved by the IMAP connector. This is obviously less than ideal though.

There is a REST API for OneDrive, which means it may be possible to go that route, but it could be painful. If someone else has already done it there may be code you can crib. The documentation is here if you want to give it a go:

https://docs.microsoft.com/en-gb/onedrive/developer/rest-api/?view=odsp-graph-online

I've some other OAUTH code that I can potentially share, but what I have found is whilst all APIs which use OAUTH have some similarities but no two are exactly the same.

Sorry I can't be of more help.

johngouws
Partner - Specialist
Partner - Specialist
Author

Hi Steve, 

Thank you for that comprehensive reply. 

I previously tried using the REST Connector but could not get it working. I will give it another go using the document you mention. 

If I am successful, I will give feedback. 

Stay Safe...

johngouws
Partner - Specialist
Partner - Specialist
Author

Hi @stevedark.

This morning I was fiddling in my QSB and noticed the OneDrive File connector as well as the OneDrive metadata connectors are there. They must have snuck in in the past few days. 

This is really great news. 

Stay safe...

John

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Thanks for the heads up John.

Next stop, Sharepoint (hopefully).

Steve