C# API Add Records from MS SQL Server

jrichardw

Hello, I'm trying to get records from a SQL table into Smartsheet using C# and ultimately SSIS (via script command).  I'm stuck on how to add the rows into Smartsheet.

1. I want to add the rows dynamically without having to code the column id.  I see that there is Bulk Operations but very little documentation for it.  This command seems to be possible without having to use a column ID: POST /sheets/{sheetId}/rows.   Does anyone know how to use this?  I'm guessing I would need to implement REST code in my C# app.

2. If I don't go with the above, is there a way to just loop through sheet columns and write the data from a SQL column?  I'm guessing I would have to dynamically pull the column ID.

Hope this all makes sense.

jrichardw

I actually figured this one out.  I took two approaches and ended up with one successful.  I tried the SDK, but I couldn't get it loop through both the SQL data and dynamically build the string for the Smartsheet columns.  So I ended up just looping through my data and building a JSON string and using REST to post.  It's actually much faster than the API.  If anyone is interested in seeing the outcome, let me know.  I'm sure there's an easier way, but I got the job done and the code is not super long.