The SharePoint Refresh tool automatically updates the imported data by executing the query used to import the original SharePoint list and replaces the existing data, either by removing, updating, or creating new rows. By default the SharePoint tool is set to “Off”.  Only changes to a list is loaded, so modifying an already loaded list is as performant as possible.

To enable SharePoint Refresh

  1. Select Tools > SharePoint > SharePoint Refresh On

  2. A dialog will appear to enter the refresh frequency (in seconds). Enter an integer in seconds.

  3. Click OK.

Note: This will begin refreshing ALL SharePoint lists brought into the Spotfire analysis.  The updating tool checks the data table property ‘UpdateSharepoint’ to determine if the data table should be updated.

To disable SharePoint Refresh

  1. Select Tools > SharePoint > SharePoint Refresh Off

Note: This will stop refreshing ALL SharePoint lists brought into the Spotfire analysis.

To ignore a SharePoint Refresh

By default, any data table loaded through the SharePoint data source will be automatically refreshed when the SharePoint Refresh tool is turned on.  To ignore a particular data table:

  1. Open Data Table Properties window > go to Properties

  2. Set the ‘UpdateSharepoint’ to ‘false’

Using SharePoint Refresh properties

The below image is the dialog box from the Data Table Properties:



Property

Description

UpdateSharePoint

This property should be set to a Boolean value to indicate whether this data table will be refreshed by the SharePoint Refresh function.

SharepointSite

This property indicates the URL that the SharePoint Refresh will pull from. It does not impact reloading the data table manually. To change the source of a table sourced by SharePoint, you will need to create another data table.

SharepointList

This property indicates the list that the SharePoint Refresh will pull from. It does not impact reloading the data table manually. To change the source of a table sourced by SharePoint, you will need to create another data table.

SharepointUpdated

This is a timestamp of the last time SharePoint Refresh updated this table. Changing the value of this property will not affect anything.