Skip to main content

SharePoint Online List

This section explains how to connect to a SharePoint Online list. Before creating a Function, ensure you have already created the corresponding System within a System Line.

Connect to a SharePoint Online List​

In order to connect to a SharePointOnline List, create a new Function in the menu 'Virtual Datasets' and directly assign it to a Category.

Next, select the relevant Technical Handler 'SharePointOnline_List'.

All other configuration (e. g. a descriptive Short Name and Description) has to be made as usual.

For the Technical Parameters, please specify the following options. The options in BOLD are REQUIRED:

  • COLUMNS: List of columns to be returned by the query, separated by semicolons. Use '*' to return all columns.
  • LIST_NAME: The name of the list to query.
  • RELATIVE_SITE_URL: The relative site-url (e. g. /sites/myTeamSite or /sites/myDepartmentSite/myProjectSite/mySubSite).

Parameter​

  • COLUMN_PARAMETER: Define the column a user should be able to filter on.
    • Cardinality: all
    • Data Type: all, but Date or Time
    • Additional Properties:
      • COLUMN_NAME: Name of the column to be filtered on. If empty, the name of the parameter will be used.
warning

There are limitations to filtering SharePoint Online List columns of type multiple lines of text, Person or group and Lookup.

warning

The data types Date or Time are not supported in SharePoint Online Lists and therefore cannot be selected as Parameter type.