SharePoint Automation

SharePoint Automation - Enterprise Document Automation Management

Skills Overview

SharePoint Automation provides automated operations for SharePoint and OneDrive through the Rube MCP server. It supports managing sites, lists, documents, folders, pages, and search content, and is suitable for scenarios that need to integrate Microsoft 365 document services.

Use Cases

Automated Enterprise Document Library Management

Automatically create document libraries and folder structures, bulk upload and organize files. Suitable for standardized enterprise document management and project archiving workflows.

SharePoint List and Task Management

Create and manage task lists and project tracking lists. Use Delta Query for incremental synchronization to enable two-way data synchronization with external systems.

Content Search and Metadata Extraction

Use KQL query syntax to search SharePoint content, extract document metadata and page content, and support enterprise-grade document discovery and content migration.

Core Features

Site and List Management

Use the SharePoint REST API and Microsoft Graph to enumerate sites and sub-sites. Create various lists (task lists, document libraries, etc.) and retrieve list details.

File and Folder Operations

Create folders in a document library, list folder contents, and navigate/manage document hierarchy using server-relative paths.

Search and Incremental Synchronization

Use Keyword Query Language (KQL) to search documents and list items. Use Delta Query to fetch incremental changes to avoid the performance overhead of full synchronization.

FAQs

Does SharePoint Automation support personal Microsoft accounts?

No. Most tools in SharePoint Automation (such as ONE_DRIVE_LIST_SITE_LISTS and Microsoft Graph–based tools) only support organizational Microsoft 365 accounts (Azure AD/Entra ID). Personal MSA/Outlook.com accounts cannot be used.

How do I get a SharePoint site ID?

A site ID must use a composite format: hostname,site-collection-guid,web-guid. For example: "contoso.sharepoint.com,2C712604-1370-44E7-A1F5-426573FDA80A,2D2244C3-251A-49EA-93A8-39E1C3A060FE". An incorrect format will result in a 400 error. You can obtain site metadata via the ONE_DRIVE_GET_SITE_DETAILS tool.

How do I use Delta Query for incremental synchronization?

Use the ONE_DRIVE_LIST_SHAREPOINT_LIST_ITEMS_DELTA tool. On the first call, omit the token parameter to get the full data and a synchronization token; on subsequent calls, pass in that token to retrieve incremental changes. Pass in "latest" to get an empty response and a new token, which can be used to reset the synchronization position.