Microsoft SharePoint Online Plugin Capabilities
This article provides more details about the key capabilities of Microsoft SharePoint Online Plugin.
Get Objects
Microsoft SharePoint Online Plugin supports pulling the following object types:
- Sites
- Lists
- Items
Get Data
By getting data in Metric Insights we mean the ability to create Datasets. Microsoft SharePoint Online Plugin supports creating Datasets from Items:
- CSV
- Excel
- Excel Sheet
The additional #Sharepoint Metadata & Content Access folder on the list of collected Documents includes documents' metadata and allows for the creation of the so-called Metadata Datasets:
- User Access List
- Group Access List
- Custom Columns Map
- Custom Columns
- Version history
- SharePoint Group Membership (requires Certificate Auth)
Get Filters
Microsoft SharePoint Online Plugin does not support pulling Filters from objects to Metric Insights.
Get Image
Microsoft SharePoint Online Plugin supports getting images by means of creating Other External Content and displaying them in Viewers.
Depending on a value set for MAX_FILE_SIZE_FOR_PREVIEW_AND_VIEWER and EDITOR_MAX_FILE_TO_IMAGE_TIME_SEC System Variables, users may not see the selected file in Viewer. The capability matrix below assumes that there are no restrictions on max file sizes.
| File Type | Display in Viewer "External web page" | Display in Viewer "Uploaded image" | Display in Viewer "As PDF document"* |
|---|---|---|---|
| Excel | Displayed as a spreadsheet with limited interactivity, allowing for moving between sheets, selecting/editing fields, and expanding columns, but without saving changes | Displayed as a static image of the first sheet's top contents, which downloads the file when clicked | Displayed as a PDF with the standard browser PDF viewer functionality |
| Displayed as PDF with the standard browser PDF viewer functionality | Displayed as a static image of the first page, which opens the file in a browser PDF viewer as a new tab when clicked | – | |
| PowerPoint | Displayed as PDF with the standard browser PDF viewer functionality | Displayed as a static image of the first presentation slide, which opens a PDF version of the presentation in a browser PDF viewer as a new tab when clicked | – |
| Word | Displayed as PDF with the standard browser PDF viewer functionality | Displayed as a static image of the first page, which opens a PDF version of the file in a browser PDF viewer as a new tab when clicked | – |
| CSV | Not available in Viewer | Depending on the file size, can be displayed as a static image of top contents, which downloads the file when clicked | – |
| Image | Not available in Viewer | Displayed as a static image, which downloads the file when clicked | – |
*This option is displayed only when an Excel file is selected for Document.
Support OAuth 2.0
Microsoft SharePoint Online Plugin supports OAuth 2.0.
Support Content Autosync
Microsoft SharePoint Online Plugin does not support content auto sync.
Capture Metadata
Metric Insights captures Technical Owners for Other External Content based on who made the latest changes to the file on the Microsoft SharePoint side.