sharepoint

Sites, lists, and document libraries

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

Tools

Tool	Description
sharepoint_add_list_item	Add list item to a sharepoint list
sharepoint_copy_item	Copy file/folder item in a sharepoint drive or document library to a new parent folder
sharepoint_create_column	Create column in sharepoint list with siteId & listId. Supported types: text, dateTime, number, choice, boolean
sharepoint_create_folder	Create folder in a sharepoint drive or document library
sharepoint_create_list	Create a new list in the specified sharepoint id
sharepoint_delete_column	Delete column in sharepoint list
sharepoint_delete_item	Delete file or folder item from a sharepoint drive or document library
sharepoint_delete_list	Delete sharepoint list from a siteId given its listId
sharepoint_delete_list_item	Delete list item
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_get_item_by_path	Get item by path in a sharepoint drive or document library
sharepoint_get_list_by_name	Get list by name and site id in sharepoint
sharepoint_get_list_item	Get item by itemId from a sharepoint list
sharepoint_get_list_items	Batch get list items in SharePoint
sharepoint_get_list_schema	Get list schema (columns) for a listId & siteId in sharepoint
sharepoint_get_lists	List all lists in the specified site
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_drives	Get all document libraries(drives) in the specified site
sharepoint_list_folder_contents	List folder contents in a sharepoint drive or document library. If itemId not provided, gets root folder contents.
sharepoint_list_sites	List all available sites for specified Pink Connect ID
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_move_item	Move file/folder item in a sharepoint drive or document library to a new parent folder
sharepoint_search_sites_by_query	Searches sites for the specified Pink Connect ID by query
sharepoint_update_column	Update column (rename, etc.) in sharepoint list
sharepoint_update_item_metadata	Update file/folder metadata in a sharepoint drive or document library
sharepoint_update_list_item	Update list item in a sharepoint list
sharepoint_upload_file	Upload file to a sharepoint drive or document library folder path

---

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

Show inputSchema

{
  "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"
  ]
}

---

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)

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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.

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "siteId": {
      "type": "string",
      "description": "Site ID to get lists from"
    }
  },
  "required": [
    "PCID",
    "siteId"
  ]
}

---

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>]

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "siteId": {
      "type": "string",
      "description": "Site ID to list drives from"
    }
  },
  "required": [
    "PCID",
    "siteId"
  ]
}

---

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)

Show inputSchema

{
  "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"
  ]
}

---

sharepoint_list_sites

List all available sites for specified Pink Connect ID

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    }
  },
  "required": [
    "PCID"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "query": {
      "type": "string",
      "description": "Query to search for sites"
    }
  },
  "required": [
    "PCID",
    "query"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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.

Show inputSchema

{
  "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"
  ]
}