Bulk Delete Rows

Catalyst enables you to delete records or rows of data in bulk from a specific table in the Data Store. The table is referred by its unique ID or name. You can obtain the table ID from 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 upto 200 ROWIDs, in the code.

The rows are passed to the deleteRows() function through rowPromise in the sample code. The table name or table ID must be passed to datastore.table().

The datastore reference used below is defined in the component instance page.

    

        
copy
        

            

        
    
    

         let datastore = app.datastore(); 
//Pass the table ID or table name 
let table = datastore.table('EmpDetails'); 
//Pass the ROWIDs of the records to be deleted to the deleteRows() function 
let rowPromise = table.deleteRows([1028000000171815,1028000000171810, 1028000000171805, 1028000000171617, 1028000000171098]); 
//Returns the promise and pushes to Catalyst
rowPromise.then((row) => { console.log(row); });