API Bi-directional setup

I want to talk with someone about setting up an API to transfer files bi-directional between SQL & Smartsheet. Is this possible?

Answers

  • I would say it is possible, I use the API frequently to add/delete rows, add new sheets etc. The SQL side you would need to convert the data you pull from the sheet into the appropriate SQL and run the query with a connection to the sql db.