Microsoft SharePoint Online REST Connector

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 app. Go to settings > Keys and create the client secret.

Report

Select your desired Sharepoint Online report.

Group ID

Select the group you want to use.

User Id

Select the user that you want to use.

Period Value

Select the period for which you want to fetch the data.

How would you like to select the data?

Select whether you want to select the data from a site, subsite, group sites, filtered site names, or enter the site ID.

Subsite Selection Criteria

Select whether you want to provide a subsite ID or a subsite name to select a subsite.

Site ID

Select the site you want to pull data from.

Subsite ID

Select the subsite you want to pull data from.

Group Site Id

Select the site that you want to use.

Site Id

Enter the site Id. You can retrieve the site ID from the All Sites report.

Search Query

Enter the search query to obtain the sites.

Enter Site Id

Enter the site Id. You can fetch from the ‘All Sites’ or ‘Site Search’ report.

List ID

Select the list you want to pull data from.

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 ID of the list item you want to retrieve information for.

Select List Item name

Select the list item name that you want to parse and import.

Drive ID

Select the drive you want to pull data from.

Groups Search Query

Enter the search query to obtain the sites. For 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 the file permissions. If this option is not selected, the connector will use the file id based approach to access the file permissions.

File Selection Criteria

Select whether you would like to provide a file ID or a file name to select a file.

File ID

Enter the ID of the file you want to retrieve information for. You can generate a list of files by running the “Files” report.

File Relative Path

Enter the relative path of the folder from the selected drive (e.g. /MyFolder/MySubfolder). The default value is the root level.

Select File Search Property

This field Indicates how the connector should locate the file in SharePoint. Use Name if you anticipate that the internal Sharepoint id of the file will change. For example, if you delete the file and recreate with the same name regularly. Use ID if you don’t anticipate the internal SharePoint ID of the file will change. If you are not sure if the internal id will change or not, then select Name .

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).

Select the fields to expand

Select whether you want to provide a site ID or filter the site names using a search query.

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 name of the sheet you want to retrieve from the specified Excel spreadsheet. Be sure to check sheet names for accidental spaces.

Add Phonetic Words (Checkbox)

Select this checkbox if you want to add phonetic words to the data.

Enter your data tag

Enter the tag where the data is found in your XML text.

Do you require attributes in data?

Select Yes if you require attributes values as part of your data.

Enter fields to exclude

Provide a comma-separated list of fields to exclude from your XML data.

Enter Xpath expression

Enter your XPath query using standard XPath syntax as defined by the World Wide Web Consortium. ( https://www.w3.org/TR/2017/REC-xpath-31-20170321/ )

Header Start Row

Enter the header row number. If you do not enter a number, the first row is considered the header row.

Data Start Row

Enter the starting data row number. If you do not enter a number, the first row after the header row is considered the starting row.

Footer

Does Your JSON Text Require a Line Reader?

Select Yes if your JSON text includes multiple lines to 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 text.

Enter fields to exclude

Provide a comma-separated list of fields to exclude from the JSON import.

Date Format

Select the date format that should be used when converting date columns. For Excel files, cell date format will have higher precedence.

Blank Header

In the Excel file, select the position of the blank header, specifically whether it appears at the beginning or the end.

Blank Header Count at Start

Enter the count of blank headers.

Blank Header Count at End

Enter the count of blank headers.

Use Provided File Encoding

If checked, select the accurate file encoding given below. If not checked, the connector will auto-detect file encoding.

File Encoding

Select file encoding. Defaults to UTF-8.

Delimiter

Select the desired delimiter for parsing your CSV file.

Custom Delimiter

Enter the desired custom delimiter character. Enter \t for tab or Unicode characters in \uxxxx form.

Quote Character

Select the desired quote character for parsing your CSV file.

Custom Quote Character

Enter the desired custom quote character. Enter \t for tab or Unicode characters in \uxxxx form.

Escape Character

Select the desired escape character for parsing your CSV file.

Custom Escape Character

Enter the desired custom escape character. Enter \t for tab or Unicode characters in \uxxxx form.

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.