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

Tools

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

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.