SharePoint MCP Server

Instructions

Implementation Reference

• src/mcp_sharepoint/tools.py:107-128 (handler)

  Full handler implementation for the 'Update_Document' tool. Registers the tool with MCP, applies error handling decorator, defines input parameters (folder_name, file_name, content, is_base64), checks file existence, decodes content if base64-encoded, overwrites the file in SharePoint using upload_file, and returns success response with file info.

  @mcp.tool(name="Update_Document", description="Update an existing document in a SharePoint directory")
  @_handle_sp_operation
  async def update_document(folder_name: str, file_name: str, content: str, is_base64: bool = False):
      """Update an existing document in a SharePoint directory"""
      logger.info(f"Updating document {file_name} in folder {folder_name}")
      
      # Check if file exists
      file_path = _get_path(folder_name, file_name)
      file = sp_context.web.get_file_by_server_relative_url(file_path)
      sp_context.load(file, ["Exists", "Name", "ServerRelativeUrl"])
      sp_context.execute_query()
      
      if not file.exists:
          return {"success": False, "message": f"File {file_name} does not exist in folder {folder_name}"}
      
      # Update file using upload method
      file_content = base64.b64decode(content) if is_base64 else content.encode('utf-8')
      folder = sp_context.web.get_folder_by_server_relative_url(_get_path(folder_name))
      updated_file = folder.upload_file(file_name, file_content)
      sp_context.execute_query()
      
      return _file_success_response(updated_file, f"File {file_name} updated successfully")

• src/mcp_sharepoint/tools.py:107-107 (registration)

  Explicit registration of the Update_Document tool using the @mcp.tool decorator, specifying the tool name.

  @mcp.tool(name="Update_Document", description="Update an existing document in a SharePoint directory")

• src/mcp_sharepoint/tools.py:13-22 (helper)

  Helper decorator applied to the Update_Document handler for standardized SharePoint error handling and logging.

  def _handle_sp_operation(func):
      """Decorator for SharePoint operations with error handling"""
      @wraps(func)
      async def wrapper(*args, **kwargs):
          try:
              return await func(*args, **kwargs)
          except Exception as e:
              logger.error(f"Error in {func.__name__}: {str(e)}")
              return {"success": False, "message": f"Operation failed: {str(e)}"}
      return wrapper

• src/mcp_sharepoint/tools.py:8-11 (helper)

  Utility function used to build SharePoint server-relative paths for the document location.

  def _get_path(folder: str = "", file: Optional[str] = None) -> str:
      """Construct SharePoint path from components"""
      path = f"{SHP_DOC_LIBRARY}/{folder}".rstrip('/')
      return f"{path}/{file}" if file else path

• src/mcp_sharepoint/tools.py:24-30 (helper)

  Helper function to format the success response returned by the Update_Document tool.

  def _file_success_response(file_obj, message: str) -> Dict[str, Any]:
      """Standard success response for file operations"""
      return {
          "success": True,
          "message": message,
          "file": {"name": file_obj.name, "url": file_obj.serverRelativeUrl}
      }