OneDrive connector

Connect OneDrive to automatically sync Word documents, Excel spreadsheets, and PowerPoint presentations into your Supermemory knowledge base. Supports both personal and business accounts with real-time updates via webhooks.

Sync scope

Default for new connectors: after OAuth, the user picks folders in Supermemory’s hosted folder picker. Only files in the selected folders are synced, and nothing syncs until at least one folder is saved. Whole OneDrive: set config.syncScope to "full" when creating the connector so the entire drive syncs without the picker. Explicit scoped mode: set config.syncScope to "selected" for the picker flow, or rely on the default for new connects.

Connectors created before folder selection was available keep syncing the whole drive. They can narrow to folders by opening the picker and saving a selection.

Quick setup

1. Create OneDrive Connector

import { Supermemory } from "supermemory"

const supermemory = new Supermemory({ apiKey: process.env.SUPERMEMORY_API_KEY })

const connector = await supermemory.connectors.create("user-123", {
  provider: "onedrive",
  redirectUrl: "https://yourapp.com/auth/onedrive/callback",
  documentLimit: 1500,
  config: { syncScope: "selected" },
})

// Send the user to Microsoft to authorize
if (connector.authorization) window.location.href = connector.authorization.url
// Output: Redirects to https://api.supermemory.ai/v3/connections/auth/redirect?state=...

from supermemory import Supermemory
import os

client = Supermemory(api_key=os.environ.get("SUPERMEMORY_API_KEY"))

connector = client.connectors.create(
    "user-123",
    request={
        "provider": "onedrive",
        "redirect_url": "https://yourapp.com/auth/onedrive/callback",
        "document_limit": 1500,
        "config": {"sync_scope": "selected"},
    },
)

# Send the user to Microsoft to authorize
if connector.authorization:
    print(f"Redirect to: {connector.authorization.url}")
# Output: Redirect to: https://api.supermemory.ai/v3/connections/auth/redirect?state=...

curl -X POST "https://api.supermemory.ai/ns/user-123/connectors" \
  -H "Authorization: Bearer $SUPERMEMORY_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "provider": "onedrive",
    "redirectUrl": "https://yourapp.com/auth/onedrive/callback",
    "documentLimit": 1500,
    "config": { "syncScope": "selected" }
  }'

# Response: {
#   "id": "PTzGiUYei7pgzg5buzZHgA",
#   "authorization": {
#     "url": "https://api.supermemory.ai/v3/connections/auth/redirect?state=...",
#     "expiresAt": "2024-01-15T11:30:00.000Z"
#   }
# }

2. Handle Microsoft OAuth

Send the user to authorization.url before authorization.expiresAt. With scoped sync (syncScope omitted or "selected"), Supermemory then sends the user to its hosted folder picker; once they save a selection, they return to your redirectUrl and the initial sync begins. With syncScope: "full", Microsoft redirects through Supermemory to your redirectUrl and the initial sync begins right away. A pending OAuth connector is not returned by list until the user finishes authorization; get returns it with system.status: "pending_authorization".

3. Monitor sync status

  // Check connector details with recent sync runs
  const connector = await supermemory.connectors.get("user-123", "PTzGiUYei7pgzg5buzZHgA", {
    include: "syncs",
  })

  console.log("Account:", connector.account)
  console.log("Last sync:", connector.latestRun?.system.status)
  console.log("Documents synced:", connector.documentCount)

  // List synced Office documents in the namespace
  const { documents } = await supermemory.list("user-123", "documents")

  # Check connector details with recent sync runs
  connector = client.connectors.get("user-123", "PTzGiUYei7pgzg5buzZHgA", include=["syncs"])

  print(f"Account: {connector.account}")
  print(f"Last sync: {connector.latest_run.system.status if connector.latest_run else 'never'}")
  print(f"Documents synced: {connector.document_count}")

  # List synced Office documents in the namespace
  documents = client.list("user-123", "documents").documents

  # Get connector details with recent sync runs
  curl "https://api.supermemory.ai/ns/user-123/connectors/PTzGiUYei7pgzg5buzZHgA?include=syncs" \
    -H "Authorization: Bearer $SUPERMEMORY_API_KEY"

  # List synced Office documents in the namespace
  curl -X POST "https://api.supermemory.ai/ns/user-123/list/documents" \
    -H "Authorization: Bearer $SUPERMEMORY_API_KEY" \
    -H "Content-Type: application/json" \
    -d '{}'

There is no per-connector document list in v5. supermemory.list(namespace, "documents") returns every document in the namespace.

To change the folders later, read the connector with include: "picker" and send the user to picker.url, or set folder ids directly with connectors.update(namespace, id, { selection: { folders: ["<folder-id>"] } }). A new selection replaces the old one and starts a sync. See Managing Connector Selection.

Supported document types

Word, Excel, and PowerPoint files are converted to PDF by Microsoft Graph before extraction. Markdown, PDF, JSON, and plain-text files are downloaded as-is and go through the same extraction pipeline as uploads.

Microsoft Word documents

Rich text formatting converted to markdown
Headers and styles preserved as markdown hierarchy
Images and charts extracted and referenced
Tables converted to markdown tables

Excel spreadsheets

Worksheet data converted to structured markdown
Multiple sheets processed separately
Charts and graphs extracted as images
Formulas converted to calculated values
Cell formatting simplified in markdown

PowerPoint presentations

Slide content converted to structured markdown
Speaker notes included when present
Images and media extracted and referenced
Embedded objects processed when possible

Sync mechanism

Webhooks lead to real-time syncing of changes in documents. You may also manually trigger a sync.

Manual sync trigger

The call returns 409 while a sync for that connector is already running.

  const run = await supermemory.connectors.sync("user-123", "PTzGiUYei7pgzg5buzZHgA")

  console.log(run.status)
  // Output: queued

  run = client.connectors.sync("user-123", "PTzGiUYei7pgzg5buzZHgA")

  print(run.status)
  # Output: queued

  curl -X POST "https://api.supermemory.ai/ns/user-123/connectors/PTzGiUYei7pgzg5buzZHgA/sync" \
    -H "Authorization: Bearer $SUPERMEMORY_API_KEY"

  # Response: {"id": "PTzGiUYei7pgzg5buzZHgA", "status": "queued"}

Delete Connector

Remove a OneDrive connector when no longer needed:

// Delete the connector and its imported documents (default)
await supermemory.connectors.delete("user-123", "PTzGiUYei7pgzg5buzZHgA")

// Delete the connector but keep the imported documents
await supermemory.connectors.delete("user-123", "PTzGiUYei7pgzg5buzZHgA", {
  deleteDocuments: false,
})

# Delete the connector and its imported documents (default)
client.connectors.delete("user-123", "PTzGiUYei7pgzg5buzZHgA")

# Delete the connector but keep the imported documents
client.connectors.delete("user-123", "PTzGiUYei7pgzg5buzZHgA", delete_documents=False)

# Delete the connector and its imported documents (default)
curl -X DELETE "https://api.supermemory.ai/ns/user-123/connectors/PTzGiUYei7pgzg5buzZHgA" \
  -H "Authorization: Bearer $SUPERMEMORY_API_KEY"

# Delete the connector but keep the imported documents
curl -X DELETE "https://api.supermemory.ai/ns/user-123/connectors/PTzGiUYei7pgzg5buzZHgA?deleteDocuments=false" \
  -H "Authorization: Bearer $SUPERMEMORY_API_KEY"

Deleting a connector will:

Stop all future syncs from OneDrive
Remove the OAuth authorization
Delete the synced documents unless you pass deleteDocuments: false

Advanced configuration

Custom Microsoft app

For production deployments you can connect with your own Microsoft application. Custom OAuth credentials are an organization setting and are not part of the v5 connector routes. See Custom OAuth Applications for the setup steps and callback URL.

Optimization tips

Set realistic document limits based on storage and usage
Monitor sync health regularly with latestRun and include: "syncs"
Trigger manual syncs when immediate updates are needed
Consider account type when setting expectations

OneDrive-Specific Benefits:

Supports both personal and business Microsoft accounts
Processes all major Office document formats
Preserves document structure and formatting
Handles large enterprise document collections

Important Limitations:

Large Office documents may take significant time to process
Complex Excel formulas may not convert perfectly to markdown
Microsoft API rate limits may slow sync for large accounts

Getting started

Concepts

Using supermemory

Deployment

Other resources

Migration guides

Sync scope

Quick setup

1. Create OneDrive Connector

2. Handle Microsoft OAuth

3. Monitor sync status

Supported document types

Microsoft Word documents

Excel spreadsheets

PowerPoint presentations

Sync mechanism

Manual sync trigger

Delete Connector

Advanced configuration

Custom Microsoft app

Optimization tips

​Sync scope

​Quick setup

​1. Create OneDrive Connector

​2. Handle Microsoft OAuth

​3. Monitor sync status

​Supported document types

​Microsoft Word documents

​Excel spreadsheets

​PowerPoint presentations

​Sync mechanism

​Manual sync trigger

​Delete Connector

​Advanced configuration

​Custom Microsoft app

​Optimization tips

Sync scope

Quick setup

1. Create OneDrive Connector

2. Handle Microsoft OAuth

3. Monitor sync status

Supported document types

Microsoft Word documents

Excel spreadsheets

PowerPoint presentations

Sync mechanism

Manual sync trigger

Delete Connector

Advanced configuration

Custom Microsoft app

Optimization tips