---
title: "Insert Custom Reference Table"
method: POST
path: "/api/new_mdm/insert_custom_reference_table"
tags: ["MDM NEW"]
---

# Insert Custom Reference Table

`POST /api/new_mdm/insert_custom_reference_table`

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

**Purpose**:  
Inserts custom reference table details into the database.

**Parameters**:  
- `request`: The HTTP request object.
- `customer_key` (Header, required): A base64 encoded string containing `lscode` and `firmcode` for the customer.
- `table_details`: The details of the custom reference table to be inserted.
- `flag` (int, optional): The flag indicating whether to insert custom reference table details (1) or custom reference table reference details (2). Defaults to 1.
- `current_user` (str): The current user performing the operation, obtained via dependency injection.

**Returns**:  
A JSON response containing the message "Data inserted successfully".

**Exceptions**:  
- `HTTPException`: If any exception occurs during the process, it raises an HTTPException with a 500 status code and the exception message.

## Query parameters

- `flag` integer

## Headers

- `customer-key` string, required

## Request body

- CustomReferenceRequest
  - `reference` CustomReferenceData[], nullable
    - `table` string, required
    - `column_id` string, required
    - `values` ValueData[], required
      - `key` union, required
        - integer
        - string
      - `value` union, required
        - integer
        - string
    - `modified_by` string, required
  - `reference_table` CustomTableReferenceData[], nullable
    - `table` string, required
    - `column` string, required
    - `reference_table` string, required
    - `data_column` string, required
    - `display_column1` string, required
    - `display_column2` string, nullable
    - `display_column3` string, nullable
    - `display_column4` string, nullable
    - `display_column5` string, nullable
    - `modified_by` string, required

## 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)