SharePoint Connector Documentation

If you have already set up a connector, skip to How to Use the SharePoint Connector.

Connect your SharePoint to Abacus.AI

To integrate SharePoint with Abacus.AI, you need to set up the connector and provide the necessary permissions.

Setting Up the SharePoint Connector

Flow 1: App Based Setup

  1. Before setting up the SharePoint Connector, you need to provide admin consent or register the Abacus.AI application.

Go to the Admin Consent URL and grant consent or register the application.

  1. Access Connected Services Dashboard:

  2. Add New Connector:

    • Click on the "Add New Connector" option, select "SharePoint" from the list, and choose "App Based" as the authentication type.

  3. Enable Realtime Synced Datasets (Optional):

    • Toggle the "Enable Realtime Synced Datasets" option to Yes if you want to sync datasets in real time.

  4. Enable Multi-Site Selection (Optional):

    • If you want to pull data from multiple SharePoint sites, toggle the "Pull from Multiple Sites" option to Yes.
    • Enter the SharePoint domain in the "SharePoint Domain" field. The domain must end with sharepoint.com.
    • Use the + button to add multiple site names or enter them as comma-separated values in the "Sites" field.

Example: - If your SharePoint domain is https://example.sharepoint.com, and you want to pull data from two sites, enter: site1, site2 SharePoint Multi-site

  1. Granting Permissions to the Client ID

    After setting up the connector, you will see the client ID. You need to provide permission for your site to this client ID:

    1. Go to https://subdomain.sharepoint.com/sites/name-of-your-site/_layouts/15/appinv.aspx.
    2. Paste the client ID in place of App Id then click on the lookup button to fetch the information for the client ID.
    3. In the App Domain field, type abacus.ai.
    4. In the Permission Request XML field, put the following XML code and click on create:

    xml <AppPermissionRequests AllowAppOnlyPolicy="true"> <AppPermissionRequest Scope="http://sharepoint/content/sitecollection" Right="Read"/> </AppPermissionRequests>

  2. A new page will load, click Trust It to grant the permission.

NOTE: If you are not able to lookup the client id or you get the following error message when you try to verify your SharePoint connector,

Invalid Connector Configuration: Failed to verify SharePoint connector due to bad SharePoint connection. SharePoint response:{"error":"invalid_request","error_description":"Token type is not allowed."}

You need to ask your administrator to configure settings in your SharePoint by running the following commands in a Windows OS/VM:

```powershell
    Install-Module -Name Microsoft.Online.SharePoint.PowerShell
    Import-Module Microsoft.Online.SharePoint.PowerShell
    Connect-SPOService -Url https://<orgName>-admin.sharepoint.com
    Set-SPOTenant -DisableCustomAppAuthentication $false
    Set-SPOTenant -SiteOwnerManageLegacyServicePrincipalEnabled $true
```

Please replace <orgName> with your actual organization name in the SharePoint admin URL.

  1. Verify Connector Status:
    • Your connector should be set up and confirm that it has an "ACTIVE" status.

Flow 2: Username and password Based Setup

  1. Before you begin, create a new SharePoint user and give it access only to the data that you want to pull from SharePoint.

This step ensures that the connector has the necessary permissions to access the specific folder you want to pull data from.

Note: You will need to create a password for the SharePoint user and not use the temporary password provided for the service account upon initial creation.

  1. Access Connected Services Dashboard:

  2. Add New Connector:

    • Click on the "Add New Connector" option, select "SharePoint" from the list, enter your site URL.

  3. Select "Username + Password" from the 'Authentication Type' dropdown. Provide the new user's Microsoft email and password, then click Create.

Sharepoint User Auth

  1. Verify Connector Status:

    • Your connector should be set up and confirm that it has an "ACTIVE" status.

  2. No Additional Permissions Required: With this flow, you do not need to grant additional permissions to the client ID.

Flow 3: OAuth Based Setup

  1. Before setting up the SharePoint Connector with OAuth, ensure that you have the necessary permissions to generate an OAuth token for accessing your SharePoint site.

  2. Access Connected Services Dashboard:

  3. Add New Connector:

    • Click on the "Add New Connector" option, select "SharePoint" from the list, enter your site URL.

  4. Select "OAuth" from the 'Authentication Type' dropdown.

  5. Click on Connect Sharepoint button to create and save the connector.

How to Use the SharePoint Connector

Once the SharePoint connector is set up, you can fetch data to train models in Abacus.AI.

  1. Create a new project and select the use case, then go to the "Datasets" tab and click "Create Dataset".

Create Dataset

  1. Click on "Create New".

Create New Dataset

  1. Name the dataset, select the data type 'List of documents', and click "Continue".

Name Dataset

  1. Choose "Read from External Service" and select your SharePoint connector under "Connected Application Connectors".

  2. Enter the Site URL for the SharePoint site you want to use, and specify the folder path if you have set up the connector to pull from a specific folder.

  3. After the dataset is uploaded, configure the schema mapping and proceed to train models with the data.

Train Model with Data

Troubleshooting and FAQ for the SharePoint connector

Can I use multiple SharePoint connectors in Abacus.AI?

Yes, you can set up multiple SharePoint connectors in Abacus.AI, each with different configurations and permissions.

What's the right feature mapping schema that will allow documents to use the URLs of the original file location on the source page in the external chat portal?

To get the URLs to the original location of a file on the source page in the chatweb, you should set the URL as "Document source" instead of the file_path which is set as a document source by default.

© Copyright