What can you do with it?
SharePoint enables you to manage your organization’s documents, lists, and sites programmatically. You can search for sites, create and manage lists with custom columns, add and update list items, upload and download documents, organize files in folders, share documents with links, and manage site content. This integration is perfect for document management workflows, automated list operations, content organization, and building collaborative applications that interact with SharePoint sites.
How to use it?
Basic Command Structure
/your-SharePoint-connection [action] [required-parameters] [optional-parameters]
Parameters
Required:
action
- The operation to perform with SharePoint
pc-connection-id
- Your PinkConnect SharePoint connection ID
List Sites
Search for SharePoint sites by name or list all sites
Parameters:
search-term
(optional) - Site name to search for
Example:
/your-SharePoint-connection
action: list-sites
pc-connection-id: your-connection-id
Response:
[
{
"name": "Team Site",
"url": "https://company.sharepoint.com/sites/team",
"siteId": "company.sharepoint.com,4d8b95a0-8ed5-4cab-9cfb-4e7fe277556b,12345678-1234-1234-1234-123456789012",
"description": "Main team collaboration site"
}
]
Get Site Lists
Retrieve all lists in a SharePoint site
Parameters:
site-id
(required) - The ID of the SharePoint site
Example:
/your-SharePoint-connection
action: get-site-lists
pc-connection-id: your-connection-id
site-id: company.sharepoint.com,4d8b95a0-8ed5-4cab-9cfb-4e7fe277556b,12345678-1234-1234-1234-123456789012
Response:
{
"value": [
{
"id": "list-guid-123",
"displayName": "Project Tasks",
"description": "Track project tasks and assignments",
"createdDateTime": "2024-01-15T10:30:00Z"
}
]
}
Create List
Create a new list in a SharePoint site
Parameters:
site-id
(required) - The ID of the SharePoint site
list-name
(required) - Name for the new list
list-template
(required) - Template type (genericList, tasks, events, announcements)
columns
(optional) - Array of column definitions
Example:
/your-SharePoint-connection
action: create-list
pc-connection-id: your-connection-id
site-id: company.sharepoint.com,4d8b95a0-8ed5-4cab-9cfb-4e7fe277556b,12345678-1234-1234-1234-123456789012
list-name: Customer Feedback
list-template: genericList
Response:
{
"id": "new-list-guid-456",
"displayName": "Customer Feedback",
"createdDateTime": "2024-03-20T14:15:00Z",
"list": {
"template": "genericList"
}
}
Get List Items
Retrieve all items from a SharePoint list
Parameters:
site-id
(required) - The ID of the SharePoint site
list-id
(required) - The ID of the list
Example:
/your-SharePoint-connection
action: get-list-items
pc-connection-id: your-connection-id
site-id: company.sharepoint.com,4d8b95a0-8ed5-4cab-9cfb-4e7fe277556b,12345678-1234-1234-1234-123456789012
list-id: list-guid-123
Response:
{
"value": [
{
"id": "1",
"fields": {
"Title": "Complete documentation",
"Status": "In Progress",
"AssignedTo": "John Doe",
"DueDate": "2024-03-25"
}
}
]
}
Add List Item
Create a new item in a SharePoint list
Parameters:
site-id
(required) - The ID of the SharePoint site
list-id
(required) - The ID of the list
fields
(required) - Object containing field values
Example:
/your-SharePoint-connection
action: add-list-item
pc-connection-id: your-connection-id
site-id: company.sharepoint.com,4d8b95a0-8ed5-4cab-9cfb-4e7fe277556b,12345678-1234-1234-1234-123456789012
list-id: list-guid-123
fields: {"Title": "New Task", "Status": "Not Started", "Priority": "High"}
Response:
{
"id": "2",
"fields": {
"Title": "New Task",
"Status": "Not Started",
"Priority": "High",
"Created": "2024-03-20T15:30:00Z"
}
}
Upload Document
Upload a file to a SharePoint document library
Parameters:
site-id
(required) - The ID of the SharePoint site
file-path
(required) - Destination path for the file
content
(required) - Binary content of the file
Example:
/your-SharePoint-connection
action: upload-document
pc-connection-id: your-connection-id
site-id: company.sharepoint.com,4d8b95a0-8ed5-4cab-9cfb-4e7fe277556b,12345678-1234-1234-1234-123456789012
file-path: /Shared Documents/Reports/Q1-Report.pdf
content: [binary content]
Response:
{
"id": "doc-guid-789",
"name": "Q1-Report.pdf",
"size": 1048576,
"webUrl": "https://company.sharepoint.com/sites/team/Shared%20Documents/Reports/Q1-Report.pdf",
"createdDateTime": "2024-03-20T16:00:00Z"
}
Download Document
Download a file from SharePoint
Parameters:
site-id
(required) - The ID of the SharePoint site
item-id
(required) - The ID of the document
Example:
/your-SharePoint-connection
action: download-document
pc-connection-id: your-connection-id
site-id: company.sharepoint.com,4d8b95a0-8ed5-4cab-9cfb-4e7fe277556b,12345678-1234-1234-1234-123456789012
item-id: doc-guid-789
Response:
{
"status": "downloaded",
"filename": "Q1-Report.pdf",
"size": 1048576,
"contentType": "application/pdf"
}
Create Folder
Create a new folder in SharePoint
Parameters:
site-id
(required) - The ID of the SharePoint site
parent-id
(required) - The ID of the parent folder (use root for top level)
folder-name
(required) - Name for the new folder
Example:
/your-SharePoint-connection
action: create-folder
pc-connection-id: your-connection-id
site-id: company.sharepoint.com,4d8b95a0-8ed5-4cab-9cfb-4e7fe277556b,12345678-1234-1234-1234-123456789012
parent-id: root
folder-name: 2024 Projects
Response:
{
"id": "folder-guid-321",
"name": "2024 Projects",
"folder": {
"childCount": 0
},
"webUrl": "https://company.sharepoint.com/sites/team/Shared%20Documents/2024%20Projects"
}
Create Share Link
Generate a shareable link for a document
Parameters:
site-id
(required) - The ID of the SharePoint site
item-id
(required) - The ID of the document
link-type
(optional) - Type of link: view or edit (default: view)
scope
(optional) - Link scope: anonymous or organization (default: anonymous)
Example:
/your-SharePoint-connection
action: create-share-link
pc-connection-id: your-connection-id
site-id: company.sharepoint.com,4d8b95a0-8ed5-4cab-9cfb-4e7fe277556b,12345678-1234-1234-1234-123456789012
item-id: doc-guid-789
link-type: view
scope: anonymous
Response:
{
"id": "share-link-123",
"link": {
"type": "view",
"scope": "anonymous",
"webUrl": "https://company.sharepoint.com/:b:/s/team/EaBC123..."
},
"hasPassword": false,
"expirationDateTime": null
}
Notes
SharePoint uses MCP (Model Context Protocol) tools for most operations. A PinkConnect connection ID is required for all operations. Site IDs have a specific format containing hostname, site GUID, and web GUID separated by commas. List templates include genericList, tasks, events, and announcements. Both document libraries and custom lists are supported. The integration supports file operations, list management, and sharing capabilities.