SharePoint Connector

SharePoint Connector

Sync documents from SharePoint sites and document libraries into LH42.

Features

• Sites - Sync entire SharePoint sites
• Document libraries - Specific library sync
• Office documents - Word, Excel, PowerPoint extraction
• PDFs - Full text extraction
• Metadata - SharePoint columns as searchable fields
• Incremental sync - Only changed files re-indexed

Prerequisites

1. Microsoft 365 subscription with SharePoint
2. Azure AD app registration (or use managed app)
3. SharePoint site access

Setup

Step 1: Connect via OAuth

1. Go to Settings > Integrations
2. Find SharePoint and click Connect
3. Sign in with your Microsoft account
4. Grant the requested permissions:

- Sites.Read.All - Read SharePoint sites

- Files.Read.All - Read files in sites

> Note: Admin consent may be required for organization-wide access.

Step 2: Select Sites

After connecting, choose which sites to sync:

client.connectors.configure("sharepoint", {
    "settings": {
        "site_id": "specific-site-id",           # Optional: limit to site
        "site_url": "https://company.sharepoint.com/sites/TeamSite",
        "extract_content": True,                  # Extract Office doc text
        "max_file_size_mb": 50                    # Skip files over 50MB
    }
})

Options:

• Omit site_id to sync all accessible sites
• Set extract_content: false for metadata-only indexing

Step 3: Start Initial Sync

client.connectors.sync("sharepoint", mode="full")

Supported File Types

API Reference

List Sites

GET /api/connectors/{connector_id}/sites

# Response
{
  "sites": [
    {
      "id": "site-guid",
      "name": "Team Site",
      "url": "https://company.sharepoint.com/sites/Team",
      "document_count": 500,
      "synced": true
    }
  ]
}

List Libraries

GET /api/connectors/{connector_id}/libraries?site_id=site-guid

Sync Specific Site

POST /api/connectors/{connector_id}/sync
{
  "mode": "incremental",
  "filters": {
    "site_ids": ["site-guid"]
  }
}

Azure AD App Registration

For self-managed authentication:

1. Go to Azure Portal → App Registrations
2. Create new registration
3. Add API permissions:

- Microsoft Graph: Sites.Read.All

- Microsoft Graph: Files.Read.All

1. Create client secret
2. Grant admin consent
3. Configure in LH42:

client.connectors.create("sharepoint", {
    "auth_type": "client_credentials",
    "credentials": {
        "tenant_id": "your-tenant-id",
        "client_id": "your-client-id",
        "client_secret": "your-client-secret"
    }
})

Permissions

SharePoint permissions are respected:

• Users only see documents they can access in SharePoint
• Permission changes sync within 1 hour
• Site-level and item-level permissions supported

Sync Frequency

Troubleshooting

"Site not accessible" errors

• Verify you have access to the SharePoint site
• Check Azure AD app has required permissions

Missing documents

• Verify file type is supported
• Check file isn't over size limit

Slow sync

• Large libraries may take longer
• Use site/library filters to limit scope

Next Steps

• Dropbox Connector - Connect Dropbox
• Integrations Overview - Architecture overview