Is it possible to use Smartsheet's API to auto-populate data from SQL Server?
I'd like to extract data from SQL Server to Smartsheet. I have 5 columns ITEMID, Name, Type, Cost, Location.
If I enter an Itemid, the code should look in the database table and if Itemid is present, then the code should auto-populate the rest of the columns.
Can I do this with API? C# or?
This is possible through the Smartsheet API using webhooks.
You can create a webhook that notifies your code whenever a sheet changes.
When your code receives those notifications, you can then grab that Itemid from the row,
so that you can query your database.
If there is a match in your db, then update the row with the values returned in your db query.
