Dynamic Response Mapping Engine

Map incoming API fields, apply transformations, and configure database insertion schemas.

Field Mapping Matrix (11 Active Mappings)
Source API Field (JSON Key) Target DB Column Column Data Type Transformation Rule Primary
eventId BIGINT Trim & Validate
banquetLeadId VARCHAR(100) Trim -
guestName VARCHAR(150) Trim Whitespace -
guestMobileNo VARCHAR(20) Clean Digits -
cityName VARCHAR(100) Trim -
occasionName VARCHAR(100) Default String -
budget DECIMAL(12,2) To Number -
noOfPeople INT To Integer -
RestaurantName VARCHAR(200) Trim -
startDate DATE Date Parse (YYYY-MM-DD) -
endDate DATE Date Parse (YYYY-MM-DD) -
Sample Ingested JSON (Remote Payload)
{
  "eventId": "982030",
  "guestName": "Uttam ",
  "guestMobileNo": "8435074797",
  "cityName": "Raipur",
  "occasionName": "Birthday Party",
  "budget": "375",
  "noOfPeople": "30",
  "RestaurantName": "Flora Restaurant"
}
Transformed Database Upsert Record
INSERT INTO p4e_bookeventz_leads (
  event_id, guest_name, guest_mobile,
  city_name, occasion_name, budget,
  people_count, restaurant_name
) VALUES (
  982030, 'Uttam', '8435074797',
  'Raipur', 'Birthday Party', 375.00,
  30, 'Flora Restaurant'
) ON DUPLICATE KEY UPDATE
  guest_name=VALUES(guest_name),
  budget=VALUES(budget);