API Bi-directional setup
Options
T Avery
✭
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.