OneDrive Automation via Rube MCP

Automate OneDrive operations including file upload/download, search, folder management, sharing links, permissions management, and drive browsing through Composio's OneDrive toolkit.

Prerequisites

• Rube MCP must be connected (RUBESEARCHTOOLS available)
• Active OneDrive connection via RUBEMANAGECONNECTIONS with toolkit one_drive
• Always call RUBESEARCHTOOLS first to get current tool schemas

Setup

Get Rube MCP: Add https://rube.app/mcp as an MCP server in your client configuration. No API keys needed — just add the endpoint and it works.

1. Verify Rube MCP is available by confirming RUBESEARCHTOOLS responds
2. Call RUBEMANAGECONNECTIONS with toolkit one_drive
3. If connection is not ACTIVE, follow the returned auth link to complete Microsoft OAuth
4. Confirm connection status shows ACTIVE before running any workflows

Core Workflows

1. Search and Browse Files

When to use: User wants to find files or browse folder contents in OneDrive

Tool sequence:

1. ONEDRIVEGET_DRIVE - Verify drive access and get drive details [Prerequisite]
2. ONEDRIVESEARCH_ITEMS - Keyword search across filenames, metadata, and content [Required]
3. ONEDRIVEONEDRIVELISTITEMS - List all items in the root of a drive [Optional]
4. ONEDRIVEGET_ITEM - Get detailed metadata for a specific item, expand children [Optional]
5. ONEDRIVEONEDRIVEFINDFILE - Find a specific file by exact name in a folder [Optional]
6. ONEDRIVEONEDRIVEFINDFOLDER - Find a specific folder by name [Optional]
7. ONEDRIVELIST_DRIVES - List all accessible drives [Optional]

Key parameters:

• q: Search query (plain keywords only, NOT KQL syntax)
• search_scope: "root" (folder hierarchy) or "drive" (includes shared items)
• top: Max items per page (default 200)
• skip_token: Pagination token from @odata.nextLink
• select: Comma-separated fields to return (e.g., "id,name,webUrl,size")
• orderby: Sort order (e.g., "name asc", "name desc")
• itemid: Item ID for GETITEM
• expandrelations: Array like ["children"] or ["thumbnails"] for GETITEM
• user_id: "me" (default) or specific user ID/email

Pitfalls:

• ONEDRIVESEARCH_ITEMS does NOT support KQL operators (folder:, file:, filetype:, path:); these are treated as literal text
• Wildcard characters (, ?) are NOT supported and are auto-removed; use file extension keywords instead (e.g., "pdf" not ".pdf")
• ONEDRIVEONEDRIVELISTITEMS returns only root-level contents; use recursive ONEDRIVEGETITEM with expandrelations: ["children"] for deeper levels
• Large folders paginate; always follow skip_token / @odata.nextLink until exhausted
• Some drive ID formats may return "ObjectHandle is Invalid" errors due to Microsoft Graph API limitations

2. Upload and Download Files

When to use: User wants to upload files to OneDrive or download files from it

Tool sequence:

1. ONEDRIVEONEDRIVEFINDFOLDER - Locate the target folder [Prerequisite]
2. ONEDRIVEONEDRIVEUPLOADFILE - Upload a file to a specified folder [Required for upload]
3. ONEDRIVEDOWNLOAD_FILE - Download a file by item ID [Required for download]
4. ONEDRIVEGET_ITEM - Get file details before download [Optional]

Key parameters:

• file: FileUploadable object with s3key, mimetype, and name for uploads
• folder: Destination path (e.g., "/Documents/Reports") or folder ID for uploads
• item_id: File's unique identifier for downloads
• file_name: Desired filename with extension for downloads
• drive_id: Specific drive ID (for SharePoint or OneDrive for Business)
• user_id: "me" (default) or specific user identifier

Pitfalls:

• Upload automatically renames on conflict (no overwrite option by default)
• Large files are automatically handled via chunking
• driveid overrides userid when both are provided
• Item IDs vary by platform: OneDrive for Business uses 01... prefix, OneDrive Personal uses HASH!NUMBER format
• Item IDs are case-sensitive; use exactly as returned from API

3. Share Files and Manage Permissions

When to use: User wants to share files/folders or manage who has access

Tool sequence:

1. ONEDRIVEONEDRIVEFINDFILE or ONEDRIVEONEDRIVEFINDFOLDER - Locate the item [Prerequisite]
2. ONEDRIVEGETITEMPERMISSIONS - Check current permissions [Prerequisite]
3. ONEDRIVEINVITEUSERTODRIVEITEM - Grant access to specific users [Required]
4. ONEDRIVECREATE_LINK - Create a shareable link [Optional]
5. ONEDRIVEUPDATEDRIVEITEM_METADATA - Update item metadata [Optional]

Key parameters:

• item_id: The file or folder to share
• recipients: Array of objects with email or object_id
• roles: Array with "read" or "write"
• send_invitation: true to send notification email, false for silent permission grant
• requiresignin: true to require authentication to access
• message: Custom message for invitation (max 2000 characters)
• expirationdatetime: ISO 8601 date for permission expiry
• retaininheritedpermissions: true (default) to keep existing inherited permissions

Pitfalls:

• Using wrong itemid with INVITEUSERTODRIVE_ITEM changes permissions on unintended items; always verify first
• Write or higher roles are impactful; get explicit user confirmation before granting
• GETITEMPERMISSIONS returns inherited and owner entries; do not assume response only reflects recent changes
• permissions cannot be expanded via ONEDRIVEGET_ITEM; use the separate permissions endpoint
• At least one of requiresignin or send_invitation must be true

4. Manage Folders (Create, Move, Delete, Copy)

When to use: User wants to create, move, rename, delete, or copy files and folders

Tool sequence:

1. ONEDRIVEONEDRIVEFINDFOLDER - Locate source and destination folders [Prerequisite]
2. ONEDRIVEONEDRIVECREATEFOLDER - Create a new folder [Required for create]
3. ONEDRIVEMOVE_ITEM - Move a file or folder to a new location [Required for move]
4. ONEDRIVECOPY_ITEM - Copy a file or folder (async operation) [Required for copy]
5. ONEDRIVEDELETE_ITEM - Move item to recycle bin [Required for delete]
6. ONEDRIVEUPDATEDRIVEITEM_METADATA - Rename or update item properties [Optional]

Key parameters:

• name: Folder name for creation or new name for rename/copy
• parent_folder: Path (e.g., "/Documents/Reports") or folder ID for creation
• itemId: Item to move
• parentReference: Object with id (destination folder ID) for moves: {"id": "folder_id"}
• item_id: Item to copy or delete
• parent_reference: Object with id and optional driveId for copy destination
• @microsoft.graph.conflictBehavior: "fail", "replace", or "rename" for copies
• if_match: ETag for optimistic concurrency on deletes

Pitfalls:

• ONEDRIVEMOVEITEM does NOT support cross-drive moves; use ONEDRIVECOPYITEM for cross-drive transfers
• parentReference for moves requires folder ID (not folder name); resolve with ONEDRIVEFINDFOLDER first
• ONEDRIVECOPY_ITEM is asynchronous; response provides a URL to monitor progress
• ONEDRIVEDELETE_ITEM moves to recycle bin, not permanent deletion
• Folder creation auto-renames on conflict (e.g., "New Folder" becomes "New Folder 1")
• Provide either name or parentreference (or both) for ONEDRIVECOPYITEM

5. Track Changes and Drive Information

When to use: User wants to monitor changes or get drive/quota information

Tool sequence:

1. ONEDRIVEGET_DRIVE - Get drive properties and metadata [Required]
2. ONEDRIVEGET_QUOTA - Check storage quota (total, used, remaining) [Optional]
3. ONEDRIVELISTSITEDRIVEITEMSDELTA - Track changes in SharePoint site drives [Optional]
4. ONEDRIVEGETITEMVERSIONS - Get version history of a file [Optional]

Key parameters:

• drive_id: Drive identifier (or "me" for personal drive)
• site_id: SharePoint site identifier for delta tracking
• token: Delta token ("latest" for current state, URL for next page, or timestamp)
• item_id: File ID for version history

Pitfalls:

• Delta queries are only available for SharePoint site drives via ONEDRIVELISTSITEDRIVEITEMSDELTA
• Token "latest" returns current delta token without items (useful as starting point)
• Deep or large drives can take several minutes to crawl; use batching and resume logic

Common Patterns

ID Resolution

• User: Use "me" for authenticated user or specific user email/GUID
• Item ID from find: Use ONEDRIVEONEDRIVEFINDFILE or ONEDRIVEONEDRIVEFINDFOLDER to get item IDs
• Item ID from search: Extract from ONEDRIVESEARCH_ITEMS results
• Drive ID: Use ONEDRIVELISTDRIVES or ONEDRIVEGETDRIVE to discover drives
• Folder path to ID: Use ONEDRIVEONEDRIVEFINDFOLDER with path, then extract ID from response

ID formats vary by platform:

• OneDrive for Business/SharePoint: 01NKDM7HMOJTVYMDOSXFDK2QJDXCDI3WUK
• OneDrive Personal: D4648F06C91D9D3D!54927

Pagination

OneDrive uses token-based pagination:

• Follow @odata.nextLink or skip_token until no more pages
• Set top for page size (varies by endpoint)
• ONEDRIVEONEDRIVELISTITEMS auto-handles pagination internally
• Aggressive parallel requests can trigger HTTP 429; honor Retry-After headers

Path vs ID

Most OneDrive tools accept either paths or IDs:

• Paths: Start with / (e.g., "/Documents/Reports")
• IDs: Use unique item identifiers from API responses
• Item paths for permissions: Use :/path/to/item:/ format

Known Pitfalls

ID Formats

• Item IDs are case-sensitive and platform-specific
• Never use web URLs, sharing links, or manually constructed identifiers as item IDs
• Always use IDs exactly as returned from Microsoft Graph API

Rate Limits

• Aggressive parallel ONEDRIVEGET_ITEM calls can trigger HTTP 429 Too Many Requests
• Honor Retry-After headers and implement throttling
• Deep drive crawls should use batching with delays

Search Limitations

• No KQL support; use plain keywords only
• No wildcard characters; use extension keywords (e.g., "pdf" not "*.pdf")
• No path-based filtering in search; use folder listing instead
• q='*' wildcard-only queries return HTTP 400 invalidRequest

Parameter Quirks

• driveid overrides userid when both are provided
• permissions cannot be expanded via GET_ITEM; use dedicated permissions endpoint
• Move operations require folder IDs in parentReference, not folder names
• Copy operations are asynchronous; response provides monitoring URL

Quick Reference

When to Use

This skill is applicable to execute the workflow or actions described in the overview.

Example

User request:

Automate OneDrive file management, search, uploads, downloads, sharing, permissions, and folder operations via Rube MCP (Composio).

Limitations

• Use this skill only when the task clearly matches the scope described above.
• Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
• Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.