Skip to main content

​
Intro

Microsoft SharePoint Online enables an organization to create and manage custom team-focused and project-focused sites for collaboration. Use Domo’s Microsoft SharePoint Online Rest Connector to get data from an organization-wide intranet portal in different aspects based on their sites within Domo. You can connect to your Microsoft SharePoint Online Rest Enterprise OAuth account in the Data Center. This topic discusses the fields and menus that are specific to the Microsoft SharePoint Online Rest Enterprise OAuth connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.

​
Prerequisites

To connect to your Microsoft SharePoint Online Rest Enterprise OAuth account and create a DataSet, you must select the OAuth Configuration.

​
Connecting to Your Microsoft SharePoint Online Rest Enterprise OAuth Account

This section enumerates the options in the Credentials and Details panes on the Microsoft SharePoint Online Rest Enterprise OAuth Connector page. The components of the other panes on this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Connector.

​
Credentials Pane

Note: To use an OAuth Configuration, the owner of the configuration must share it with you. If you are unable to see the OAuth Configuration that you are expecting, then contact your Administrator. This pane contains fields for entering credentials to connect to your Microsoft SharePoint Online Rest Enterprise OAuth account. The following table describes what is needed for each field:

Field

Description

OAuth Configuration

OAuth Configurations have service credentials stored by your administrator that automatically log you in so that you only need your personal OAuth login. Your administrator may create and edit configurations in the Data Center, in the Accounts tab.

Note: For more information on adding, updating, or sharing an OAuth Configuration, refer to Adding a Microsoft Sharepoint Online Rest OAuth Config .

Once you have entered valid Microsoft SharePoint Online Rest Enterprise OAuth credentials, you can use the same account at any time to create a new Microsoft SharePoint Online Rest Enterprise OAuth DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector/Adapter Accounts.

​
Details Pane

Menu

Description

Report

Select the Microsoft SharePoint Online Rest Enterprise OAuth report you want to run. The following reports are available:

Report Name Description

All Sites

Fetches a list of all sites, subsites and group sites.

Download Item Contents

Fetches the file content for the requested file.
Files Fetches a list of files.
File Download Downloads and parses the requested file.

File Permissions

Fetches a list of permissions for all files in the selected drive.

Get Items

Fetches the items present in the root drive of the selected site.

Groups

Fetches a list of groups.

Group Members

Fetches a list of all members for all groups.

Group Members V2 (Group Filter Search)

Returns the list of all members based on the groups filtered.

Group Sites

Fetches a list of sites for the selected group.

List

Fetches the details for the specified list.

List Item Column Values

Fetches the details for the selected list-item.

List Item Detailed

Fetches the details for the selected list-item.

List Items

Fetches the list-items for the selected list.

List Notebooks

Retrieves a list of notebook objects.

List Onenote Sections

Retrieves a list of onenoteSection objects from the specified notebook.

Root Sites

Fetches a list of sites present at the root.

Sharepoint Activity User Detail

Fetches the details about SharePoint activity by user.

Sharepoint Activity File Counts

Fetches the number of unique, licensed users who interacted with files stored on the SharePoint sites.

Sharepoint Activity User Counts

Fetches the trend in the number of active users.

Sharepoint Site Usage Detail

Fetches the details about SharePoint site usage.

Sharepoint Site Usage File Counts

Get the total number of files across all sites and the number of active files.

Sharepoint Site Usage Site Counts

Fetches the total number of files across all sites and the number of active files.

Sharepoint Site Usage Storage

Fetches the trend of storage allocated and consumed during the reporting period.

Sites Lists

Fetches all the lists for the selected site.

Sites Search

Fetches the list of all sites which matches the search query.

Sites Subsites

Fetches a list of subsites for the selected site.

Users

Retrieves a list of user objects.

Users Drive

Retrieves the properties and relationships of a Drive resource.
Group Id Select the group that you want to use.
User Id Select the user that you want to use.
Period Value Select the period you are looking for.
How would you like to select the data? Select if you want to select the data from site, subsite, group sites, filtered site names, or if you want to enter the site id.
Subsite Selection Criteria From the drop-down list you have the option to provide a subsite ID or a subsite name to select a subsite.
Site Id Select the site that you want to use.
Subsite Id Select the subsite that you want to use.
Subsite Id Enter the subsite Id. You can fetch the subsite Id from the All Sites report.
Group Site Id Select the site that you want to use.
Site Id Enter the site Id. You can fetch the site Id from the All Sites report.
Search Query Enter the search query to obtain the sites.
Site Id “Select the site that you want to parse and import.
List Id Select the list that you want to use.
List Item Selection Criteria “Select if you want to provide a list item ID or a list item name to select an item.
List Item Id Enter the List Item Id.
Select List Item name Select the list item name that you want to parse and import.
Drive Id Select the drive that you want to use.
Use Path Based Approach Select this option to use path based approach to access file permissions. If this option is not selected, then the connector will use the file id based approach to access file permissions.
File Selection Criteria Select if you want to provide a file ID or a file name to select a file.
File Id Enter the File Id. Use the Files report to find File Ids.
File Relative Path Enter the relative path of the folder from the selected drive (e.g. /MyFolder/MySubfolder). The default value is root level.
Select file name Select the file name that you want to parse and import.
Relative Path Enter the relative path of the folder from the selected drive. (e.g. /MyFolder/MySubfolder).
Expand Fields Select the fields to expand.
Site Selection Criteria Select if you want to provide a site ID or filter the site names using a search query.
Search Query Enter the search query to obtain the sites.
Enter Site Id Enter the site Id. You can fetch this from the ‘All Sites’ or ‘Site Search’ reports.
Site Id Select the site that you want to parse and import.
Select File Search Property Indicates how the connector should locate the file in Sharepoint. Use Name if you anticipate the internal Sharepoint id of the file will change. E.g. you delete the file and recreate it with the same name on a regular basis. Use <strong>ID</strong> if you don’t anticipate the internal Sharepoint id of the file will change. If you aren’t sure if the internal id will change or not, select <strong>Name</strong>
File Type Select the file type for the data file you want to retrieve.<br> To show file content as binary column select ’ OTHER ’ from the options.
How would you like to choose your sheet?” Select if you want to select your sheet by providing partial or complete sheet name.
Sheet Name Enter the sheet name you want to retrieve from the specified spreadsheet. Ensure to check the sheet name for accidental spaces.
Add Phonetic Words Select this checkbox if you want to add phonetic words to the data.
Enter your data tag Enter the tag where your data resides in the XML text.
Do you require attributes in data? Select ‘Yes’ if you require attributes values as a part of data.
Enter fields to exclude Provides a comma separated list of fields you want to exclude from the XML import.
Enter XPath expression Enter your XPath query using standard XPath syntax as defined by the World Wide Web Consortium ( http://www.w3.org/TR/2014/REC-xpath-30-20140408/ ).
Header Start Row Enter the number for the header row in the data set.
Data Start Row Enter the number for the first data row in the data set.
Footer Enter the number of rows at the end of the data set to skip. For example, to skip the last two rows you need to enter 2.
Does your JSON text require a line reader? Select ‘Yes’ if your JSON text includes multiple lines that should be read.
Enter your header tag Enter the tag for the header in your JSON text.
Enter your data tag Enter the tag for the data in your JSON.
Enter fields to exclude Provides a comma separated list of fields you want to exclude from the JSON import.
Date Format Select the date format that should be used when converting date columns.(For Excel files, date format specified for the cell which has the higher precedence)
Use Provided File Encoding If you select the checkbox, then the accurate file encoding is selected. If this checkbox is not selected, then the connector will auto-detect file encoding.
File Encoding Select the file encoding. This option defaults to UTF-8 .
Delimiter Select the desired delimiter for parsing CSV files.
Custom Delimiter Enter the desired CSV delimiter character. Enter \t for tab or Unicode chars in \uxxxx form (e.g. ^).
Quote Character Select the desired quote character for parsing CSV files. (A double quote is the CSV standard.)
Custom Quote Character Enter the desired CSV quote character. Enter Unicode chars in \uxxxx form (e.g. ^).
Escape Character Select the desired escape character for parsing CSV files.
Custom Escape Character Enter the desired CSV escape character. Enter Unicode chars in \uxxxx form (e.g. ^)
Decode Fields Select this checkbox if you want to decode the fields coming from the SharePoint (Applies to column names only).
Display Comma Separated Array Values Select this checkbox if you want to display the comma separated values for arrays in the response.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Connector.