moveRowToAnotherSheet not deleting rows from source sheet

Jamie Dixon
edited 10/12/20 in API & Developers

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