Loading List Data from SharePoint

You can use the TIBCO Spotfire Connector for OData 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.

  1. Select File > Add Data Tables....

  2. Click Add.

  3. Select Connection To > OData.

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

    Response: The OData Connection dialog is opened.

  4. In the Service URL field, paste the URL corresponding to the data you want to load from SharePoint into Spotfire.

    5. 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.

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

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

  7. Type your Windows password.

  8. Click Connect.

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

    10. Comment: For general information about loading data into Spotfire, see TIBCO Spotfire User's Guide (under Help > Help Topics).

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.

See also:

Details on OData Connection