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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 142 Industry Talk
- 473 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives