Skip to main content

​
Intro

Microsoft SharePoint Online enables an organization to easily create and manage custom team-focused and project-focused sites for collaboration. Use Domo’s Microsoft SharePoint Online Rest Connector to fetch data from an organization-wide intranet portal in various aspects based on their sites within Domo. To learn more about the Microsoft SharePoint Online Rest Connector API, see (https://learn.microsoft.com/en-us/sharepoint/dev/ ). You can connect to your Microsoft SharePoint Online Rest Connector account in the Data Center. This topic discusses the fields and menus that are specific to the Microsoft SharePoint Online Rest Connector connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Data Connector.

​
Prerequisites

To connect to your Microsoft SharePoint Online Rest Connector account and create a DataSet, you must have the following:
  • Client ID
  • Client Secret
  • Tenant

​
Connecting to Your Microsoft SharePoint Online Rest Connector Account

This section enumerates the options in the Credentials and Details panes in the Microsoft SharePoint Online Rest Connector Connector page. The components of the other panes in 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 Data Connector.

​
Credentials Pane

This pane contains fields for entering credentials to connect to your Microsoft SharePoint Online Rest Connector account. The following table describes what is needed for each field:

Field

Description

Client ID

Navigate to portal.azure.com > Azure Active directory > App registrations . Find and select the web app. The Application ID from the web app is the client id.

Client Secret

Navigate to portal.azure.com > Azure Active directory > App registrations . Find and select the web. Go to settings > Keys . Create the client secret.

Tenant

Enter your tenant domain name.

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

​
Details Pane

This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.

Menu

Description

Report

Select the Microsoft SharePoint Online Rest Connector 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.
Get Items Fetches the items present in the root drive of the selected site.
Groups Fetches a list of groups.
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 Retrieve a list of notebook objects.
List Onenote Sections Retrieve a list of onenote Section objects from the specified notebook.
Root Sites Fetches a list of sites present at the root.
Sharepoint Activity User Detail Fetches details about SharePoint activity by user.
Sharepoint Activity File Counts Fetches the number of unique, licensed users who interacted with files stored on SharePoint sites.
Sharepoint Activity User Counts Fetches the trend in the number of active users.
Sharepoint Site Usage Detail Fetches details about SharePoint site usage.
Sharepoint Site Usage File Counts Fetches 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 Subsites Fetches a list of subsites for the selected site.
Users Retrieve a list of user objects.
Users Drive Retrieve the properties and relationships of a Drive resource.
How Would You Like To Select The Data? From the drop-down list, you can either select Site , Subsite , Group Sites , Filter Site Name , or you can select Enter Site Id and enter the site Id.
Site ID Enter or select the site you want to use.
Subsite Selection Criteria Select if you want to provide a subsite ID or a subsite name to select a subsite.
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.
Search Query Enter the search query to obtain the sites.
File Type Select the file type for the data file you want to retrieve. To show the file content as binary column select OTHER from the drop-down list.
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 must enter 2 .
Date Format Select the date format to be used when converting date columns.(For Excel files, date format specified for the cell will have higher precedence).
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. ^). This field appears when you select Other from the Delimiter field.
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. ^). This field appears when you select Other from the Quote Character field.
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. ^). This field appears when you select Other from the Escape Character field.
Does Your JSON Text Require A Line Reader? Select Yes if your JSON text includes multiple lines to 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 or from the XML import, based on the file type selected.
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 (check box) Select this checkbox if you want to add phonetic words to the data.
Do You Require Attributes in Data? Select ‘Yes’ if you require attribute values as part of data.
Enter XPath Expression? Enter the XPath Expression.
Site Selection Criteria Select if you want to provide a site ID or filter the site names using a search query.
Enter Site ID Enter the site Id. You can fetch this from the All Sites or Site Search reports.
Drive ID Select the drive you want to use.
Group ID Select the group you want to use.
Expand Fields Select the fields you want to expand.
Decode Fields Select this checkbox if you want to decode the fields coming from 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.
User ID Select the user you want to use.
Period Value Select the period you are searching for.

​
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 Data Connector.