Get 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