Skip to main content
Server path: /sharepoint | Type: Application | PCID required: Yes Sites, lists, and document libraries

Tools

ToolDescription
sharepoint_list_sitesList all available sites for specified Pink Connect ID
sharepoint_search_sites_by_querySearches sites for the specified Pink Connect ID by query
sharepoint_get_root_site_from_urlExtract 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_siteList 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_drivesGet all document libraries(drives) in the specified site
sharepoint_list_folder_contentsList folder contents in a sharepoint drive or document library. If itemId not provided, gets root folder contents.
sharepoint_get_item_by_pathGet item by path in a sharepoint drive or document library
sharepoint_upload_fileUpload file to a sharepoint drive or document library folder path
sharepoint_download_fileDownload 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_folderCreate folder in a sharepoint drive or document library
sharepoint_update_item_metadataUpdate file/folder metadata in a sharepoint drive or document library
sharepoint_delete_itemDelete file or folder item from a sharepoint drive or document library
sharepoint_move_itemMove file/folder item in a sharepoint drive or document library to a new parent folder
sharepoint_copy_itemCopy file/folder item in a sharepoint drive or document library to a new parent folder
sharepoint_get_listsList all lists in the specified site
sharepoint_get_list_itemsBatch get list items in SharePoint
sharepoint_create_listCreate a new list in the specified sharepoint id
sharepoint_get_list_by_nameGet list by name and site id in sharepoint
sharepoint_get_list_schemaGet list schema (columns) for a listId & siteId in sharepoint
sharepoint_create_columnCreate column in sharepoint list with siteId & listId. Supported types: text, dateTime, number, choice, boolean
sharepoint_update_columnUpdate column (rename, etc.) in sharepoint list
sharepoint_delete_columnDelete column in sharepoint list
sharepoint_add_list_itemAdd list item to a sharepoint list
sharepoint_get_list_itemGet item by itemId from a sharepoint list
sharepoint_update_list_itemUpdate list item in a sharepoint list
sharepoint_delete_list_itemDelete list item
sharepoint_delete_listDelete sharepoint list from a siteId given its listId

sharepoint_list_sites

List all available sites for specified Pink Connect ID

sharepoint_search_sites_by_query

Searches sites for the specified Pink Connect ID by query Parameters:
ParameterTypeRequiredDefaultDescription
querystringYesQuery to search for sites

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:
ParameterTypeRequiredDefaultDescription
sharePointUrlstringYesDirect subsite URL: https://<tenant>.sharepoint.com/<RootSite>/<SubSite>[/<Drive>]

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:
ParameterTypeRequiredDefaultDescription
rootSiteIdstringYesRoot site ID returned by sharepoint_get_root_site_from_url

sharepoint_list_drives

Get all document libraries(drives) in the specified site Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID to list drives from

sharepoint_list_folder_contents

List folder contents in a sharepoint drive or document library. If itemId not provided, gets root folder contents. Parameters:
ParameterTypeRequiredDefaultDescription
driveIdstringYesDrive ID containing the folder
itemIdstringNoFolder item ID to list contents from (optional, defaults to root folder)

sharepoint_get_item_by_path

Get item by path in a sharepoint drive or document library Parameters:
ParameterTypeRequiredDefaultDescription
driveIdstringYesDrive ID to get item from
folderPathstringYesPath to the item in the drive

sharepoint_upload_file

Upload file to a sharepoint drive or document library folder path Parameters:
ParameterTypeRequiredDefaultDescription
driveIdstringYesDrive ID to upload file to
folderPathstringNoFolder path where to upload the file
fileUrlstringNoURL of the file to upload
filenamestringNo[DEPRECATED] URL of the file to upload. Use fileUrl instead. This parameter will be removed in a future version.

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:
ParameterTypeRequiredDefaultDescription
driveIdstringYesDrive ID to download file from
itemIdstringYesItem ID of the file to download
streambooleanNotrueRECOMMENDED: true (default). Returns a downloadUrl + auth headers for efficient streaming. Set to false only for small files (<2MB) requiring immediate base64 content.
extractTextbooleanNotrueAutomatically 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.

sharepoint_create_folder

Create folder in a sharepoint drive or document library Parameters:
ParameterTypeRequiredDefaultDescription
driveIdstringYesDrive ID to create folder in
parentIdstringNoParent folder ID where to create the new folder (optional, defaults to root)
folderNamestringYesName of the folder to create

sharepoint_update_item_metadata

Update file/folder metadata in a sharepoint drive or document library Parameters:
ParameterTypeRequiredDefaultDescription
driveIdstringYesDrive ID containing the item
itemIdstringYesItem ID to update
metadataobjectYesMetadata to update on the item

sharepoint_delete_item

Delete file or folder item from a sharepoint drive or document library Parameters:
ParameterTypeRequiredDefaultDescription
driveIdstringYesDrive ID containing the item
itemIdstringYesItem ID to delete

sharepoint_move_item

Move file/folder item in a sharepoint drive or document library to a new parent folder Parameters:
ParameterTypeRequiredDefaultDescription
driveIdstringYesDrive ID containing the item
itemIdstringYesItem ID to move
parentReferenceobjectYesReference to the target parent folder

sharepoint_copy_item

Copy file/folder item in a sharepoint drive or document library to a new parent folder Parameters:
ParameterTypeRequiredDefaultDescription
driveIdstringYesDrive ID containing the item
itemIdstringYesItem ID to copy
parentReferenceobjectNoReference to the target parent folder
namestringNoName for the copied item (optional)

sharepoint_get_lists

List all lists in the specified site Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID to get lists from

sharepoint_get_list_items

Batch get list items in SharePoint Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID to get list items from
listIdstringYesList ID to get items from

sharepoint_create_list

Create a new list in the specified sharepoint id Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID to create the list in
displayNamestringYesName of the list to create
descriptionstringNoDescription of the list to create
templatestringNoThe template of the list to create
columnsany[]NoColumns to create in the list

sharepoint_get_list_by_name

Get list by name and site id in sharepoint Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID containing the list
listNamestringYesName of the list to get

sharepoint_get_list_schema

Get list schema (columns) for a listId & siteId in sharepoint Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID containing the list
listIdstringYesList ID to get schema from

sharepoint_create_column

Create column in sharepoint list with siteId & listId. Supported types: text, dateTime, number, choice, boolean Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID containing the list
listIdstringYesList ID to create column in
columnDefinitionstringYesColumn definition object with type-specific properties or JSON string

sharepoint_update_column

Update column (rename, etc.) in sharepoint list Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID containing the list
listIdstringYesList ID containing the column
columnIdstringYesColumn ID to update
updatesobjectYesUpdates to apply to the column

sharepoint_delete_column

Delete column in sharepoint list Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID containing the list
listIdstringYesList ID containing the column
columnIdstringYesColumn ID to delete

sharepoint_add_list_item

Add list item to a sharepoint list Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID containing the list
listIdstringYesList ID to add item to
fieldsobjectYesFields for the new list item

sharepoint_get_list_item

Get item by itemId from a sharepoint list Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID containing the list
listIdstringYesList ID containing the item
itemIdstringYesItem ID to get

sharepoint_update_list_item

Update list item in a sharepoint list Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID containing the list
listIdstringYesList ID containing the item
itemIdstringYesItem ID to update
fieldsobjectYesFields to update on the list item

sharepoint_delete_list_item

Delete list item Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID containing the list
listIdstringYesList ID containing the item
itemIdstringYesItem ID to delete

sharepoint_delete_list

Delete sharepoint list from a siteId given its listId Parameters:
ParameterTypeRequiredDefaultDescription
siteIdstringYesSite ID containing the list
listIdstringYesList ID to delete