Is anybody familiar with setting up readers from SmartSheet in FME so that you can potentially make/send updates to the SmartSheet directly from FME?
Question
Can you connect FME to SmartSheet?
+67- Celebrity
I replied to your message in the following thread before seeing this:
You can make use of the OpenAPICaller transformer and Smartsheets OpenAPI spec (https://developers.smartsheet.com/_bundle/api/smartsheet/openapi.json) to quickly import all the endpoints into FME. This will make figuring out the API syntax considerably faster.
Scanning through the Smartsheets API docs (https://developers.smartsheet.com/api/smartsheet/openapi), it looks like they’re expecting authentication to be handled via OAuth2. You’ll need to setup you own OAuth2 Web Connection in FME. There is a guide on how to do that here: https://support.safe.com/hc/en-us/articles/25407422190861-Creating-an-OAuth-2-0-Web-Service-and-Connection-in-FME