Best way to cleanup workbook table via API

Community Discussions
1

Hi!
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
Thanks

3

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.

5

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?

8

Hi @Fedo-67de,

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