---
title: "Delete Records List"
method: POST
path: "/api/new_mdm/delete_records"
tags: ["MDM NEW"]
---

# Delete Records List

`POST /api/new_mdm/delete_records`

**Function**: `delete_records_list`
**Type**: API Endpoint (POST)

**Purpose**:  
Deletes records from a specified table in the customer database based on the provided query.

**URL**:  
`POST /api/new_mdm/delete_records`

**Parameters**:
- `Table_Name` (Header, required): The name of the table to be deleted from.
- `Customer_Key` (Header, required): A base64 encoded string containing `lscode` and `firmcode` for the customer.
- `request_data` (JSON Body, required): A JSON object containing the deletion details.

**Request Body**:
```
    {
        "delPartialRecords": <delPartialRecords>,
        "delFullRecords": <delFullRecords>,
        "Customcol": "<Customcol>",
        "Date_Of_Item_Created": "<Date_Of_Item_Created>",
    }
```

## Headers

- `Table-Name` string, required
- `Customer-Key` string, required

## Request body

- DeleteRecordsRequest
  - `delFullRecords` boolean, nullable — If true, delete all records.
  - `delPartialRecords` boolean, nullable — If true, delete records based on specific conditions.
  - `Customcol` string, nullable — The column to filter for partial deletions.
  - `Date_Of_Item_Created` string, nullable — Date range for partial deletion (e.g., '2023-01-01, 2023-12-31').

## Response `200`

Successful Response

- unknown

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.dev/leapsurgebi/apis/leapsurgeapi.md) · [All operations](https://skmtc.dev/leapsurgebi/apis/leapsurgeapi/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/leapsurgebi/leapsurgeapi/revisions/5a6b1464bfeb/schema)