API: Copying only specific columns within a row

Paul Mather

I want to copy a row from Sheet A > Sheet B. 

 

Sheet A contains several columns that Sheet B does not. Currently, moving the row results in Smartsheet automatically creating the ommited columns in Sheet B and dumping them at the end.

 

Is it possible using the API, to select only the columns I want to move? Or to somehow prevent Smartsheet from taking it upon itself to automatically create the columns and to just dump the data?

Richard Rymill SBP

My colleague Craig Williams can probably help with this he has recent experience on similar requirements? 

RichardR

Tony Davidson - SmartSheet Certified User 2016

I am curious of the answer here too..

dAVE Inden

If you know the row you are looking to copy you could do a GET request for the entire sheet and find the row you need. Then looking at the cells of that row you can gather the appropriate values and use them in a request to add a row or update an existing row on the intended sheet.

This way you aren't creating additional columns on the destination sheet and can update select values within it.