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);