Skip to main content
Open

New Reader/Writer: Smartsheet Connector

Related products:Integrations
siennaatsafe
erik_jan
warrendev
tcrossman
rwhittington
+19
  • siennaatsafe
    siennaatsafe
  • erik_jan
    erik_jan
  • warrendev
    warrendev
  • tcrossman
    tcrossman
  • rwhittington
    rwhittington
  • jencrawford
    jencrawford
  • rich90599
    rich90599
  • 01011010
    01011010
  • gis_queen
    gis_queen
  • cwarren
    cwarren
  • davisblack
    davisblack
  • saven
  • vlad_cv
    vlad_cv
  • davidburger
  • germang
    germang
  • evieatsafe
    evieatsafe
  • cameronswink1
  • martinstefanczy
  • faniemerwe
  • djacques
  • geckosolutions
    geckosolutions
  • emain
  • katie.poole
    katie.poole
  • rcleaves

rwhittington
Contributor

7 replies

rwhittington
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • July 7, 2017
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?

 

 


rwhittington
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • July 7, 2017
FYI: there is a full featured api and oauth security handshaking: https://smartsheet-platform.github.io/api-docs/#smartsheet-api-2-0

 

 


fmelizard
Safer
Forum|alt.badge.img+18
  • Safer
  • July 8, 2017

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?


Both would be great!

 

 

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.

 

 

The options are truly endless.

 

 


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.

 

 


rwhittington
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • July 11, 2017

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.


Forum|alt.badge.img+6

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings