moveRowToAnotherSheet not deleting rows from source sheet
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.
SDK Version: "smartsheet": "^1.5.0"