Best way to cleanup workbook table via API

What is the best way to delete all rows from table except header via Boto3?
I need to do that because the start_table_data_import_job method only appends data, not overwrite

Hi @Fedo-67de,

Thanks for your question.

My recommendation would be to try batch_delete_table_rows() to clean up the data from tables.
More information can be found in the honeycode boto3 documentation.

If you have any further questions, please don't hesitate to contact us.

Yes, of course I saw this method :slight_smile:
Am I correct that first I have to get the list of all rowIds by using list_table_rows method? Or it possible to delete all rows without knowing their Ids?

Hi @Fedo-67de,

You are correct, to delete the rows using batch_delete_table_rows(), you would need the rowids.