Smartsheet Reader

This node downloads data from Smartsheet for further processing and analysis within KNIME. It allows you to integrate Smartsheet data with other data sources, calculate KPIs, and visualize results in various ways, including writing data back to Smartsheet using the Smartsheet Writer node.

To set up the Smartsheet Reader Node, follow these steps:

  1. Specify the ID: Enter the Smartsheet Sheet ID or Report ID in the "ID" field.

    To find the ID in Smartsheet:

    • Right-click on the sheet or report name and select "Properties."
    • Alternatively, go to "File" -> "Properties" within the sheet or report.
    • Copy the Sheet ID or Report ID.
  2. Indicate Report (Optional): Check the "Report" checkbox if you are reading data from a Smartsheet report.

  3. Configure Credentials:

    • Via Knime "Credentials Configuration" node:

      • Add the "Credentials Configuration" node to your workflow.
      • Connect the variable port of the "Credentials Configuration" node to the upper left variable port of the Smartsheet Writer node.
      • In the "Credentials Configuration" node:

        1. Enter "SMARTSHEET_ACCESS_TOKEN" in the "Parameter/Variable Name" field.
        2. Enter your Smartsheet access token in the "Password" field.

        Note: If your Smartsheet token is for European or Government Smartsheet server, you need to prefix your Smartsheet token with the region (eu, gov). (eg: "eu:<SMARTSHEET_ACCESS_TOKEN>")

    • Alternatively, using environment variables:

      • Set your Smartsheet access token in "SMARTSHEET_ACCESS_TOKEN" env variable.
      • Optional: Set your Smartsheet region (eu, gov) in "SMARTSHEET_REGION" env variable.

    Note: if the region is unspecified, it will use by default US Smartsheet services (smartsheet.com)

Options

ID

The Smartsheet sheet or report to be read

Report (Sheet otherwise)

The source ID is a report (sheet otherwise)

Input Ports

This node has no input ports

Output Ports

Icon

Data from Smartsheet

Icon

Source Sheets for the Report (only for reports)

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.