Loading shared One Drive Excel data into Qlik Sense

[craggus]

Morning,

Currently having problems loading an excel file that someone has shared with me in One Drive... I've completed most of the steps needed, but am unsure how to complete the process.

Using the OneDrive Web Connector, I have authenticated to my own One Drive account.

Using the FilesSharedWithMe option I have obtained the remoteItem_parentReference_driveId and remoteItem_id of the Excel file that my colleague has shared with me.

But now I have this information, what script do I now use to load this excel data into Qlik Sense? The automatic script generated from the Item option in the Web Connector simply provides details about the file itself when loaded into Qlik Sense (id, name, createdDateTime, size etc), and the GetRawFileAsBinary or GetRawFileAsText options are not readable.

Sure I'm missing obvious, but no idea what it is... !

Many Thanks

Craig

[williejacobs]

Hi @craggus 

I have tried the Web Connector before, but found that the OneDrive Connector works better for me.

I would suggest giving that a try. 
The script then works the same as loading data from a local file.

OneDrive | Qlik Connectors Help

Regards,
Willie