View as Markdown
Sharepoint icon

Sharepoint ACTION

Retrieve File Metadata

Browse and select files from SharePoint to retrieve their metadata (name, size, dates, etc.) without download URLs. See the documentation
  • Action
  • Read only
  • OAuth
  • SDK
  • MCP

IMPLEMENTATION

Call this tool

Connect a user's Sharepoint account once, then configure and run Retrieve File Metadata from your backend or agent.

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-retrieve-file-metadata",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    sharepoint: { authProvisionId: "apn_xxxxxxx" },
    siteId: "Site",
    driveId: "Drive ID",
  },
})

console.log(result)

SCHEMA

Inputs

Pipedream supplies the connected account. Your application provides the operation-specific values below. Dynamic inputs are resolved against that user's account.

Retrieve File Metadata inputs
Property Type Description
siteId Site string
Identifier of a site. This is either the composite ID (e.g. contoso.sharepoint.com,<guid>,<guid> or a server-relative path in the form {hostname}:/{server-relative-path} (e.g. contoso.sharepoint.com:/sites/site-name)
Required Dynamic
driveId Drive ID string
Identifier of a drive within a site
Required Dynamic
folderId Folder string
The folder to browse. Leave empty to browse the root of the drive.
Optional Dynamic
fileOrFolderIds Files or Folders string[]
Select one or more files, or select a folder and click 'Refresh Fields' to browse into it
Required Dynamic

REFERENCE

Tool details

Behavior hints are published with the component in the Pipedream registry and surface as MCP tool annotations, so an agent can reason about a tool before it calls it.

Registry key
sharepoint-retrieve-file-metadata
Version
0.0.7
App
Sharepoint
Authentication
OAuth
Read-only
Yes
Destructive
No
Open world
Yes