> ## 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.

# sharepoint

> Sites, lists, and document libraries

**Server path:** `/sharepoint` | **Type:** Application | **PCID required:** Yes

## Tools

| Tool                                                                                | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| ----------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| [`sharepoint_list_sites`](#sharepoint_list_sites)                                   | List all available sites for specified Pink Connect ID                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| [`sharepoint_search_sites_by_query`](#sharepoint_search_sites_by_query)             | Searches sites for the specified Pink Connect ID by query                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| [`sharepoint_get_root_site_from_url`](#sharepoint_get_root_site_from_url)           | Extract root site ID from subsite URLs. Only accepts direct paths: https\://\<tenant>.sharepoint.com/\<RootSite>/\<SubSite>\[/\<Drive>] (excludes /sites/ and /teams/ collections).                                                                                                                                                                                                                                                                                                                    |
| [`sharepoint_list_subsites_for_root_site`](#sharepoint_list_subsites_for_root_site) | List all subsites under a root site identified by rootSiteId. The rootSiteId should come from a custom-root URL (not /sites or /teams) obtained via sharepoint\_get\_root\_site\_from\_url.                                                                                                                                                                                                                                                                                                            |
| [`sharepoint_list_drives`](#sharepoint_list_drives)                                 | Get all document libraries(drives) in the specified site                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| [`sharepoint_list_folder_contents`](#sharepoint_list_folder_contents)               | List folder contents in a sharepoint drive or document library. If itemId not provided, gets root folder contents.                                                                                                                                                                                                                                                                                                                                                                                     |
| [`sharepoint_get_item_by_path`](#sharepoint_get_item_by_path)                       | Get item by path in a sharepoint drive or document library                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| [`sharepoint_upload_file`](#sharepoint_upload_file)                                 | Upload file to a sharepoint drive or document library folder path                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| [`sharepoint_download_file`](#sharepoint_download_file)                             | Download file from SharePoint. IN WORKFLOWS: Files are automatically saved to Node Outputs - no manual save step needed. By default, automatically extracts text from supported document formats (PDF, DOCX, PPTX, XLSX) and includes it in the response. Text files (TXT, CSV) do not need extraction. STREAMING IS PREFERRED: Use stream=true (default) to get a downloadUrl for efficient downloading of large files. Only use stream=false for small files (\<2MB) that need immediate processing. |
| [`sharepoint_create_folder`](#sharepoint_create_folder)                             | Create folder in a sharepoint drive or document library                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| [`sharepoint_update_item_metadata`](#sharepoint_update_item_metadata)               | Update file/folder metadata in a sharepoint drive or document library                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| [`sharepoint_delete_item`](#sharepoint_delete_item)                                 | Delete file or folder item from a sharepoint drive or document library                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| [`sharepoint_move_item`](#sharepoint_move_item)                                     | Move file/folder item in a sharepoint drive or document library to a new parent folder                                                                                                                                                                                                                                                                                                                                                                                                                 |
| [`sharepoint_copy_item`](#sharepoint_copy_item)                                     | Copy file/folder item in a sharepoint drive or document library to a new parent folder                                                                                                                                                                                                                                                                                                                                                                                                                 |
| [`sharepoint_get_lists`](#sharepoint_get_lists)                                     | List all lists in the specified site                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| [`sharepoint_get_list_items`](#sharepoint_get_list_items)                           | Batch get list items in SharePoint                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| [`sharepoint_create_list`](#sharepoint_create_list)                                 | Create a new list in the specified sharepoint id                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| [`sharepoint_get_list_by_name`](#sharepoint_get_list_by_name)                       | Get list by name and site id in sharepoint                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| [`sharepoint_get_list_schema`](#sharepoint_get_list_schema)                         | Get list schema (columns) for a listId & siteId in sharepoint                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| [`sharepoint_create_column`](#sharepoint_create_column)                             | Create column in sharepoint list with siteId & listId. Supported types: text, dateTime, number, choice, boolean                                                                                                                                                                                                                                                                                                                                                                                        |
| [`sharepoint_update_column`](#sharepoint_update_column)                             | Update column (rename, etc.) in sharepoint list                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [`sharepoint_delete_column`](#sharepoint_delete_column)                             | Delete column in sharepoint list                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| [`sharepoint_add_list_item`](#sharepoint_add_list_item)                             | Add list item to a sharepoint list                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| [`sharepoint_get_list_item`](#sharepoint_get_list_item)                             | Get item by itemId from a sharepoint list                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| [`sharepoint_update_list_item`](#sharepoint_update_list_item)                       | Update list item in a sharepoint list                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| [`sharepoint_delete_list_item`](#sharepoint_delete_list_item)                       | Delete list item                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| [`sharepoint_delete_list`](#sharepoint_delete_list)                                 | Delete sharepoint list from a siteId given its listId                                                                                                                                                                                                                                                                                                                                                                                                                                                  |

***

## sharepoint\_list\_sites

List all available sites for specified Pink Connect ID

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_search\_sites\_by\_query

Searches sites for the specified Pink Connect ID by query

**Parameters:**

| Parameter | Type   | Required | Default | Description               |
| --------- | ------ | -------- | ------- | ------------------------- |
| `query`   | string | Yes      | —       | Query to search for sites |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "query": {
        "type": "string",
        "description": "Query to search for sites"
      }
    },
    "required": [
      "PCID",
      "query"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_get\_root\_site\_from\_url

Extract root site ID from subsite URLs. Only accepts direct paths: https\://\<tenant>.sharepoint.com/\<RootSite>/\<SubSite>\[/\<Drive>] (excludes /sites/ and /teams/ collections).

**Parameters:**

| Parameter       | Type   | Required | Default | Description                                                                              |
| --------------- | ------ | -------- | ------- | ---------------------------------------------------------------------------------------- |
| `sharePointUrl` | string | Yes      | —       | Direct subsite URL: https\://\<tenant>.sharepoint.com/\<RootSite>/\<SubSite>\[/\<Drive>] |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "sharePointUrl": {
        "type": "string",
        "description": "Direct subsite URL: https://<tenant>.sharepoint.com/<RootSite>/<SubSite>[/<Drive>]"
      }
    },
    "required": [
      "PCID",
      "sharePointUrl"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_list\_subsites\_for\_root\_site

List all subsites under a root site identified by rootSiteId. The rootSiteId should come from a custom-root URL (not /sites or /teams) obtained via sharepoint\_get\_root\_site\_from\_url.

**Parameters:**

| Parameter    | Type   | Required | Default | Description                                                     |
| ------------ | ------ | -------- | ------- | --------------------------------------------------------------- |
| `rootSiteId` | string | Yes      | —       | Root site ID returned by sharepoint\_get\_root\_site\_from\_url |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "rootSiteId": {
        "type": "string",
        "description": "Root site ID returned by sharepoint_get_root_site_from_url"
      }
    },
    "required": [
      "PCID",
      "rootSiteId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_list\_drives

Get all document libraries(drives) in the specified site

**Parameters:**

| Parameter | Type   | Required | Default | Description                 |
| --------- | ------ | -------- | ------- | --------------------------- |
| `siteId`  | string | Yes      | —       | Site ID to list drives from |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID to list drives from"
      }
    },
    "required": [
      "PCID",
      "siteId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_list\_folder\_contents

List folder contents in a sharepoint drive or document library. If itemId not provided, gets root folder contents.

**Parameters:**

| Parameter | Type   | Required | Default | Description                                                              |
| --------- | ------ | -------- | ------- | ------------------------------------------------------------------------ |
| `driveId` | string | Yes      | —       | Drive ID containing the folder                                           |
| `itemId`  | string | No       | —       | Folder item ID to list contents from (optional, defaults to root folder) |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "driveId": {
        "type": "string",
        "description": "Drive ID containing the folder"
      },
      "itemId": {
        "type": "string",
        "description": "Folder item ID to list contents from (optional, defaults to root folder)"
      }
    },
    "required": [
      "PCID",
      "driveId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_get\_item\_by\_path

Get item by path in a sharepoint drive or document library

**Parameters:**

| Parameter    | Type   | Required | Default | Description                   |
| ------------ | ------ | -------- | ------- | ----------------------------- |
| `driveId`    | string | Yes      | —       | Drive ID to get item from     |
| `folderPath` | string | Yes      | —       | Path to the item in the drive |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "driveId": {
        "type": "string",
        "description": "Drive ID to get item from"
      },
      "folderPath": {
        "type": "string",
        "description": "Path to the item in the drive"
      }
    },
    "required": [
      "PCID",
      "driveId",
      "folderPath"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_upload\_file

Upload file to a sharepoint drive or document library folder path

**Parameters:**

| Parameter    | Type   | Required | Default | Description                                                                                                       |
| ------------ | ------ | -------- | ------- | ----------------------------------------------------------------------------------------------------------------- |
| `driveId`    | string | Yes      | —       | Drive ID to upload file to                                                                                        |
| `folderPath` | string | No       | —       | Folder path where to upload the file                                                                              |
| `fileUrl`    | string | No       | —       | URL of the file to upload                                                                                         |
| `filename`   | string | No       | —       | \[DEPRECATED] URL of the file to upload. Use fileUrl instead. This parameter will be removed in a future version. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "driveId": {
        "type": "string",
        "description": "Drive ID to upload file to"
      },
      "folderPath": {
        "type": "string",
        "description": "Folder path where to upload the file"
      },
      "fileUrl": {
        "type": "string",
        "description": "URL of the file to upload"
      },
      "filename": {
        "type": "string",
        "description": "[DEPRECATED] URL of the file to upload. Use fileUrl instead. This parameter will be removed in a future version."
      }
    },
    "required": [
      "PCID",
      "driveId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_download\_file

Download file from SharePoint. IN WORKFLOWS: Files are automatically saved to Node Outputs - no manual save step needed. By default, automatically extracts text from supported document formats (PDF, DOCX, PPTX, XLSX) and includes it in the response. Text files (TXT, CSV) do not need extraction. STREAMING IS PREFERRED: Use stream=true (default) to get a downloadUrl for efficient downloading of large files. Only use stream=false for small files (\<2MB) that need immediate processing.

**Parameters:**

| Parameter     | Type    | Required | Default | Description                                                                                                                                                                     |
| ------------- | ------- | -------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `driveId`     | string  | Yes      | —       | Drive ID to download file from                                                                                                                                                  |
| `itemId`      | string  | Yes      | —       | Item ID of the file to download                                                                                                                                                 |
| `stream`      | boolean | No       | `true`  | RECOMMENDED: true (default). Returns a downloadUrl + auth headers for efficient streaming. Set to false only for small files (\<2MB) requiring immediate base64 content.        |
| `extractText` | boolean | No       | `true`  | Automatically extracts text from supported formats (PDF, DOCX, PPTX, XLSX) and includes it in the response. Text files do not need extraction. Set to false to skip extraction. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "driveId": {
        "type": "string",
        "description": "Drive ID to download file from"
      },
      "itemId": {
        "type": "string",
        "description": "Item ID of the file to download"
      },
      "stream": {
        "type": "boolean",
        "default": true,
        "description": "RECOMMENDED: true (default). Returns a downloadUrl + auth headers for efficient streaming. Set to false only for small files (<2MB) requiring immediate base64 content."
      },
      "extractText": {
        "type": "boolean",
        "default": true,
        "description": "Automatically extracts text from supported formats (PDF, DOCX, PPTX, XLSX) and includes it in the response. Text files do not need extraction. Set to false to skip extraction."
      }
    },
    "required": [
      "PCID",
      "driveId",
      "itemId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_create\_folder

Create folder in a sharepoint drive or document library

**Parameters:**

| Parameter    | Type   | Required | Default | Description                                                                  |
| ------------ | ------ | -------- | ------- | ---------------------------------------------------------------------------- |
| `driveId`    | string | Yes      | —       | Drive ID to create folder in                                                 |
| `parentId`   | string | No       | —       | Parent folder ID where to create the new folder (optional, defaults to root) |
| `folderName` | string | Yes      | —       | Name of the folder to create                                                 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "driveId": {
        "type": "string",
        "description": "Drive ID to create folder in"
      },
      "parentId": {
        "type": "string",
        "description": "Parent folder ID where to create the new folder (optional, defaults to root)"
      },
      "folderName": {
        "type": "string",
        "description": "Name of the folder to create"
      }
    },
    "required": [
      "PCID",
      "driveId",
      "folderName"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_update\_item\_metadata

Update file/folder metadata in a sharepoint drive or document library

**Parameters:**

| Parameter  | Type   | Required | Default | Description                    |
| ---------- | ------ | -------- | ------- | ------------------------------ |
| `driveId`  | string | Yes      | —       | Drive ID containing the item   |
| `itemId`   | string | Yes      | —       | Item ID to update              |
| `metadata` | object | Yes      | —       | Metadata to update on the item |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "driveId": {
        "type": "string",
        "description": "Drive ID containing the item"
      },
      "itemId": {
        "type": "string",
        "description": "Item ID to update"
      },
      "metadata": {
        "type": "object",
        "additionalProperties": true,
        "description": "Metadata to update on the item"
      }
    },
    "required": [
      "PCID",
      "driveId",
      "itemId",
      "metadata"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_delete\_item

Delete file or folder item from a sharepoint drive or document library

**Parameters:**

| Parameter | Type   | Required | Default | Description                  |
| --------- | ------ | -------- | ------- | ---------------------------- |
| `driveId` | string | Yes      | —       | Drive ID containing the item |
| `itemId`  | string | Yes      | —       | Item ID to delete            |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "driveId": {
        "type": "string",
        "description": "Drive ID containing the item"
      },
      "itemId": {
        "type": "string",
        "description": "Item ID to delete"
      }
    },
    "required": [
      "PCID",
      "driveId",
      "itemId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_move\_item

Move file/folder item in a sharepoint drive or document library to a new parent folder

**Parameters:**

| Parameter         | Type   | Required | Default | Description                           |
| ----------------- | ------ | -------- | ------- | ------------------------------------- |
| `driveId`         | string | Yes      | —       | Drive ID containing the item          |
| `itemId`          | string | Yes      | —       | Item ID to move                       |
| `parentReference` | object | Yes      | —       | Reference to the target parent folder |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "driveId": {
        "type": "string",
        "description": "Drive ID containing the item"
      },
      "itemId": {
        "type": "string",
        "description": "Item ID to move"
      },
      "parentReference": {
        "type": "object",
        "properties": {
          "driveId": {
            "type": "string",
            "description": "Target drive ID (optional)"
          },
          "folderId": {
            "type": "string",
            "description": "Target parent folder ID"
          }
        },
        "description": "Reference to the target parent folder"
      }
    },
    "required": [
      "PCID",
      "driveId",
      "itemId",
      "parentReference"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_copy\_item

Copy file/folder item in a sharepoint drive or document library to a new parent folder

**Parameters:**

| Parameter         | Type   | Required | Default | Description                           |
| ----------------- | ------ | -------- | ------- | ------------------------------------- |
| `driveId`         | string | Yes      | —       | Drive ID containing the item          |
| `itemId`          | string | Yes      | —       | Item ID to copy                       |
| `parentReference` | object | No       | —       | Reference to the target parent folder |
| `name`            | string | No       | —       | Name for the copied item (optional)   |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "driveId": {
        "type": "string",
        "description": "Drive ID containing the item"
      },
      "itemId": {
        "type": "string",
        "description": "Item ID to copy"
      },
      "parentReference": {
        "type": "object",
        "properties": {
          "driveId": {
            "type": "string",
            "description": "Target drive ID (optional)"
          },
          "folderId": {
            "type": "string",
            "description": "Target parent folder ID"
          }
        },
        "description": "Reference to the target parent folder"
      },
      "name": {
        "type": "string",
        "description": "Name for the copied item (optional)"
      }
    },
    "required": [
      "PCID",
      "driveId",
      "itemId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_get\_lists

List all lists in the specified site

**Parameters:**

| Parameter | Type   | Required | Default | Description               |
| --------- | ------ | -------- | ------- | ------------------------- |
| `siteId`  | string | Yes      | —       | Site ID to get lists from |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID to get lists from"
      }
    },
    "required": [
      "PCID",
      "siteId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_get\_list\_items

Batch get list items in SharePoint

**Parameters:**

| Parameter | Type   | Required | Default | Description                    |
| --------- | ------ | -------- | ------- | ------------------------------ |
| `siteId`  | string | Yes      | —       | Site ID to get list items from |
| `listId`  | string | Yes      | —       | List ID to get items from      |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID to get list items from"
      },
      "listId": {
        "type": "string",
        "description": "List ID to get items from"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "listId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_create\_list

Create a new list in the specified sharepoint id

**Parameters:**

| Parameter     | Type   | Required | Default | Description                        |
| ------------- | ------ | -------- | ------- | ---------------------------------- |
| `siteId`      | string | Yes      | —       | Site ID to create the list in      |
| `displayName` | string | Yes      | —       | Name of the list to create         |
| `description` | string | No       | —       | Description of the list to create  |
| `template`    | string | No       | —       | The template of the list to create |
| `columns`     | any\[] | No       | —       | Columns to create in the list      |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID to create the list in"
      },
      "displayName": {
        "type": "string",
        "description": "Name of the list to create"
      },
      "description": {
        "type": "string",
        "description": "Description of the list to create"
      },
      "template": {
        "type": "string",
        "description": "The template of the list to create"
      },
      "columns": {
        "type": "array",
        "items": {
          "type": "discriminatedunion"
        },
        "description": "Columns to create in the list"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "displayName"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_get\_list\_by\_name

Get list by name and site id in sharepoint

**Parameters:**

| Parameter  | Type   | Required | Default | Description                 |
| ---------- | ------ | -------- | ------- | --------------------------- |
| `siteId`   | string | Yes      | —       | Site ID containing the list |
| `listName` | string | Yes      | —       | Name of the list to get     |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID containing the list"
      },
      "listName": {
        "type": "string",
        "description": "Name of the list to get"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "listName"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_get\_list\_schema

Get list schema (columns) for a listId & siteId in sharepoint

**Parameters:**

| Parameter | Type   | Required | Default | Description                 |
| --------- | ------ | -------- | ------- | --------------------------- |
| `siteId`  | string | Yes      | —       | Site ID containing the list |
| `listId`  | string | Yes      | —       | List ID to get schema from  |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID containing the list"
      },
      "listId": {
        "type": "string",
        "description": "List ID to get schema from"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "listId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_create\_column

Create column in sharepoint list with siteId & listId. Supported types: text, dateTime, number, choice, boolean

**Parameters:**

| Parameter          | Type   | Required | Default | Description                                                           |
| ------------------ | ------ | -------- | ------- | --------------------------------------------------------------------- |
| `siteId`           | string | Yes      | —       | Site ID containing the list                                           |
| `listId`           | string | Yes      | —       | List ID to create column in                                           |
| `columnDefinition` | string | Yes      | —       | Column definition object with type-specific properties or JSON string |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID containing the list"
      },
      "listId": {
        "type": "string",
        "description": "List ID to create column in"
      },
      "columnDefinition": {
        "oneOf": [
          {
            "type": "string",
            "description": "Column definition as JSON string"
          },
          {
            "type": "discriminatedunion"
          }
        ],
        "description": "Column definition object with type-specific properties or JSON string"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "listId",
      "columnDefinition"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_update\_column

Update column (rename, etc.) in sharepoint list

**Parameters:**

| Parameter  | Type   | Required | Default | Description                    |
| ---------- | ------ | -------- | ------- | ------------------------------ |
| `siteId`   | string | Yes      | —       | Site ID containing the list    |
| `listId`   | string | Yes      | —       | List ID containing the column  |
| `columnId` | string | Yes      | —       | Column ID to update            |
| `updates`  | object | Yes      | —       | Updates to apply to the column |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID containing the list"
      },
      "listId": {
        "type": "string",
        "description": "List ID containing the column"
      },
      "columnId": {
        "type": "string",
        "description": "Column ID to update"
      },
      "updates": {
        "type": "object",
        "additionalProperties": true,
        "description": "Updates to apply to the column"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "listId",
      "columnId",
      "updates"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_delete\_column

Delete column in sharepoint list

**Parameters:**

| Parameter  | Type   | Required | Default | Description                   |
| ---------- | ------ | -------- | ------- | ----------------------------- |
| `siteId`   | string | Yes      | —       | Site ID containing the list   |
| `listId`   | string | Yes      | —       | List ID containing the column |
| `columnId` | string | Yes      | —       | Column ID to delete           |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID containing the list"
      },
      "listId": {
        "type": "string",
        "description": "List ID containing the column"
      },
      "columnId": {
        "type": "string",
        "description": "Column ID to delete"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "listId",
      "columnId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_add\_list\_item

Add list item to a sharepoint list

**Parameters:**

| Parameter | Type   | Required | Default | Description                  |
| --------- | ------ | -------- | ------- | ---------------------------- |
| `siteId`  | string | Yes      | —       | Site ID containing the list  |
| `listId`  | string | Yes      | —       | List ID to add item to       |
| `fields`  | object | Yes      | —       | Fields for the new list item |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID containing the list"
      },
      "listId": {
        "type": "string",
        "description": "List ID to add item to"
      },
      "fields": {
        "type": "object",
        "additionalProperties": true,
        "description": "Fields for the new list item"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "listId",
      "fields"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_get\_list\_item

Get item by itemId from a sharepoint list

**Parameters:**

| Parameter | Type   | Required | Default | Description                 |
| --------- | ------ | -------- | ------- | --------------------------- |
| `siteId`  | string | Yes      | —       | Site ID containing the list |
| `listId`  | string | Yes      | —       | List ID containing the item |
| `itemId`  | string | Yes      | —       | Item ID to get              |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID containing the list"
      },
      "listId": {
        "type": "string",
        "description": "List ID containing the item"
      },
      "itemId": {
        "type": "string",
        "description": "Item ID to get"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "listId",
      "itemId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_update\_list\_item

Update list item in a sharepoint list

**Parameters:**

| Parameter | Type   | Required | Default | Description                       |
| --------- | ------ | -------- | ------- | --------------------------------- |
| `siteId`  | string | Yes      | —       | Site ID containing the list       |
| `listId`  | string | Yes      | —       | List ID containing the item       |
| `itemId`  | string | Yes      | —       | Item ID to update                 |
| `fields`  | object | Yes      | —       | Fields to update on the list item |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID containing the list"
      },
      "listId": {
        "type": "string",
        "description": "List ID containing the item"
      },
      "itemId": {
        "type": "string",
        "description": "Item ID to update"
      },
      "fields": {
        "type": "object",
        "additionalProperties": true,
        "description": "Fields to update on the list item"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "listId",
      "itemId",
      "fields"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_delete\_list\_item

Delete list item

**Parameters:**

| Parameter | Type   | Required | Default | Description                 |
| --------- | ------ | -------- | ------- | --------------------------- |
| `siteId`  | string | Yes      | —       | Site ID containing the list |
| `listId`  | string | Yes      | —       | List ID containing the item |
| `itemId`  | string | Yes      | —       | Item ID to delete           |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID containing the list"
      },
      "listId": {
        "type": "string",
        "description": "List ID containing the item"
      },
      "itemId": {
        "type": "string",
        "description": "Item ID to delete"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "listId",
      "itemId"
    ]
  }
  ```
</Expandable>

***

## sharepoint\_delete\_list

Delete sharepoint list from a siteId given its listId

**Parameters:**

| Parameter | Type   | Required | Default | Description                 |
| --------- | ------ | -------- | ------- | --------------------------- |
| `siteId`  | string | Yes      | —       | Site ID containing the list |
| `listId`  | string | Yes      | —       | List ID to delete           |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "siteId": {
        "type": "string",
        "description": "Site ID containing the list"
      },
      "listId": {
        "type": "string",
        "description": "List ID to delete"
      }
    },
    "required": [
      "PCID",
      "siteId",
      "listId"
    ]
  }
  ```
</Expandable>