Connector for Microsoft SharePoint Online – Features and settings
You can connect to and access data from Microsoft SharePoint Online. On this page, you can find information about the capabilities, available settings, and things to keep in mind when you work with data connections to SharePoint Online.
Page content
Connector features
The following functionality is available when you access data with the connector for SharePoint Online.
| Feature | Supported? |
|---|---|
| Load methods |
|
| Custom queries | No |
| Stored procedures | No |
| Custom connection properties | No |
| Single sign-on with identity provider | No |
| Authoring in web client | No |
| Included in Spotfire distribution on Linux | Yes |
- For the prompt types Single selection and Multiple selection, you must type or paste the values in the prompts. You cannot load the list of available values in the prompt to select from.
- Custom relations are not supported.
Data source properties
The following are the supported data source properties that you can configure when you create a data connection with the connector for SharePoint Online.
Supported list types
Many types of apps that you can create on a site in SharePoint Online store data in lists. You can access most of those lists in Spotfire.
However, lists from some app types are not possible to access in Spotfire. Those lists do not appear as database tables when you select data in the Views in Connection dialog.
The table below lists the types of lists that have been tested and the findings regarding if you can access those lists in Spotfire. List types that are not included in the table might still be possible to access in Spotfire.
| App/List type | Accessible in Spotfire |
|---|---|
| List | Yes. |
| Calendar | Yes |
| Announcements | Yes |
| Contacts | Yes |
| Links | Yes |
| Promoted links | Yes |
| Tasks | Yes |
| Custom | Yes |
| Custom list in datasheet | Yes |
| Issue tracking | Yes |
| Surveys | No |
| Discussion board | No |
| Micro feed list | No |
Supported data source
To access data from SharePoint Online, Spotfire uses the Microsoft GRAPH API. When Spotfire gets SharePoint data from the GRAPH API, it maps the data types of columns returned by GRAPH to Spotfire data types in the final data table.
Because of the GRAPH API as Spotfire's interface to access SharePoint data, there is not a direct type mapping between column types in SharePoint to data types in Spotfire.
| Data type in GRAPH | Data type in Spotfire |
|---|---|
| boolean | Boolean/Bool |
| currency | Currency/Decimal |
| number | Real/Double |
| dateTime | Date or DateTime |
| personOrGroup | String |
| Text | String |
| lookup | Type mapping depends on the type of the target column. Note: Lookup columns are not supported as the parameter for limiting the data in on-demand data tables. |
| calculated | Type mapping depends on the type of calculated column. |
Column types
The following table lists information about different column types in SharePoint lists.
Not all column types are possible to access in Spotfire. Those columns do not appear when you select data in the Views in Connection dialog.
The table below lists the types of columns that have been tested and the findings regarding if you can access those columns in Spotfire.
| Column type | Accesible in Spotfire? |
|---|---|
| Single line of text | Yes |
| Multiple lines of text | Yes |
| Choice | Yes |
| Number | Yes |
| Currency | Yes |
| Date and time | Yes |
| Yes/No | Yes |
| Person or Group | Yes
Note: Person or Group columns with Allow multiple selections
enabled are not supported.
|
| Calculated | Yes |
| Lookup | Yes
Note: Lookup columns are not supported as the parameter for
limiting the data in on-demand data tables.
|
| Location | Partially
Information from location columns in SharePoint is split across multiple columns in Spotfire. The information is organized in columns such as Country/Region, State, City, Postal Code, Street, Name. Coordinates data is not included. |
| Hyperlink or Picture | No |
| Task Outcome | No |
| Managed metadata | No |
| Publishing columns | No |
| Summary Links Data | No |
Supported functions
Because only imported (in-memory) data is supported for SharePoint Online, you can use the functions available in the Spotfire in-memory data engine to work with your SharePoint Online data.