โ11-30-2023 04:55 AM
Hello all,
I'd like to try and pick your brains for a solution to my question. I'll start with the business requirement:
Now my problem that I'd appreciate some help on: I need to have a way to delete the rows out of the custom table so that it doesn't continue to grow, however the only way I can currently see to do this is via the delete by ID option which isnt viable with the number of rows being inserted to the custom table.
Alternatively, am I thinking about this the wrong way and there is a better way to address the requirement?
Additionally SuiteQL only allows a select statement therefore I can't:
I started looking into possibly writing a custom script in NetSuite to do the delete of all rows in my custom table and then seeing if I can call that script via Workato but not sure if that's viable either.
Hopefully that's enough information for you but not too verbose. Any/all help/guidance would be appreciated.
Thanks,
Andy