[UXPROD-4175] Bulk API Delete Template Created: 10/Apr/23  Updated: 30/Nov/23

Status: Open
Project: UX Product
Components: None
Affects versions: None
Fix versions: None

Type: Epic Priority: P2
Reporter: Tim Auger Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Epic Name: tim test
Development Team: None
PO Rank: 0
Epic Color: ghx-label-10

 Description   

Purpose/Overview:

In order to facilitate efficient and timely data migration functionality, which often requires iterative reloading of data, the <MODULE> needs the ability to Delete <record type> in bulk, rather than processing records individually.

For deleting a list of records RMB needs to provide a method PgUtil.delete, but this is still missing, we have RMB-389 Closed for developing it.

Requirements:

  • Users shall be able to DELETE to a single endpoint with a CQL query. All records matching that query shall be deleted. Deleting by id using CQL is restricted to 54 records because of the URL maximum length
  • Users shall be able to DELETE to a single endpoint with a list of ids in the body of the DELETE request.
  • Records shall be deleted from the database in a single transaction
  • For CQL tThe endpoint shall respect a "dry run" parameter, which will return the count of records to be deleted, without actually deleting them from the database.
  • Deletes shall not cascade. If a record cannot be deleted due to foreign key constraints, then the whole operation shall return an error.
  • Should the operation fail due to an error in an individual record, an error message shall be returned that alerts the user where to look in the record set to find the problem.
  • On success, the endpoint shall return a JSON object with the count of the number of records deleted.

Generated at Fri Feb 09 00:37:52 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.