OData example: Loading list data from SharePoint

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

About this task

Important: For the best experience accessing list data from Microsoft SharePoint Online, use the Microsoft SharePoint Online connector.

Procedure

On the Authoring bar, click Files and data .
In the Files and data flyout, click Connect to.
In the list of connectors, selct OData, and in the OData flyout, click New connection.
In the OData Connection dialog, in the Service URL field, paste the URL corresponding to the data you want to access.

Tip: 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 below.
In the Authentication method drop-down list, select Windows authentication.
Make sure the correct username is shown in the Username field.
Enter your Windows password.
Click Connect.
In the Views in Connection dialog, select the data you want to load. Then click OK twice to load the data into Spotfire

Tip: For more information about loading data in Spotfire, see Accessing data.

Modifying the SharePoint URL

About this task

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

You 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