Configure SharePoint Dataset Connector
    • 09 Apr 2025
    • PDF

    Configure SharePoint Dataset Connector

    • PDF

    Article summary

    Obtain the SharePoint credentials you need to add a SharePoint Dataset to your Data Pool

    Requirements:

    • SysAid Copilot license

    • SysAdmin or AI Admin permissions

    • Microsoft Entra ID Account with published SharePoint Sites

    Configuring SharePoint Datasets inside the AI Chatbot’s Data Pool requires them need to be synced with the organization’s Microsoft Entra (Azure Active Directory) account.

    Once the Data Pool processes the SharePoint Sites (including its pages and nested files) — the AI Chatbot can refer to the SharePoint Dataset as a knowledge source.

    The Data Pool’s SharePoint Datasets support these formats:

    • .doc

    • .pdf

    • .xslx

    • SharePoint page

    • .pptx

    This document lists the steps to extract the credentials needed to create a SharePoint Dataset in the Data Pool.

    Create a SharePoint Dataset

    Read this article to learn how to create a SharePoint Dataset for your Data Pool

    Step #1: Create Dataset

    Once you’ve created a SharePoint Connector Dataset, this popup form will open:

    The (five) values for “Title”, “Tenant Name”, “Client ID”, “Client Key” and “Site URL” Fields need to be taken from the Admin’s Microsoft Entra (Azure Active Directory) account.

    Step #2: Obtain “Tenant Name”

    1. In the Azure portal, under Azure services, choose Microsoft Entra ID.

    2. In the Overview section, go to Manage > Custom domain names.

    3. Copy the name with an “Available” status and paste it into the Dataset Configuration form’s Tenant ID field.

    Step #3: Add the SysAid Copilot App

    1. Navigate to the App registrations tab.

    2. Click New registration.

    3. In the Name field, enter a name for the application, for example, "SysAid Copilot". This is the name the users will see.

    4. Select an account-type for who can use the application

    5. Click Register.

    6. Copy the Application (client) ID value and paste it into the Dataset Configuration form’s “Client ID” field.

    Step #4: Add a “Client Secret”

    1. Go to the Certificates & secrets tab.

    2. Add a “Description”

    3. Select an expiration period.

    4. Copy the Client Secret for the relevant application in the list and paste it into the Dataset Configuration form’s Client Secret field.

    Step #5: Add API permissions

    1. Go to the API permissions tab.

    2. Click Add a permission.

    3. Add the following permissions:

      • Microsoft Graph

        • Sites.Read.All

        • User.Read

      • SharePoint

        • Sites.Read.All

    API Permissions Recommendations:

    • Specifically grant Read access to the app registration for the site you're targeting

    • Use the 'Sites.Selected' permission instead of 'Sites.Read.All' if you want to restrict access to only specific SharePoint sites within the organization

    Step #6: Add the SharePoint site URL

    To get the correct URL for accessing a SharePoint site using the Graph API, follow these steps:

    1. Log into your SharePoint account

    2. Navigate to the SharePoint site you want to access with the Graph API

    3. Look at the URL in your browser's address bar
      It should look something like `https://yourcompany.sharepoint.com/sites/YourSiteName`

    4. Note down your SharePoint domain (yourcompany.sharepoint.com) and the site path (/sites/YourSiteName)

    5. Replace yourcompany.sharepoint.com with your actual SharePoint domain and /sites/YourSiteName with your site path in the following format:
      `https://graph.microsoft.com/v1.0/sites/yourcompany.sharepoint.com:/sites/YourSiteName`.

    Ensure you replace yourcompany.sharepoint.com and /sites/YourSiteName with the correct information from your SharePoint URL.

    1. Paste the URL address into the Dataset Configuration form’s “Site URL” field

    Your SharePoint site will now appear in your AI Chatbot’s Data Pool, so that the AI Chatbot can derive data from your SharePoint site and its files when formulating responses in AI Chatbot chats.