I want to talk with someone about setting up an API to transfer files bi-directional between SQL & Smartsheet. Is this possible?
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.
©2022. All Rights Reserved Smartsheet Inc.