need to connect to excel stored on sharepoint 365

[Sundaram Sridharan]

I need to be able to open an excel file stored on sharepoint that is part of office 365. Our spotfire version is 7.11. I can go to the sharepoint and get the URL for the excel and it looks like a valid URL (http://sharepoint.........) - I then stripped of whatever was after ".....xlsx" and then tried that link on File-Open - it works fine and I can read it in and create the visualizations. But if I save that file and pass it on to another team member, they get file open error - my suspicion is that it downloads the excel and uses a local cached link and this doesn't work for someone else. I am aware of OData conenction but not sure how to use it - it talks about creating a listsvc URL and try it on the IE but I don't know how to construct such a link from the excel file link. Any help is appreciated.

[Sundaram Sridharan]

I found the following description at the official site on connecting to sharepoint: Note the blurb under Notes - this does not apply to office 365 sharepoint. I am trying to connect to an excel file on office 365 sharepoint - the way I was pasting in the sharepoint links worked in the previous versions but not in office 365 - something has changed. after seting up all the visualizations, if I go to data file properties I see a locally cached link (like C:Users....) and hence subsequence atempts to open it fails

https://support.tibco.com/s/article/Setting-up-the-Spotfire-OData-connector-to-be-used-with-Microsoft-SharePoint

Details

 Setting up the Spotfire OData connector to be used with Microsoft SharePoint.

Resolution

 Note: This article does not apply for Office 365 SharePoint.

The OData connector supports getting data through Web Services using the OData protocol. As long as the service meets all the requirements for the OData protocol, it should work with Spotfire. Microsoft is the vendor for the SharePoint web service, so we recommend that you contact Microsoft to find out what URL to use when you need to get data from Excel workbooks through SharePoint and OData. These are some useful references on the Microsoft Developer Network (MSDN) site:

[Khushboo Rabadia]

Connecting to Sharepoint 365 is currently an enhancement request which is under consideration.

 

https://ideas.tibco.com/ideas/TS-I-5695

 

Please vote for the above.

One option you can give a try is to map like a network drive and then access those excel files.

https://bauensolutions.com/2017/01/20/how-to-map-your-sharepoint-online-library-like-a-network-drive/Another workaround would be to make use of TIBCO Data Virtualization(TDV/composite)

which requires a separate license. In TDV you need to create and publish a view from the

Sharepoint Office 365 and then make use of TDV connector or Information designer in Spotfire

to connect to TDV.