Skip to content
Scalekit Docs
Talk to an Engineer Dashboard

Connect AI agents to SharePoint

Scalekit connector
Open markdown

The SharePoint connector lets your AI agent act in each user's SharePoint account. Each user signs in to SharePoint once, and Scalekit stores and refreshes their tokens, so your agent never handles credentials. It comes with 52 tools.

Tools
52
What they doRead · write · destructive
23 · 22 · 723 read22 write7 destructive
Users sign in with
OAuth app
Scalekit's or your own

Setup

  1. Install the SDK

    Terminal window
    npm install @scalekit-sdk/node dotenv
  2. Set your credentials

    Add your Scalekit credentials to your .env file. Find values in app.scalekit.com > Developers > API Credentials.

    .env
    SCALEKIT_ENVIRONMENT_URL=<your-environment-url>
    SCALEKIT_CLIENT_ID=<your-client-id>
    SCALEKIT_CLIENT_SECRET=<your-client-secret>
  3. Create the SharePoint connection

    In AgentKit > Connections, create a SharePoint connection. The name you give it is the connection_name your code passes. See Configure connections.

    Scalekit credentials are available for SharePoint, so you don't need to register an OAuth app. To show your own app on the consent screen, use your own credentials instead.

    Use your own OAuth app

    Register your Scalekit environment with the SharePoint connector so Scalekit handles the authentication flow and token lifecycle for you. The connection name you create will be used to identify and invoke the connection programmatically. Then complete the configuration in your application as follows:

    1. Set up auth redirects

      • In Scalekit dashboard, go to AgentKit > Connections > Create Connection. Find SharePoint and click Create. Copy the redirect URI. It will look like https://<SCALEKIT_ENVIRONMENT_URL>/sso/v1/oauth/<CONNECTION_ID>/callback.

        Copy redirect URI from Scalekit dashboard

      • Sign into https://entra.microsoft.com and go to Microsoft Entra ID → App registrations → New registration.

      • Enter a name for your app.

      • Under Supported account types, select Accounts in any organizational directory (Any Azure AD directory - Multitenant).

      • Under Redirect URI, select Web and paste the redirect URI from step 1. Click Register.

        Register an application in Azure portal

    2. Get your client credentials

      • Go to Certificates & secrets → New client secret, set an expiry, and click Add. Copy the Value immediately.

      • From the Overview page, copy the Application (client) ID.

    3. Add credentials in Scalekit

      • In Scalekit dashboard, go to AgentKit > Connections and open the connection you created.

      • Enter your credentials:

        Add credentials in Scalekit dashboard

      • Click Save.

  4. Authorize a user and make your first call

    quickstart.mts
    import { ScalekitClient } from '@scalekit-sdk/node'
    import 'dotenv/config'
    import { createInterface } from 'node:readline/promises'
    const scalekit = new ScalekitClient(
    process.env.SCALEKIT_ENVIRONMENT_URL,
    process.env.SCALEKIT_CLIENT_ID,
    process.env.SCALEKIT_CLIENT_SECRET,
    )
    const actions = scalekit.actions
    const connector = 'sharepoint'
    const identifier = 'user_123'
    // Generate an authorization link for the user
    const { link } = await actions.getAuthorizationLink({ connectionName: connector, identifier })
    console.log('Authorize SharePoint:', link)
    const rl = createInterface({ input: process.stdin, output: process.stdout })
    await rl.question('Press Enter after authorizing...')
    rl.close()
    // Make your first call
    const result = await actions.executeTool({
    connector,
    identifier,
    toolName: 'sharepoint_list_followed_sites',
    toolInput: {},
    })
    console.log(result)
    Terminal window
    npx tsx quickstart.mts

    Each user signs in once. See Authorize a user for the full flow and statuses.

Tools

Pass the exact name to execute_tool
Try in PlaygroundRequest a tool
  • sharepoint_download_fileDownload the binary content of a file from a SharePoint document library by its item ID.Read-only

    Download SharePoint File

    Download the binary content of a file from a SharePoint document library by its item ID. The response is the raw file bytes (not JSON). For text files this will be readable text; for binary files (images, Office documents) it will be binary data. Use the item ID from list or get drive item operations.

    Inputs

    item_idstringrequired
    The unique drive item ID of the file to download from the SharePoint site's document library. Obtain item IDs from list drive items or search drive items operations.
    site_idstringrequired
    ID of the SharePoint site that contains the file. Use a site GUID, 'root', or the format '<hostname>:/sites/<path>'.
  • sharepoint_find_user_by_emailLook up an Azure Active Directory user by their email address (UPN).Read-only

    Find User by Email

    Look up an Azure Active Directory user by their email address (UPN). Returns the user's object ID, display name, and other profile properties. This is useful for resolving a user email to an object ID before adding them to a SharePoint site or group.

    Inputs

    emailstringrequired
    The email address (user principal name) of the Azure AD user to look up. Example: 'john.doe@contoso.com'.
  • sharepoint_get_content_typeRetrieve a single content type defined in a SharePoint site by its ID, including its name, description, group, and whether it is a built-in type.Read-only

    Get SharePoint Content Type

    Retrieve a single content type defined in a SharePoint site by its ID, including its name, description, group, and whether it is a built-in type.

    Inputs

    content_type_idstringrequired
    ID of the content type to retrieve.
    site_idstringrequired
    ID of the SharePoint site that contains the content type. Use a site GUID, 'root', or the format '<hostname>:/sites/<path>'.
    selectstring
    Comma-separated list of properties to return. Example: 'id,name,description,isBuiltIn'.
  • sharepoint_get_drive_itemGet metadata for a file or folder in a SharePoint document library — name, size, the file/folder facet, webUrl, timestamps, and more.Read-only

    Get SharePoint Drive Item

    Get metadata for a file or folder in a SharePoint document library — name, size, the file/folder facet, webUrl, timestamps, and more. Use this for a quick metadata lookup without downloading file content.

    Inputs

    item_idstringrequired
    The unique drive item ID of the file or folder to retrieve. Obtain item IDs from list drive item children or search drive items operations.
    site_idstringrequired
    ID of the SharePoint site that contains the item. Use a site GUID, 'root', or the format '<hostname>:/sites/<path>'.
    selectstring
    Comma-separated list of drive item properties to return. Example: "id,name,size,webUrl" reduces response payload.
  • sharepoint_get_listRetrieve a specific SharePoint list by its ID within a site.Read-only

    Get SharePoint List

    Retrieve a specific SharePoint list by its ID within a site. Optionally expand related resources such as columns and items to retrieve list metadata in a single call.

    Inputs

    list_idstringrequired
    ID or name of the SharePoint list to retrieve. Can be the list GUID or the list's display name (URL-encoded).
    site_idstringrequired
    ID of the SharePoint site containing the list. Use a site GUID, 'root', or the format '<hostname>:/sites/<path>'.
    expandstring
    Comma-separated list of related resources to expand. Example: 'columns,items' to include column definitions and list items in the response.
  • sharepoint_get_list_itemRetrieve a single item from a SharePoint list by its item ID.Read-only

    Get SharePoint List Item

    Retrieve a single item from a SharePoint list by its item ID. Use '$expand=fields' to include the column values in the response.

    Inputs

    item_idstringrequired
    ID of the list item to retrieve. This is the numeric or GUID identifier of the item within the list.
    list_idstringrequired
    ID of the SharePoint list that contains the item. Use the list GUID or display name.
    site_idstringrequired
    ID of the SharePoint site that contains the list. Use a site GUID, 'root', or the format '<hostname>:/sites/<path>'.
    expandstring
    Comma-separated list of related resources to expand. Default is 'fields' to include column values. Example: 'fields'.default fields
    selectstring
    Comma-separated list of properties to return. Example: 'id,createdDateTime,fields'.
  • sharepoint_get_search_suggestionsGet search query suggestions for SharePoint content using the Microsoft Search beta API.Read-only

    Get SharePoint Search Suggestions

    Get search query suggestions for SharePoint content using the Microsoft Search beta API. Returns autocomplete suggestions based on the provided search text to help users refine their queries.

    Inputs

    textstringrequired
    The partial search term for which to retrieve suggestions. Example: 'proj' returns suggestions like 'project plan', 'project budget'.
  • sharepoint_get_siteRetrieve properties of a SharePoint site by its ID.Read-only

    Get SharePoint Site

    Retrieve properties of a SharePoint site by its ID. Use 'root' for the tenant root site, a GUID for a specific site, or the format '<hostname>:/sites/<path>' (e.g., 'contoso.sharepoint.com:/sites/Marketing').

    Inputs

    site_idstringrequired
    ID of the SharePoint site to retrieve. Use 'root' for the tenant root site, a site GUID, or the format '<hostname>:/sites/<path>' (e.g., 'contoso.sharepoint.com:/sites/Marketing').

Workflows

Proxy API call
const result = await actions.request({
connectionName: 'sharepoint',
identifier: 'user_123',
path: '/v1.0/me/sites',
method: 'GET',
});
console.log(result);
Download a file

Fetch file metadata via the Scalekit proxy to get a pre-authenticated download URL, then stream the file directly from Microsoft’s CDN. This avoids buffering large files through the proxy and is significantly faster.

import os
import requests
site_id = "<YOUR_SITE_ID>" # call GET /v1.0/sites/root to get your site ID
filename = "report.pdf"
response = actions.request(
connection_name='sharepoint',
identifier='user_123',
path=f"/v1.0/sites/{site_id}/drive/root:/{filename}",
method="GET",
query_params={},
)
meta = response.json()
# Step 2: Stream directly from Microsoft CDN using the pre-authenticated URL
# No auth headers needed — the URL is cryptographically signed and expires in ~1 hour
download_url = meta["@microsoft.graph.downloadUrl"]
with requests.get(download_url, stream=True) as r:
r.raise_for_status()
with open(filename, "wb") as f:
for chunk in r.iter_content(chunk_size=8 * 1024 * 1024): # 8 MB chunks
f.write(chunk)
print(f"Downloaded: {filename} ({os.path.getsize(filename):,} bytes)")
Upload a file

Upload a file to SharePoint’s Shared Documents folder. Scalekit injects the OAuth token automatically — your app never handles credentials directly.

import mimetypes
site_id = "<YOUR_SITE_ID>" # call GET /v1.0/sites/root to get your site ID
filename = "report.pdf"
with open(filename, "rb") as f:
file_bytes = f.read()
mime_type = mimetypes.guess_type(filename)[0] or "application/octet-stream"
response = actions.request(
connection_name='sharepoint',
identifier='user_123',
path=f"/v1.0/sites/{site_id}/drive/root:/{filename}:/content",
method="PUT",
query_params={},
form_data=file_bytes,
headers={"Content-Type": mime_type},
)
meta = response.json()
print(f"Uploaded: {meta['name']} → {meta['webUrl']}")
Execute a tool
const result = await actions.executeTool({
connector: 'sharepoint',
identifier: 'user_123',
toolName: 'sharepoint_list_sites',
toolInput: {},
});
console.log(result);