Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
API: Copying only specific columns within a row
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?
Comments
-
My colleague Craig Williams can probably help with this he has recent experience on similar requirements?
RichardR
-
I am curious of the answer here too..
-
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.
