---
title: "Get Reference Table Details"
method: GET
path: "/api/new_mdm/reference_table_details"
tags: ["MDM NEW"]
---

# Get Reference Table Details

`GET /api/new_mdm/reference_table_details`

**Function**: `get_reference_table_details`
**Type**: API Endpoint (GET)

**Purpose**:
Returns the reference table details for a given table and column.

**URL**:
`GET /api/new_mdm/reference_table_details`

**Parameters**:
- `page` (Query, optional): The page number for pagination (default is 1).
- `limit` (Query, optional): The number of rows to fetch per page (default is 25).
- `Customer_Key` (Header, required): A base64 encoded string containing `lscode` and `firmcode` for the customer.
- `flag` (Query, required): A flag indicating whether to retrieve the reference table details (0) or the display column details (1).
- `table_name` (Header, required): The name of the table to retrieve the reference table details for.
- `column_name` (Header, required): The name of the column to retrieve the reference table details for.
- `search_params` (Query, optional): Search parameters to filter the results.

**Request Body**: None

**Response**:
A JSON object containing the reference table details or the display column details.

**Status Codes**:
- 200: Success
- 400: Invalid `customer_key`
- 404: Table or column not found
- 500: Internal Server Error

## Query parameters

- `page` integer, required
- `limit` integer, required
- `flag` integer, required
- `search_params` string

## Headers

- `Customer-Key` string, required
- `table-name` string, required
- `column-name` 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)