# Sharepoint — Pipedream Connect

> Share and manage content, knowledge, and applications to empower teamwork, quickly find information, and seamlessly collaborate across the organization.

- API slug: `sharepoint` (use in MCP headers and tool keys)
- Auth: OAuth (Pipedream-managed)
- Categories: Business Management
- Website: https://www.microsoft.com/en-us/microsoft-365/sharepoint/collaboration
- Managed OAuth scopes: `offline_access` · `email` · `openid` · `User.Read` · `Sites.Read.All` · `Files.Read.All` · `Sites.ReadWrite.All` · `Sites.Manage.All`
- This page (HTML): https://pipedream.com/apps/sharepoint
- Tools: 25 actions · 5 triggers

## Connect via MCP (recommended)

- Endpoint: `https://remote.mcp.pipedream.net/v3`
- Headers: `Authorization: Bearer <token>` · `x-pd-project-id` · `x-pd-environment` · `x-pd-external-user-id` · `x-pd-app-slug: sharepoint`

```ts
import { Client } from "@modelcontextprotocol/sdk/client/index.js"
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp.js"
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const accessToken = await pd.rawAccessToken

const transport = new StreamableHTTPClientTransport(
  new URL("https://remote.mcp.pipedream.net/v3"),
  {
    requestInit: {
      headers: {
        Authorization: `Bearer ${accessToken}`,
        "x-pd-project-id": process.env.PIPEDREAM_PROJECT_ID!,
        "x-pd-environment": "production",
        "x-pd-external-user-id": "{external_user_id}", // any stable ID for this user in your system
        "x-pd-app-slug": "sharepoint",
      },
    },
  },
)

const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)

const { tools } = await mcp.listTools()

// e.g. run Create Folder:
const result = await mcp.callTool({
  name: "sharepoint-create-folder",
  arguments: {
    siteId: "Site",
    driveId: "Drive ID",
  },
})
```

Docs: [MCP guide](https://pipedream.com/docs/connect/mcp/developers.md)

## API proxy

For a Sharepoint endpoint with no pre-built tool, the proxy forwards your request with the connected user's credentials attached.

```bash
# The path segment is the target URL, URL-safe base64 encoded:
# https://graph.microsoft.com/v1.0/me

curl "https://api.pipedream.com/v1/connect/{project_id}/proxy/aHR0cHM6Ly9ncmFwaC5taWNyb3NvZnQuY29tL3YxLjAvbWU?external_user_id={external_user_id}&account_id=apn_xxxxxxx" \
  -H "Authorization: Bearer {access_token}" \
  -H "x-pd-environment: production"
```

Docs: [API proxy guide](https://pipedream.com/docs/connect/api-proxy.md)

## SDK

```ts
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "sharepoint-create-folder",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    sharepoint: { authProvisionId: "apn_xxxxxxx" },
    siteId: "Site",
    driveId: "Drive ID",
  },
})
```

Docs: [Managed auth guide](https://pipedream.com/docs/connect/managed-auth/quickstart.md) · [Tools guide](https://pipedream.com/docs/connect/components.md)

## Actions (25)

### `sharepoint-create-folder` — Create Folder (Write)

Create a new folder in SharePoint. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/create-folder.md

### `sharepoint-create-item` — Create Item (Write)

Create a new item in a SharePoint list. Provide the column names and values for the new item as a fields object. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/create-item.md

### `sharepoint-create-link` — Create Link (Write)

Create a sharing link for a DriveItem. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/create-link.md

### `sharepoint-create-list` — Create List (Write)

Create a new list in Microsoft Sharepoint. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/create-list.md

### `sharepoint-download-file` — Download File (Read-only)

Download a Microsoft Sharepoint file to the /tmp directory. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/download-file.md

### `sharepoint-download-files` — Download Files (Read-only)

Browse and select files from SharePoint and get their metadata along with pre-authenticated download URLs (valid ~1 hour). See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/download-files.md

### `sharepoint-find-file-by-name` — Find File by Name (Read-only)

Search the site's default drive for files or folders matching a query. Matches are recursive across the drive and span filename, metadata, and file content — this is not an exact filename lookup, and results are relevance-ranked.

Full schema: https://pipedream.com/apps/sharepoint/actions/find-file-by-name.md

### `sharepoint-find-files-with-metadata` — Find Files in List with Metadata (Read-only)

Search and filter items in a SharePoint list based on metadata and custom columns. See docs here

Full schema: https://pipedream.com/apps/sharepoint/actions/find-files-with-metadata.md

### `sharepoint-get-current-user` — Get Current User (Read-only)

Returns the authenticated Microsoft user's ID, display name, email, and principal name via Microsoft Graph. Call this first when the user says 'my files', 'my documents', or needs identity context. Use the returned id to identify file ownership in List Files in Folder or Find File by Name results…

Full schema: https://pipedream.com/apps/sharepoint/actions/get-current-user.md

### `sharepoint-get-excel-table` — Get Excel Table (Read-only)

Retrieve a table from an Excel spreadsheet stored in Sharepoint See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/get-excel-table.md

### `sharepoint-get-file-by-id` — Get File by ID (Read-only)

Retrieves a file by ID. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/get-file-by-id.md

### `sharepoint-get-file-contents` — Get File Contents (Read-only)

Retrieves a Microsoft SharePoint file and returns its contents as extracted plain text or markdown. Supports plain text formats, HTML, DOCX, PDF, and other Office documents convertible to PDF (xlsx, pptx, etc.). See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/get-file-contents.md

### `sharepoint-get-site` — Get Site (Read-only)

Retrieve a site by its identifier. This is a direct path/ID lookup, so it's immediately consistent and returns newly created sites without indexing delay.

Full schema: https://pipedream.com/apps/sharepoint/actions/get-site.md

### `sharepoint-list-drives` — List Drives (Read-only)

List the drives available within a Microsoft Sharepoint site. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/list-drives.md

### `sharepoint-list-files-in-folder` — List Files in Folder (Read-only)

Retrieves a list of the files and/or folders directly within a folder. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/list-files-in-folder.md

### `sharepoint-list-items` — List Items (Read-only)

Get the collection of items in a SharePoint list, including their field values. Supports OData filtering and field selection. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/list-items.md

### `sharepoint-list-lists` — List Lists (Read-only)

Get the collection of lists for a SharePoint site. Returns each list's ID, name, and template type. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/list-lists.md

### `sharepoint-list-sites` — List Sites (Read-only)

List sites across the tenant. Backed by the SharePoint Search index and eventually consistent — newly created sites may not appear until indexing catches up.

Full schema: https://pipedream.com/apps/sharepoint/actions/list-sites.md

### `sharepoint-retrieve-file-metadata` — Retrieve File Metadata (Read-only)

Browse and select files from SharePoint to retrieve their metadata (name, size, dates, etc.) without download URLs. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/retrieve-file-metadata.md

### `sharepoint-search-and-filter-files` — Search and Filter Files (Read-only)

Search and filter SharePoint files based on metadata and custom columns. This action allows you to query files using SharePoint's custom properties, managed metadata, and other column values. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/search-and-filter-files.md

### `sharepoint-search-files` — Search Files (Read-only)

Search for files across the tenant. Supports KQL via the optional query template.

Full schema: https://pipedream.com/apps/sharepoint/actions/search-files.md

### `sharepoint-search-sites` — Search Sites (Read-only)

Search for sites across the tenant. This is a free-text search across multiple site properties — not an exact slug match.

Full schema: https://pipedream.com/apps/sharepoint/actions/search-sites.md

### `sharepoint-select-files` — Select Files (Read-only)

A file picker action that allows browsing and selecting one or more files from SharePoint. Returns the selected files' metadata including pre-authenticated download URLs. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/select-files.md

### `sharepoint-update-item` — Update Item (Write)

Update an existing item in a SharePoint list. Provide only the fields you want to change — omitted fields are left unchanged. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/update-item.md

### `sharepoint-upload-file` — Upload File (Write)

Upload a file to OneDrive. See the documentation

Full schema: https://pipedream.com/apps/sharepoint/actions/upload-file.md

## Triggers (5)

### `sharepoint-updated-file-instant` — File Updated or Deleted (Instant) (Polling)

Emit a new event when specific files are updated or deleted in a SharePoint document library

Full schema: https://pipedream.com/apps/sharepoint/triggers/updated-file-instant.md

### `sharepoint-new-file-created` — New File Created (Polling)

Emit new event when a new file is created in Microsoft Sharepoint.

Full schema: https://pipedream.com/apps/sharepoint/triggers/new-file-created.md

### `sharepoint-new-folder-created` — New Folder Created (Polling)

Emit new event when a new folder is created in Microsoft Sharepoint.

Full schema: https://pipedream.com/apps/sharepoint/triggers/new-folder-created.md

### `sharepoint-new-list-item` — New List Item (Polling)

Emit new event when a new list item is created in Microsoft Sharepoint.

Full schema: https://pipedream.com/apps/sharepoint/triggers/new-list-item.md

### `sharepoint-updated-list-item` — Updated List Item (Polling)

Emit new event when a list item is updated in Microsoft Sharepoint.

Full schema: https://pipedream.com/apps/sharepoint/triggers/updated-list-item.md

---

- All apps: https://pipedream.com/apps — index: https://pipedream.com/llms.txt
- Pipedream docs for agents: https://pipedream.com/docs/llms.txt