Hi Wayne,

The only way to update a table is either via individual rows or in batches when it comes to the API. Even if you choose to try and truncate the data from the table, it basically would do the same thing, deleting individual rows and then inserting new ones.

If you're looking to try and delete data in a table and write new data to it, I would suggest looking into using an ETL since can do a truncation, which would remove data from a table and then re-insert new rows on a table within LabKey.

https://www.labkey.org/Documentation/wiki-page.view?name=etlModule

Regards,

Jon