Skip to main content

Prerequisites

To connect to Microsoft SharePoint Online to retrieve the information, you must have the following:

Creating an Azure App for Enterprise OAuth

To create a Microsoft Azure app, do the following:
  1. Log in to https://portal.azure.com.
  2. Select Microsoft Entra ID > App registrations.
    Capture1.PNG
  3. Click New registration.
  4. 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.
  5. Change the default tenant selection from single tenant to multi tenant. This is a requirement for the connector.
    REgister.png
  6. Click Register.
  7. Now, click API Permissions.
    API_permission.png
  8. Click +Add Permissions button.
    Capture8.PNG
  9. Select Microsoft Graph > Delegated Permissions.
  10. Select the permissions as required.
  11. After adding the permissions, all configured permissions will be listed as below.
    Configure.png

To Obtain the Sharepoint CLIENT ID:

  1. Go to https://portal.azure.com.
  2. Select Microsoft Entra ID > App registrations.
  3. Find and click on your web app.
  4. The “application” ID is your CLIENT ID.

To obtain the Sharepoint CLIENT SECRET:

  1. Go to https://portal.azure.com.
  2. Select Microsoft Entra ID > App registrations.
  3. Find and click on your web app.
  4. Open Certificates and secrets.
  5. Click +New Value.
  6. Provide the value description and the expiry period for your secret. Click Add.
  7. Your new value will appear. Copy the Value field and paste it in your Domo connector Value field.
    Secret.png