Loading List Data from SharePoint

Important: For the best experience, use the connector for Microsoft SharePoint Online when you want to access list data from Microsoft SharePoint Online.

You can use the OData connector to load data from any web service complying with the OData standard. Below is an example on how this could be used to load list data from SharePoint. Note that this is just an example of how web services can be reached using this connector.

Loading list data from SharePoint:

1. Click Files and data .

2. In the Files and data flyout, click Connect to.

3. In the list of connectors, click OData.

4. In the OData flyout, click New connection.
   Comment: Alternatively, to add the connection to the library instead, select Data > Manage Data Connections, locate the folder where you want to save the connection, then click Add New > Data Connection and select OData.

5. In the OData Connection dialog, in the Service URL field, paste the URL corresponding to the data you want to load from SharePoint into Spotfire.

   Comment: You need to modify the URL before pasting it into the field. To learn how the URL should be constructed, see Modifying the SharePoint URL.

6. Select Windows authentication in the Authentication method drop-down list.

7. Make sure the correct username is shown in the Username field.

8. Type your Windows password.

9. Click Connect.

10. In the Views in Connection dialog, add the data, and click OK twice to load the data into Spotfire.

    Comment: For general information about loading data into Spotfire, see Loading Data Overview.

Modifying the SharePoint URL:

To load data from SharePoint you need to construct the URL in the following manner before pasting it into the Service URL field:
http://<server>/<sharepoint-site-url>/_vti_bin/listdata.svc

Example:

Your workplace might have a SharePoint site for each current project, and perhaps each project site includes a list describing the tasks that should be handled in the project, as well as which person is responsible for the task, and the current status of the task.

The URL might be:
http://MySharePointServer/ProjectSite/ListOfProjectTasks/default.aspx

To load this list into Spotfire, you would need to modify the URL to appear as follows:
http://MySharePointServer/ProjectSite/ListOfProjectTasks/_vti_bin/ListData.svc

When the URL has been modified in this manner, paste it into the Service URL field of the OData Connection dialog.