Prerequisites
To connect to Microsoft SharePoint Online to retrieve the information, you must have the following:- An installed Microsoft Azure app.
-
The CLIENT ID and CLIENT SECRET. To generate an app and locate these credentials, see Microsoft’s documentation. You may need the following information to register for the app:
- Azure Portal: https://portal.azure.com/
- Sharepoint App to Register: SharePoint Online Rest API
- Domo Re-direct URL: https://oauth.domo.com/api/data/v1/oauth/providers/microsoft-sharepoint-online-rest-enterprise-oauth/exchange
Creating an Azure App for Enterprise OAuth
To create a Microsoft Azure app, do the following:- Log in to https://portal.azure.com.
-
Select Microsoft Entra ID > App registrations.

- Click New registration.
- Enter the application name and select the supported account type. Enter the Redirect URI for Web as https://oauth.domo.com/api/data/v1/oauth/providers/microsoft-sharepoint-online-rest-enterprise-oauth/exchange.
-
Change the default tenant selection from single tenant to multi tenant. This is a requirement for the connector.

- Click Register.
-
Now, click API Permissions.

-
Click +Add Permissions button.

- Select Microsoft Graph > Delegated Permissions.
- Select the permissions as required.
-
After adding the permissions, all configured permissions will be listed as below.

To Obtain the Sharepoint CLIENT ID:
- Go to https://portal.azure.com.
- Select Microsoft Entra ID > App registrations.
- Find and click on your web app.
- The “application” ID is your CLIENT ID.
To obtain the Sharepoint CLIENT SECRET:
- Go to https://portal.azure.com.
- Select Microsoft Entra ID > App registrations.
- Find and click on your web app.
- Open Certificates and secrets.
- Click +New Value.
- Provide the value description and the expiry period for your secret. Click Add.
-
Your new value will appear. Copy the Value field and paste it in your Domo connector Value field.
