How to use Smartsheet API in Knime to get data

Carmen W

Hi All,

I was trying to use the GET Request node in Knime to get data from some reports and sheets using Smartsheet API.

But looks like I can only use "https://api.smartsheet.com/2.0/sheets" or "https://api.smartsheet.com/2.0/reports" to get info for all sheets or reports. And when I include the reportid or sheetid, it gives me 40x error.

Can you please let me know what is the correct way to use Smartsheet API in Knime?

Thank you.

Ryan Sides

Hi Carmen, did you read through the Smartsheet sdk?

https://smartsheet.redoc.ly/

40x errors are usually bc you don’t have the credentials to clone t properly or you’re providing an end point that doesn’t exist.

have you tried pulling data from a single sheet to see if you can connect properly at least there?

you can use the search endpoint to pull some high level detail across many sheets but you’ll need to connect to each sheet if your looking to pull row level data.

Louis Raoul

Hello,

I have the same problem, getting data from Smartsheet into Knime directly via the API. I'm now thinking of developing a KNIME node for it.

I have already setup a system to get data from KNIME into Smartsheet.

Thanks for the feedback.

Raoul.

Carmen W

Hi Raoul,

Thanks for getting back.

I was able to create a Knime workflow to get Smartsheet data via API but it doesn't always work. Sometimes I have to rerun the workflow multiple times in order for it to work.

Does your system to get data from knime to smartsheet has this same issue?