Search

Function: search Type: API Endpoint (POST)

Purpose: This function searches for data in specified tables based on the provided search values. It first checks if the table exists in the actual database. Depending on the presence of specific columns and values, it queries the relevant data.

URL: POST /api/mdm/search

Parameters:

• request (Request): The request object.
• search_values (SearchValues): An object containing the table and optional columns to search.
• Customer_Key (str, optional): A base64 encoded header string containing lscode and firmcode.

Returns:

• A JSON response indicating the success or failure of the operation.
• If successful, returns the queried data.
• If the Customer_Key is invalid or if the table is not found, it returns a failure message.

Exceptions:

• Handles exceptions during base64 decoding and database operations, returning an appropriate error message.