Configure SharePoint Dataset Connector
    • 22 Apr 2024
    • PDF

    Configure SharePoint Dataset Connector

    • PDF

    Article Summary

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


    • SysAid Copilot license

    • SysAdmin or AI Admin permissions

    • Microsoft Entra ID Account with published SharePoint Sites

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

    This document lists the steps required to extract the credentials needed to create a SharePoint Dataset in the Data Pool, so that it can include published SharePoint Sites (and their nested files) for the AI Chatbot to refer to as a knowledge source.

    Create a SharePoint Dataset

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

    nce you’ve create a SharePoint Connector Dataset, this popup form will open:

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

    Step 1: Obtain “Tenant ID”

    1. Sign in to your Microsoft Entra (Azure Active Directory) Portal

    2. Go to Overview > copy the “Tenant ID” value and paste it into the Dataset Configuration form’s “Tenant ID” field.

    Step 2: Add the SysAid Copilot App

    1. Navigate to the “App registrations” tab

    2. Click “New registration”

    Step 3: Register the application

    1. Create a name for the application (how it will appear to users)

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

    3. Click “Register”

    Step 4: Obtain “Client ID”

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

    Step 5: Add a “Client Secret”

    1. Go to the “Certificates and secrets” tab

    2. Add a “Description”

    3. Select an expiration period

    Step 6: Copy the “Client Secret” value

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

    Step 7: Add API permissions

    1. Go to “API permissions” tab

    2. Click “Add a permission”

    3. Add the “Sites.Selected” API Permission

    API Permissions Recommendations

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

    • The “Sites.Selected” Permission is preferred over the “Site.Read.All” Permission — so that only selected SharePoint sites across the organization can be read

    Step 8: 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 ``

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

    5. Replace with your actual SharePoint domain and /sites/YourSiteName with your site path in the following format:

    Ensure you replace 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.