moveRowToAnotherSheet not deleting rows from source sheet
Hi there,
We're using the NodeJS SDK to move rows from one sheet to another on a timed job but we often find that rows landing in our destination sheet aren't removed from the source sheet.
This means that over time we end up with a lot of duplicates in our destination sheets. Eventually, after some number of attempts to move a row, it seems like the row does move but by that point there's already a duplicate in our destination sheet.
We have a max limit on the number of rows we're trying to move of 3000, but most jobs move between 0 and 50 rows. Even with these small numbers we're finding that rows aren't removed from the source sheet.
We get a response back from moveRowToAnotherSheet
indicating that the rows were in fact moved, and no errors are being thrown.
Is this a known issue? Are there things we can be doing to combat this problem?
I'd say we do this across about 50 sheets per night, each one requesting to move between 0 and 50 rows.
Thanks for any help or guidance you can offer.
Jamie
SDK Version: "smartsheet": "^1.5.0"
Answers
-
Hi @Jamie Dixon
This doesn't sound like expected behaviour, and rows only being copied a few times before being fully moved over to a destination sheet is not a known issue that I'm aware of. The best way to get to the bottom of this would be to contact Support (see here) so they can troubleshoot this with you one-on-one.
Please provide them with information such as the sheet names, screen recordings (if possible), and a copy of the request & response back.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives