smartsheet connectivity has come up a few times in conversations with FME users this week. Has anyone used smartsheet with FME and have experience to share?
I have used this and was impressed. Hadn't thought about FME connectivity. What would the use case be -- to populate an initial sheet from some table of data somewhere? Or to export things out?
I am currently working on trying to create sheets on Smartsheet using a template that I created and saved in a workspace. I am able to extract and read the sheets, but experimenting on how to POST. There seems to be issues here, but I am looking at the platform on GitHub and using the help on there to create a JSON file that I can use in FME. Of course, there are many angles to practice this, but having a temporary JSON file could be potentially used to test parameters. FME could help fill in the information that is missing or changes with each project (i.e. Project Name, Project Type, ect.). Smartsheet allows for a lot to be done, it is just a matter of making it happen, and I will.
Once the handshake is made both ways, there is a lot that can be done. Smartsheet deals with project organization, and deals specifically with notifications between users. When we have FME creating the sheets, these ID's could be saved using a transformer to log specific columns/rows and their ID's. Smartsheet allows the API to connect to the ability to send notifications and updates.
For example, if a row's boolean value (for a checkbox) was 'TRUE,' then FME Server could automatically send a notification to the next department of that project's completion. Furthermore, FME could add attachments to specific rows; this would eliminate human error.
I have lived on this site for the past few days, and have gained a lot of knowledge. Currently, I am working on the POST request now that I have studied how the JSON scripting is formatted and used behind Smartsheet.
I'm quite excited to see how I am going to figure this out. Smartsheet does provide a lot of detail on their GitHub platform section, but there were a few crucial tips missing that I have worked around.
I would think the first step would be to make a web connector to handle authorization. Then to connect to an existing sheet (like share point list or google sheets)... populate rows in a sheet (upsert, delete) as well as read schema and rows from a smartsheet/table. might even wrap the .csv import/export functionality of smartsheet initially.... may be a good case for feature tables as well.
We're making use of their API via FME. It is very well documented. However knowing how extensive it is, I don't know if a generic connector would really give you all the functionality you need. If you're a licensed user of Smartsheet (maybe even need to be an admin), you can generate an access token via your account settings > Apps & Integrations > API Access and generate from there. API Documentation is available here: https://smartsheet-platform.github.io
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.