Bulk Delete Rows

Catalyst enables you to delete rows in bulk from a specific table in the Catalyst Data Store. The table is referred by its unique tableID or tablename. You can obtain the table ID from the Data Store or from the URL when the table is opened in the console.

The bulk delete operation can delete a maximum of 200 rows in a single operation. You can pass the unique ROWIDs of the rows to be deleted in an array as shown in the sample code below. You must include at least one ROWID, and can include up to a maximum of 200 ROWIDs in the code snippet given below.

The rows are passed to the delete_rows() function through datastore_service instance in the sample code. The tablename or tableID must be passed as a parameter to the table() method. The response returns a boolean value ( true or false ) based on the status of deletion.

To know more about the component instancedatastore_service and the table instancetable_service used below, please refer to their respective help sections.

Parameters Used

    

        
copy
        

            

        
    
    

         #Bulk delete rows
datastore_service = app.datastore()
table_service = datastore_service.table("sampleTable")
row_response = table_service.delete_rows([6759000000159113, 6759000000159115, 5249000000032411])