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.
Question
Connecting FME to Smartsheets via API.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+2Not 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/
+22- Safer
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.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.