Deleting list of records in a file

General
, , ,
1

Hi All, I have list of pzinskey’s in an xlsx/csv file. My requirement is to read and delete them. Is there any way to do this other than obj-browse or RDB-Delete methods?

2

Hi @mnkiran1999,

Yes, there are alternative and better approaches for reading and deleting a list of instances (based on pzInsKeys) from an Excel/CSV file Here are some recommended options:

Recommended Approach: Use a Data Page + Activity + File Listener or File Upload

1. Read the file

You can use either:

  • File Listener (for background/batch processing), or
  • File Upload control in a UI for manual file selection.

2. Parse the file

Use the Parse Delimited Rule (for .csv) or MSOParseExcel activity (for .xlsx), to map records to a pagelist.

3. Iterate and Delete Instances

Create an Activity that:

  • Loops through the list of pzInsKeys.
  • Uses Obj-Delete-By-Handle method, which is recommended over RDB-Delete.