get_item_by_path | Fetch a file or folder of a document library by its path from the library root, e.g. “Contracts/2026/Offer Acme.docx”. Returns id, name, size, file/folder facet, webUrl. |
get_list | Fetch a list by id or display title. expand_columns: true also returns its column definitions (internal names and types) — read it before create_list_item / update_list_item_fields. |
get_list_item | Fetch one list item with its column values (fields), created/modified dates and authors. |
get_site | Fetch a site (id, name, displayName, description, webUrl). Pass site_id “root” for the tenant root site — the quickest check that the connection works. |
get_site_by_path | Fetch a site from its URL: hostname “contoso.sharepoint.com” and server-relative path “sites/Marketing” for https://contoso.sharepoint.com/sites/Marketing. Returns the site id used by the other actions. |
list_drive_children | List files and folders inside a folder of a document library. item_id “root” lists the library top level. Optional: top (1–200), orderby (“name” or “lastModifiedDateTime desc”). |
list_drives | List the document libraries (drives) of a site — id, name (e.g. “Documents”), webUrl. The drive id is used by the file actions. Optional: top (1–200). |
list_list_items | List the items of a list with their column values (fields). Optional: select (column internal names to return), filter (OData, e.g. “fields/Status eq ‘Open’” — operators eq, ne, lt, gt, le, ge, startswith; works best on indexed columns), top (1–500). |
list_lists | List the lists and document libraries of a site (id, name, displayName, list.template — “genericList”, “documentLibrary”…, webUrl). |
list_pages | List the modern pages of a site (id, name, title, webUrl, pageLayout, publishingState, lastModifiedDateTime) — metadata only, not the page content. Optional: top (1–200). |
list_subsites | List the subsites of a site (id, name, displayName, webUrl). |
search_drive_items | Search a document library for files and folders matching a query (file names, metadata and file content). Optional: top (1–200). |
search_sites | Search the SharePoint sites the connected user can access by keyword (site name, title, description). Returns id, name, displayName, webUrl for each site. |