Find Replace Column

Function: find_replace_column Type: API Endpoint (POST)

Purpose:
This endpoint facilitates finding and replacing column values in a specified table in the customer database.

URL:
POST /api/new_mdm/find_replace_column

Request Parameters:

• Customer_Key (Header, required): An encoded string containing lscode and firmcode for the customer.
• Table_Name (Header, required): The name of the table to update.
• input_data (JSON Body, required): An object containing a list of column updates, each with column_name, old_value, and new_value properties.

Notes:

• If flag is set to '1', the endpoint will return the distinct values of the column as specified in input_data.updates[0].column_name.
• If flag is not set to '1', the endpoint will replace the values in the column as specified in input_data.updates.

Response:
The API returns a JSON object with the status of the operation.