View as Markdown
Smartsheet icon

Smartsheet ACTION

List Discussions

Lists discussions on a Smartsheet sheet (GET /sheets/{sheetId}/discussions). If a Row ID is supplied, lists discussions scoped to that row instead (GET /sheets/{sheetId}/rows/{rowId}/discussions), since the sheet-level endpoint does not accept a row filter. Supports pagination and optional inclusion of comments/attachments. The response includes pageNumber and totalPages — to fetch more, call again with page incremented by 1 while pageNumber is less than totalPages. Requesting a page beyond totalPages returns the last page again rather than an empty result, so do not use a shorter or empty page as a stop signal. Pass fields (comma-separated, e.g. id,title,commentCount) to get back only those top-level fields per discussion instead of the full object — useful when you just need titles/counts, not full comment threads. Use List Sheets to find a Sheet ID. Example: {sheetId: "1234567890123456", include: ["comments"]} returns discussions with their full comment threads embedded. See the documentation.
  • Action
  • Read only
  • OAuth
  • SDK
  • MCP

IMPLEMENTATION

Call this tool

Connect a user's Smartsheet account once, then configure and run List Discussions 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: "smartsheet-list-discussions",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    smartsheet: { authProvisionId: "apn_xxxxxxx" },
    sheetId: "Sheet ID or URL",
    rowId: "Row 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.

List Discussions inputs
Property Type Description
sheetId Sheet ID or URL string
The sheet whose discussions to list. Accepts a numeric sheet ID (e.g. 1234567890123456), or a Smartsheet sheet URL, which is resolved to the ID for you. Use List Sheets to enumerate sheets.
Required
rowId Row ID string
Optional. If provided, lists discussions for this specific row instead of the whole sheet (e.g. 9876543210123456). Use Get Sheet or Search to find row IDs.
Optional
include Include string[]
Optional. Sub-objects to include. attachments is ignored unless comments is also included, since attachments are nested under comments.
Optional
pageSize Page Size integer
Optional. The number of discussions to return per page (min 1, max 1000; Smartsheet default 100).
Optional
page Page integer
Optional. The 1-based page number of results to return (default 1).
Optional
fields Fields string
Optional. Comma-separated list of top-level discussion fields to return (e.g. id,title,commentCount), instead of the full discussion object. If omitted, the full object (including embedded comments, if requested via Include) is returned unchanged.
Optional

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
smartsheet-list-discussions
Version
0.0.1
App
Smartsheet
Authentication
OAuth
Read-only
Yes
Destructive
No
Open world
Yes