> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# microsoft-365-sites

> Microsoft 365 SharePoint — search and browse sites, manage lists and list items

**Server path:** `/microsoft-365-sites` | **Type:** Application | **PCID required:** Yes

## Tools

| Tool                                                                                      | Description                                                                                                                                                                                                                                                                                                                           |
| ----------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [`microsoft-365-sites_copy_item`](#microsoft-365-sites_copy_item)                         | Copy a file or folder within (or across) SharePoint document libraries to a destination folder. Optionally rename the copy.                                                                                                                                                                                                           |
| [`microsoft-365-sites_create_column`](#microsoft-365-sites_create_column)                 | Add a column to a SharePoint list. Provide a Graph column definition object, e.g. \{ "name": "Author", "text": \{} }.                                                                                                                                                                                                                 |
| [`microsoft-365-sites_create_list`](#microsoft-365-sites_create_list)                     | Create a new SharePoint list (generic list) in a site. Optionally provide initial column definitions.                                                                                                                                                                                                                                 |
| [`microsoft-365-sites_create_site_list_item`](#microsoft-365-sites_create_site_list_item) | Create an item in a SharePoint list                                                                                                                                                                                                                                                                                                   |
| [`microsoft-365-sites_delete_column`](#microsoft-365-sites_delete_column)                 | Delete a column from a SharePoint list. This permanently removes the column and its data.                                                                                                                                                                                                                                             |
| [`microsoft-365-sites_delete_list`](#microsoft-365-sites_delete_list)                     | Delete a SharePoint list from a site. This permanently removes the list and all of its items.                                                                                                                                                                                                                                         |
| [`microsoft-365-sites_delete_site_list_item`](#microsoft-365-sites_delete_site_list_item) | Delete a SharePoint list item                                                                                                                                                                                                                                                                                                         |
| [`microsoft-365-sites_download_file`](#microsoft-365-sites_download_file)                 | Download a file from a SharePoint document library by drive and item ID. In an agent chat it returns a downloadable file artifact (a signed `url` plus `id`/`filename`/`mimeType`); in workflow/no-chat mode it returns the file content as base64. For supported document types (PDF, DOCX, PPTX, XLSX) also returns extracted text. |
| [`microsoft-365-sites_get_item_by_path`](#microsoft-365-sites_get_item_by_path)           | Get a SharePoint drive item (file or folder) by its path within a document library, e.g. "Documents/report.pdf". Useful when you know the path but not the item ID.                                                                                                                                                                   |
| [`microsoft-365-sites_get_list_by_name`](#microsoft-365-sites_get_list_by_name)           | Find a SharePoint list in a site by its display name. Returns matching lists.                                                                                                                                                                                                                                                         |
| [`microsoft-365-sites_get_list_schema`](#microsoft-365-sites_get_list_schema)             | Get the column definitions (schema) of a SharePoint list.                                                                                                                                                                                                                                                                             |
| [`microsoft-365-sites_get_site`](#microsoft-365-sites_get_site)                           | Get a SharePoint site                                                                                                                                                                                                                                                                                                                 |
| [`microsoft-365-sites_get_site_drive`](#microsoft-365-sites_get_site_drive)               | Get a site's document library drive                                                                                                                                                                                                                                                                                                   |
| [`microsoft-365-sites_get_site_list`](#microsoft-365-sites_get_site_list)                 | Get a SharePoint list                                                                                                                                                                                                                                                                                                                 |
| [`microsoft-365-sites_get_site_list_item`](#microsoft-365-sites_get_site_list_item)       | Get a SharePoint list item                                                                                                                                                                                                                                                                                                            |
| [`microsoft-365-sites_list_drives`](#microsoft-365-sites_list_drives)                     | List the document libraries (drives) available in a SharePoint site. Use a drive ID from this list with the drive-scoped file tools.                                                                                                                                                                                                  |
| [`microsoft-365-sites_list_folder_contents`](#microsoft-365-sites_list_folder_contents)   | Recursively list the contents of a folder in a SharePoint document library (and its subfolders) up to a depth limit. Use folder\_path "" or omit it to start at the drive root.                                                                                                                                                       |
| [`microsoft-365-sites_list_site_list_items`](#microsoft-365-sites_list_site_list_items)   | List items in a SharePoint list                                                                                                                                                                                                                                                                                                       |
| [`microsoft-365-sites_list_site_lists`](#microsoft-365-sites_list_site_lists)             | List SharePoint lists in a site                                                                                                                                                                                                                                                                                                       |
| [`microsoft-365-sites_list_subsites`](#microsoft-365-sites_list_subsites)                 | List the subsites directly under a SharePoint site.                                                                                                                                                                                                                                                                                   |
| [`microsoft-365-sites_move_item`](#microsoft-365-sites_move_item)                         | Move a file or folder to a different destination folder within a SharePoint document library. Optionally rename the item.                                                                                                                                                                                                             |
| [`microsoft-365-sites_search_sites`](#microsoft-365-sites_search_sites)                   | Search SharePoint sites                                                                                                                                                                                                                                                                                                               |
| [`microsoft-365-sites_update_column`](#microsoft-365-sites_update_column)                 | Update an existing column in a SharePoint list. Provide an object with the column properties to change.                                                                                                                                                                                                                               |
| [`microsoft-365-sites_update_site_list_item`](#microsoft-365-sites_update_site_list_item) | Update a SharePoint list item                                                                                                                                                                                                                                                                                                         |
| [`microsoft-365-sites_upload_file`](#microsoft-365-sites_upload_file)                     | Upload a file to a SharePoint document library at the given path. Provide the file content as a base64-encoded string. Creates the file or replaces it if one already exists at that path.                                                                                                                                            |

***

## microsoft-365-sites\_copy\_item

Copy a file or folder within (or across) SharePoint document libraries to a destination folder. Optionally rename the copy.

**Parameters:**

| Parameter         | Type   | Required | Default | Description                                                                              |
| ----------------- | ------ | -------- | ------- | ---------------------------------------------------------------------------------------- |
| `drive_id`        | string | Yes      | —       | The unique ID of the source document library (drive) containing the item.                |
| `item_id`         | string | Yes      | —       | The unique ID of the item (file or folder) to copy.                                      |
| `parent_id`       | string | Yes      | —       | The unique ID of the destination folder (drive item) the copy should be placed in.       |
| `parent_drive_id` | string | No       | —       | Optional unique ID of the destination drive, if copying to a different document library. |
| `new_name`        | string | No       | —       | Optional new name for the copied item.                                                   |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "drive_id": {
        "type": "string",
        "description": "The unique ID of the source document library (drive) containing the item."
      },
      "item_id": {
        "type": "string",
        "description": "The unique ID of the item (file or folder) to copy."
      },
      "parent_id": {
        "type": "string",
        "description": "The unique ID of the destination folder (drive item) the copy should be placed in."
      },
      "parent_drive_id": {
        "type": "string",
        "description": "Optional unique ID of the destination drive, if copying to a different document library."
      },
      "new_name": {
        "type": "string",
        "description": "Optional new name for the copied item."
      }
    },
    "required": [
      "PCID",
      "drive_id",
      "item_id",
      "parent_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_create\_column

Add a column to a SharePoint list. Provide a Graph column definition object, e.g. \{ "name": "Author", "text": \{} }.

**Parameters:**

| Parameter | Type   | Required | Default | Description                                                                                                         |
| --------- | ------ | -------- | ------- | ------------------------------------------------------------------------------------------------------------------- |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site                                                                                |
| `list_id` | string | Yes      | —       | The unique ID of the SharePoint list                                                                                |
| `column`  | object | Yes      | —       | The column definition to create, e.g. \{ "name": "Author", "text": \{} } or \{ "name": "Priority", "number": \{} }. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint list"
      },
      "column": {
        "type": "object",
        "description": "The column definition to create, e.g. { \"name\": \"Author\", \"text\": {} } or { \"name\": \"Priority\", \"number\": {} }."
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_id",
      "column"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_create\_list

Create a new SharePoint list (generic list) in a site. Optionally provide initial column definitions.

**Parameters:**

| Parameter      | Type      | Required | Default | Description                                                                      |
| -------------- | --------- | -------- | ------- | -------------------------------------------------------------------------------- |
| `site_id`      | string    | Yes      | —       | The unique ID of the SharePoint site                                             |
| `display_name` | string    | Yes      | —       | The display name for the new list                                                |
| `description`  | string    | No       | —       | Optional description for the new list                                            |
| `columns`      | object\[] | No       | —       | Optional array of column definitions, e.g. \[\{ "name": "Author", "text": \{} }] |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "display_name": {
        "type": "string",
        "description": "The display name for the new list"
      },
      "description": {
        "type": "string",
        "description": "Optional description for the new list"
      },
      "columns": {
        "type": "array",
        "items": {
          "type": "object"
        },
        "description": "Optional array of column definitions, e.g. [{ \"name\": \"Author\", \"text\": {} }]"
      }
    },
    "required": [
      "PCID",
      "site_id",
      "display_name"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_create\_site\_list\_item

Create an item in a SharePoint list

**Parameters:**

| Parameter | Type   | Required | Default | Description                                                                           |
| --------- | ------ | -------- | ------- | ------------------------------------------------------------------------------------- |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site                                                  |
| `list_id` | string | Yes      | —       | The unique ID of the SharePoint list                                                  |
| `fields`  | object | Yes      | —       | Field values for the new list item. Keys are column names, values are the field data. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint list"
      },
      "fields": {
        "type": "object",
        "description": "Field values for the new list item. Keys are column names, values are the field data."
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_id",
      "fields"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_delete\_column

Delete a column from a SharePoint list. This permanently removes the column and its data.

**Parameters:**

| Parameter   | Type   | Required | Default | Description                           |
| ----------- | ------ | -------- | ------- | ------------------------------------- |
| `site_id`   | string | Yes      | —       | The unique ID of the SharePoint site  |
| `list_id`   | string | Yes      | —       | The unique ID of the SharePoint list  |
| `column_id` | string | Yes      | —       | The unique ID of the column to delete |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint list"
      },
      "column_id": {
        "type": "string",
        "description": "The unique ID of the column to delete"
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_id",
      "column_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_delete\_list

Delete a SharePoint list from a site. This permanently removes the list and all of its items.

**Parameters:**

| Parameter | Type   | Required | Default | Description                                    |
| --------- | ------ | -------- | ------- | ---------------------------------------------- |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site           |
| `list_id` | string | Yes      | —       | The unique ID of the SharePoint list to delete |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint list to delete"
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_delete\_site\_list\_item

Delete a SharePoint list item

**Parameters:**

| Parameter | Type   | Required | Default | Description                              |
| --------- | ------ | -------- | ------- | ---------------------------------------- |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site     |
| `list_id` | string | Yes      | —       | The unique ID of the SharePoint list     |
| `item_id` | string | Yes      | —       | The unique ID of the list item to delete |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint list"
      },
      "item_id": {
        "type": "string",
        "description": "The unique ID of the list item to delete"
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_id",
      "item_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_download\_file

Download a file from a SharePoint document library by drive and item ID. In an agent chat it returns a downloadable file artifact (a signed `url` plus `id`/`filename`/`mimeType`); in workflow/no-chat mode it returns the file content as base64. For supported document types (PDF, DOCX, PPTX, XLSX) also returns extracted text.

**Parameters:**

| Parameter      | Type    | Required | Default | Description                                                                                                       |
| -------------- | ------- | -------- | ------- | ----------------------------------------------------------------------------------------------------------------- |
| `drive_id`     | string  | Yes      | —       | The unique ID of the SharePoint document library (drive). Get it from list\_drives or get\_site\_drive.           |
| `item_id`      | string  | Yes      | —       | The unique ID of the drive item (file) to download.                                                               |
| `extract_text` | boolean | No       | —       | Whether to extract text for supported document types (default true). Set false to return only the base64 content. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "drive_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint document library (drive). Get it from list_drives or get_site_drive."
      },
      "item_id": {
        "type": "string",
        "description": "The unique ID of the drive item (file) to download."
      },
      "extract_text": {
        "type": "boolean",
        "description": "Whether to extract text for supported document types (default true). Set false to return only the base64 content."
      }
    },
    "required": [
      "PCID",
      "drive_id",
      "item_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_get\_item\_by\_path

Get a SharePoint drive item (file or folder) by its path within a document library, e.g. "Documents/report.pdf". Useful when you know the path but not the item ID.

**Parameters:**

| Parameter  | Type   | Required | Default | Description                                                                                             |
| ---------- | ------ | -------- | ------- | ------------------------------------------------------------------------------------------------------- |
| `drive_id` | string | Yes      | —       | The unique ID of the SharePoint document library (drive). Get it from list\_drives or get\_site\_drive. |
| `path`     | string | Yes      | —       | Path to the item relative to the drive root, e.g. "Documents/report.pdf" or "Photos".                   |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "drive_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint document library (drive). Get it from list_drives or get_site_drive."
      },
      "path": {
        "type": "string",
        "description": "Path to the item relative to the drive root, e.g. \"Documents/report.pdf\" or \"Photos\"."
      }
    },
    "required": [
      "PCID",
      "drive_id",
      "path"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_get\_list\_by\_name

Find a SharePoint list in a site by its display name. Returns matching lists.

**Parameters:**

| Parameter   | Type   | Required | Default | Description                                     |
| ----------- | ------ | -------- | ------- | ----------------------------------------------- |
| `site_id`   | string | Yes      | —       | The unique ID of the SharePoint site            |
| `list_name` | string | Yes      | —       | The display name of the SharePoint list to find |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_name": {
        "type": "string",
        "description": "The display name of the SharePoint list to find"
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_name"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_get\_list\_schema

Get the column definitions (schema) of a SharePoint list.

**Parameters:**

| Parameter | Type   | Required | Default | Description                          |
| --------- | ------ | -------- | ------- | ------------------------------------ |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site |
| `list_id` | string | Yes      | —       | The unique ID of the SharePoint list |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint list"
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_get\_site

Get a SharePoint site

**Parameters:**

| Parameter | Type   | Required | Default | Description                                                       |
| --------- | ------ | -------- | ------- | ----------------------------------------------------------------- |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site, or "root" for the root site |
| `$select` | string | No       | —       | Comma-separated properties to return                              |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site, or \"root\" for the root site"
      },
      "$select": {
        "type": "string",
        "description": "Comma-separated properties to return"
      }
    },
    "required": [
      "PCID",
      "site_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_get\_site\_drive

Get a site's document library drive

**Parameters:**

| Parameter | Type   | Required | Default | Description                          |
| --------- | ------ | -------- | ------- | ------------------------------------ |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      }
    },
    "required": [
      "PCID",
      "site_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_get\_site\_list

Get a SharePoint list

**Parameters:**

| Parameter | Type   | Required | Default | Description                                                             |
| --------- | ------ | -------- | ------- | ----------------------------------------------------------------------- |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site                                    |
| `list_id` | string | Yes      | —       | The unique ID of the SharePoint list                                    |
| `$expand` | string | No       | —       | Expand related resources (e.g. "columns" to include column definitions) |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint list"
      },
      "$expand": {
        "type": "string",
        "description": "Expand related resources (e.g. \"columns\" to include column definitions)"
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_get\_site\_list\_item

Get a SharePoint list item

**Parameters:**

| Parameter | Type   | Required | Default | Description                                                          |
| --------- | ------ | -------- | ------- | -------------------------------------------------------------------- |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site                                 |
| `list_id` | string | Yes      | —       | The unique ID of the SharePoint list                                 |
| `item_id` | string | Yes      | —       | The unique ID of the list item                                       |
| `$expand` | string | No       | —       | Expand related resources (use "fields" to include item field values) |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint list"
      },
      "item_id": {
        "type": "string",
        "description": "The unique ID of the list item"
      },
      "$expand": {
        "type": "string",
        "description": "Expand related resources (use \"fields\" to include item field values)"
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_id",
      "item_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_list\_drives

List the document libraries (drives) available in a SharePoint site. Use a drive ID from this list with the drive-scoped file tools.

**Parameters:**

| Parameter | Type   | Required | Default | Description                          |
| --------- | ------ | -------- | ------- | ------------------------------------ |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      }
    },
    "required": [
      "PCID",
      "site_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_list\_folder\_contents

Recursively list the contents of a folder in a SharePoint document library (and its subfolders) up to a depth limit. Use folder\_path "" or omit it to start at the drive root.

**Parameters:**

| Parameter     | Type    | Required | Default | Description                                                                                             |
| ------------- | ------- | -------- | ------- | ------------------------------------------------------------------------------------------------------- |
| `drive_id`    | string  | Yes      | —       | The unique ID of the SharePoint document library (drive). Get it from list\_drives or get\_site\_drive. |
| `folder_path` | string  | No       | —       | Path to the starting folder relative to the drive root, e.g. "Documents". Omit or "" for the root.      |
| `max_depth`   | integer | No       | —       | Maximum recursion depth (default 3). 0 lists only the immediate folder.                                 |
| `max_results` | integer | No       | —       | Maximum number of items to return across all levels (default 200).                                      |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "drive_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint document library (drive). Get it from list_drives or get_site_drive."
      },
      "folder_path": {
        "type": "string",
        "description": "Path to the starting folder relative to the drive root, e.g. \"Documents\". Omit or \"\" for the root."
      },
      "max_depth": {
        "type": "integer",
        "description": "Maximum recursion depth (default 3). 0 lists only the immediate folder."
      },
      "max_results": {
        "type": "integer",
        "description": "Maximum number of items to return across all levels (default 200)."
      }
    },
    "required": [
      "PCID",
      "drive_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_list\_site\_list\_items

List items in a SharePoint list

**Parameters:**

| Parameter | Type    | Required | Default | Description                                                          |
| --------- | ------- | -------- | ------- | -------------------------------------------------------------------- |
| `site_id` | string  | Yes      | —       | The unique ID of the SharePoint site                                 |
| `list_id` | string  | Yes      | —       | The unique ID of the SharePoint list                                 |
| `$expand` | string  | No       | —       | Expand related resources (use "fields" to include item field values) |
| `$filter` | string  | No       | —       | OData filter expression to filter items by field values              |
| `$top`    | integer | No       | —       | Number of items to return                                            |
| `$select` | string  | No       | —       | Comma-separated properties to return                                 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint list"
      },
      "$expand": {
        "type": "string",
        "description": "Expand related resources (use \"fields\" to include item field values)"
      },
      "$filter": {
        "type": "string",
        "description": "OData filter expression to filter items by field values"
      },
      "$top": {
        "type": "integer",
        "description": "Number of items to return"
      },
      "$select": {
        "type": "string",
        "description": "Comma-separated properties to return"
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_list\_site\_lists

List SharePoint lists in a site

**Parameters:**

| Parameter | Type   | Required | Default | Description                                                                   |
| --------- | ------ | -------- | ------- | ----------------------------------------------------------------------------- |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site                                          |
| `$select` | string | No       | —       | Comma-separated properties to return (e.g. "id,displayName,description,list") |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "$select": {
        "type": "string",
        "description": "Comma-separated properties to return (e.g. \"id,displayName,description,list\")"
      }
    },
    "required": [
      "PCID",
      "site_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_list\_subsites

List the subsites directly under a SharePoint site.

**Parameters:**

| Parameter | Type   | Required | Default | Description                                 |
| --------- | ------ | -------- | ------- | ------------------------------------------- |
| `site_id` | string | Yes      | —       | The unique ID of the parent SharePoint site |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the parent SharePoint site"
      }
    },
    "required": [
      "PCID",
      "site_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_move\_item

Move a file or folder to a different destination folder within a SharePoint document library. Optionally rename the item.

**Parameters:**

| Parameter   | Type   | Required | Default | Description                                                                 |
| ----------- | ------ | -------- | ------- | --------------------------------------------------------------------------- |
| `drive_id`  | string | Yes      | —       | The unique ID of the document library (drive) containing the item.          |
| `item_id`   | string | Yes      | —       | The unique ID of the item (file or folder) to move.                         |
| `parent_id` | string | Yes      | —       | The unique ID of the destination folder (drive item) to move the item into. |
| `new_name`  | string | No       | —       | Optional new name for the item.                                             |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "drive_id": {
        "type": "string",
        "description": "The unique ID of the document library (drive) containing the item."
      },
      "item_id": {
        "type": "string",
        "description": "The unique ID of the item (file or folder) to move."
      },
      "parent_id": {
        "type": "string",
        "description": "The unique ID of the destination folder (drive item) to move the item into."
      },
      "new_name": {
        "type": "string",
        "description": "Optional new name for the item."
      }
    },
    "required": [
      "PCID",
      "drive_id",
      "item_id",
      "parent_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_search\_sites

Search SharePoint sites

**Parameters:**

| Parameter | Type    | Required | Default | Description                                             |
| --------- | ------- | -------- | ------- | ------------------------------------------------------- |
| `$search` | string  | No       | —       | Search query string (e.g. "marketing", "hr", "finance") |
| `$top`    | integer | No       | —       | Number of sites to return (max 200)                     |
| `$select` | string  | No       | —       | Comma-separated properties to return                    |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "$search": {
        "type": "string",
        "description": "Search query string (e.g. \"marketing\", \"hr\", \"finance\")"
      },
      "$top": {
        "type": "integer",
        "description": "Number of sites to return (max 200)"
      },
      "$select": {
        "type": "string",
        "description": "Comma-separated properties to return"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_update\_column

Update an existing column in a SharePoint list. Provide an object with the column properties to change.

**Parameters:**

| Parameter   | Type   | Required | Default | Description                                                           |
| ----------- | ------ | -------- | ------- | --------------------------------------------------------------------- |
| `site_id`   | string | Yes      | —       | The unique ID of the SharePoint site                                  |
| `list_id`   | string | Yes      | —       | The unique ID of the SharePoint list                                  |
| `column_id` | string | Yes      | —       | The unique ID of the column to update                                 |
| `updates`   | object | Yes      | —       | The column properties to update, e.g. \{ "displayName": "New Name" }. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint list"
      },
      "column_id": {
        "type": "string",
        "description": "The unique ID of the column to update"
      },
      "updates": {
        "type": "object",
        "description": "The column properties to update, e.g. { \"displayName\": \"New Name\" }."
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_id",
      "column_id",
      "updates"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_update\_site\_list\_item

Update a SharePoint list item

**Parameters:**

| Parameter | Type   | Required | Default | Description                                                         |
| --------- | ------ | -------- | ------- | ------------------------------------------------------------------- |
| `site_id` | string | Yes      | —       | The unique ID of the SharePoint site                                |
| `list_id` | string | Yes      | —       | The unique ID of the SharePoint list                                |
| `item_id` | string | Yes      | —       | The unique ID of the list item to update                            |
| `fields`  | object | No       | —       | Field values to update. Only include the fields you want to change. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "site_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint site"
      },
      "list_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint list"
      },
      "item_id": {
        "type": "string",
        "description": "The unique ID of the list item to update"
      },
      "fields": {
        "type": "object",
        "description": "Field values to update. Only include the fields you want to change."
      }
    },
    "required": [
      "PCID",
      "site_id",
      "list_id",
      "item_id"
    ]
  }
  ```
</Expandable>

***

## microsoft-365-sites\_upload\_file

Upload a file to a SharePoint document library at the given path. Provide the file content as a base64-encoded string. Creates the file or replaces it if one already exists at that path.

**Parameters:**

| Parameter        | Type   | Required | Default | Description                                                                                                                          |
| ---------------- | ------ | -------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------ |
| `drive_id`       | string | Yes      | —       | The unique ID of the SharePoint document library (drive). Get it from list\_drives or get\_site\_drive.                              |
| `path`           | string | Yes      | —       | Destination path in the drive including the filename, e.g. "report.pdf" for the root or "Documents/2024/report.pdf" for a subfolder. |
| `content_base64` | string | Yes      | —       | The file content, encoded as a base64 string.                                                                                        |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "drive_id": {
        "type": "string",
        "description": "The unique ID of the SharePoint document library (drive). Get it from list_drives or get_site_drive."
      },
      "path": {
        "type": "string",
        "description": "Destination path in the drive including the filename, e.g. \"report.pdf\" for the root or \"Documents/2024/report.pdf\" for a subfolder."
      },
      "content_base64": {
        "type": "string",
        "description": "The file content, encoded as a base64 string."
      }
    },
    "required": [
      "PCID",
      "drive_id",
      "path",
      "content_base64"
    ]
  }
  ```
</Expandable>