> ## Documentation Index > Fetch the complete documentation index at: https://www.domo.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # Microsoft SharePoint Online Rest P&G Connector ## Intro This article explains how to connect to your Microsoft SharePoint Online Rest P\&G Domo account in the Data Center, configure credentials and report options, and retrieve organizational data using Domo's Microsoft SharePoint Online Rest P\&G Domo Connector. For more information about the Microsoft SharePoint Online Rest P\&G Domo connector, see the [Microsoft SharePoint developer documentation](https://learn.microsoft.com/en-us/sharepoint/dev/). *** ## Prerequisites To connect to your Microsoft SharePoint Online Rest P\&G Domo account and create a DataSet, you need the user ID and password associated with your Microsoft account. ## Configure the Connection This section describes the options in the **Credentials** and **Details** panes on the Microsoft SharePoint Online Rest P\&G Domo Connector page. The **Scheduling** and **Name & Describe Your DataSet** panes are universal across most connector types and are covered in [Add a DataSet Using a Data Connector](/docs/s/article/360042926274). ### Enter Your Credentials The **Credentials** pane contains fields for entering the user ID and password associated with your Microsoft SharePoint Online Rest P\&G Domo account. After you enter valid credentials, you can use the same account any time you create a new Microsoft SharePoint Online Rest P\&G Domo DataSet. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information, see [Manage User Accounts for Connectors](/docs/s/article/360042926054). ### Configure the Details Pane The **Details** pane contains the following fields and menus: | Field | Description | | ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | Report | Select the Microsoft SharePoint Online Rest P\&G Domo report you want to run. The following reports are available:
Report NameDescription
All SitesFetches a list of all sites, subsites, and group sites.
Download Item ContentsFetches the file content for the requested file.
FilesFetches a list of files.
File DownloadImports the selected file from SharePoint.
File PermissionsFetches a list of permissions for all files in the selected drive.
Get ItemsFetches the items present in the root drive of the selected site.
GroupsFetches a list of groups.
Group MembersFetches 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 SitesFetches a list of sites for the selected group.
ListFetches the details for the specified list.
List ColumnsGet the column schema (such as name, display name, type configuration, and other properties) for the selected list.
List Item Column ValuesFetches the details for the selected list item.
List Item DetailedFetches the details for the selected list item.
List ItemsFetches the list items for the selected list.
List Items (Fields Only)Retrieves specific list values, with options to select the fields and customize the display names.
List NotebooksFetches a list of notebook objects.
List Onenote SectionsFetches a list of onenoteSection objects from the specified notebook.
Root SitesFetches the list of sites present at the root.
SharePoint Activity User DetailFetches details about SharePoint activity by user.
SharePoint Activity File CountsFetches the number of unique licensed users who interacted with files stored on SharePoint sites.
SharePoint Activity User CountsFetches the trend in the number of active users.
SharePoint Site Usage DetailFetches details about SharePoint site usage.
SharePoint Site Usage File CountsFetches the total number of files across all sites and the number of active files.
SharePoint Site Usage Site CountsFetches the total number of files across all sites and the number of active files.
SharePoint Site Usage StorageFetches the trend of storage allocated and consumed during the reporting period.
Sites ListsFetches all the lists for the selected site.
Site SearchFetches the list of sites.
Sites SubsitesFetches a list of subsites for the selected site.
UsersRetrieves a list of user objects.
Users DriveRetrieves 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 from the drop-down. | | How would you like to select the data? | Select whether you want to select data from a site, subsite, group sites, filtered site names, or enter the site ID directly. | | Subsite Selection Criteria | Select whether you want to enter a subsite ID or select a subsite name. | | 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 whether 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. | | Groups Search Query | Enter the search query to obtain the sites.
Example:displayName:Test | | Select Groups | Select the groups that you want to use. | | Transitive Members | Select this option to pull all the members of the group including the transitive members. | | Use Path Based Approach | Select this option to use a path-based approach to access file permissions. If you do not select this option, the connector uses a file ID–based approach. | | File Selection Criteria | Select whether 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 (for example, `/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 (for example, `/MyFolder/MySubfolder`). | | Expand Fields | Select the fields to expand. | | Site Selection Criteria | Select whether you want to provide a site ID or filter 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 it from the **All Sites** or **Site Search** reports. | | Select File Search Property | Indicates how the connector should locate the file in SharePoint. Select **Name** if you anticipate that the internal SharePoint ID of the file will change—for example, if you delete and recreate the file with the same name regularly. Select **ID** if you do not anticipate the internal SharePoint ID changing. If you are unsure, select **Name**. | | File Type | Select the file type for the data file you want to retrieve. To show file content as a binary column, select **OTHER**. | | How would you like to choose your sheet? | Select whether you want to select your sheet by providing a partial or complete sheet name. | | Sheet Name | Enter the sheet name you want to retrieve from the specified spreadsheet. Ensure there are no accidental spaces in the sheet name. | | 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 attribute values as part of the data. | | Enter fields to exclude | Enter 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. | | 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, 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 | Enter a comma-separated list of fields you want to exclude from the JSON import. | | Date Format | Select the date format to use when converting date columns. For Excel files, the date format specified for the cell takes higher precedence. | | Use Provided File Encoding | Select this option to specify the file encoding. If you do not select this option, the connector automatically detects the file encoding. | | File Encoding | Select the file encoding. 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 characters in `\uxxxx` form (for example, `^`). | | 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 characters in `\uxxxx` form (for example, `^`). | | Escape Character | Select the desired escape character for parsing CSV files. | | Custom Escape Character | Enter the desired CSV escape character. Enter Unicode characters in `\uxxxx` form (for example, `^`). | | Decode Fields | Select this checkbox if you want to decode the fields coming from SharePoint. Applies to column names only. | | Field Selection | Select whether to import all fields or only specific fields. | | Enter fields to import | Enter a comma-separated list of field names to import, such as Title, EvaluationID, Department, and Quarters. To get the column names, see Microsoft Graph API - List columns . | | Get Display Names | Select whether to retrieve display names instead of internal names from SharePoint Online. This setting applies only to column names. | | Multi Value Field Format | Choose how to render multi-value fields that contain objects (such as Person/Group or Lookup columns). | | Display Comma Separated Array Value | Select this checkbox if you want to display comma-separated values for arrays in the response. | | Format dates as ISO (yyyy-MM-dd) | When selected, outputs date columns in ISO format. Supported formats include YYYY-MM-DD (date only), YYYY-MM (month and year), YYYY-MM-DD HH:MM or YYYY-MM-DD HH:MM:SS (date and time, including seconds only if present in the cell format), and HH:MM or HH:MM:SS (time only). When cleared, dates retain their original Excel cell format (for example, 15-Aug-2021). | ## Configure Other Options For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [Add a DataSet Using a Data Connector](/docs/s/article/360042926274).