Qlik Community

Ask a Question

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
johngouws
Partner
Partner

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
Luminary Alumni
Luminary Alumni

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
Partner
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
Partner
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
Luminary Alumni
Luminary Alumni

Thanks for the heads up John.

Next stop, Sharepoint (hopefully).

Steve