Hi. I am trying to connect a Smartsheet sheet via the Smartsheet API to FME to be able to import the information for further processing. I attempted to use the HTTPCaller transformer for this. I have not been succesfull and seam to fail the authentication process even with using the correct token for the sheet. Is it possible to connect to Smartsheets in such a way? Is there any further advice that may help to achieve such a connection. I am using FME Desktop 2020. Examples would be great if this can be done.
Page 1 / 1
Not sure if this is what you're looking for, but I've used Zapier for Smartsheet in the past. It simplifies the integration going to and from whatever app you are using.
Zapier info;
https://help.smartsheet.com/articles/2006869-smartsheet-integration-with-zapier
Safe Blog posting about Zapier
https://www.safe.com/blog/2014/02/zapier-web-enterprise-automation/
Hi @faniemerwe
Have you seen this post on the HTTPCaller?
https://community.safe.com/s/article/Web-Services-cURL-and-the-HTTPCaller
It provides information on how the HTTPCaller works. It also goes into how cURL commands can be translated into parameters within the HTTPCaller. The Smartsheet API documentation provides example requests in cURL so the above link may be helpful in helping set the correct parameters in HTTPCaller.