How to use Smartsheet API in Knime to get data
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?