Skip to main content
Glama

SharePoint Online MCP Server

by Zerg00s
getLists.ts3.1 kB
// src/tools/getLists.ts import request from 'request-promise'; import { ISharePointListResponse, IList, IToolResult } from '../interfaces'; import { getSharePointHeaders, getRequestDigest } from '../auth_factory'; import { SharePointConfig } from '../config'; export interface GetListsParams { url: string; } /** * Get all visible SharePoint lists from a site * @param params Parameters including the SharePoint site URL * @param config SharePoint configuration * @returns Tool result with lists data */ export async function getLists( params: GetListsParams, config: SharePointConfig ): Promise<IToolResult> { const { url } = params; console.error("getLists tool called with URL:", url); try { // Authenticate with SharePoint const headers = await getSharePointHeaders(url, config); console.error("Headers prepared:", headers); // Make request to SharePoint API to get lists console.error("Making request to SharePoint API for lists..."); const response = await request({ url: `${url}/_api/web/lists?$select=Title,Id,ItemCount,LastItemModifiedDate,Description,BaseTemplate,Hidden,IsSystemList,RootFolder/ServerRelativeUrl&$expand=RootFolder`, headers: headers, json: true, method: 'GET', timeout: 15000 }); console.error(`SharePoint API response received with ${response.d.results.length} total lists`); // Filter out hidden and system lists const visibleLists = response.d.results.filter((list: ISharePointListResponse) => !list.Hidden && !list.IsSystemList ); console.error(`Filtered to ${visibleLists.length} visible lists (excluding hidden and system lists)`); // Format the list data for display const lists: IList[] = visibleLists.map((list: ISharePointListResponse) => { return { Title: list.Title, URL: `${url}${list.RootFolder.ServerRelativeUrl}`, ItemCount: list.ItemCount, LastModified: list.LastItemModifiedDate, Description: list.Description || 'No description', BaseTemplateID: list.BaseTemplate }; }); return { content: [{ type: "text", text: JSON.stringify(lists, null, 2) }] } as IToolResult; } catch (error: unknown) { // Type-safe error handling let errorMessage: string; if (error instanceof Error) { errorMessage = error.message; } else if (typeof error === 'string') { errorMessage = error; } else { errorMessage = "Unknown error occurred"; } console.error("Error in getLists tool:", errorMessage); return { content: [{ type: "text", text: `Error fetching lists: ${errorMessage}` }], isError: true } as IToolResult; } } export default getLists;

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Zerg00s/server-sharepoint'

If you have feedback or need assistance with the MCP directory API, please join our Discord server