{ "total_orders": "635", "payment_statuses": [ { "payment_status": "paid", "cnt": "498" }, { "payment_status": "created", "cnt": "136" }, { "payment_status": "pending", "cnt": "1" } ], "ticket_statuses": [ { "ticket_status": "Booking Confirmed", "cnt": "223" }, { "ticket_status": "Ticketing In Progress", "cnt": "183" }, { "ticket_status": "Ticketing_Failed", "cnt": "89" }, { "ticket_status": "Booking Pending Confirmation", "cnt": "88" }, { "ticket_status": "Booking Failed", "cnt": "42" }, { "ticket_status": "PNR=", "cnt": "9" }, { "ticket_status": "Pending", "cnt": "1" } ], "unique_emails": [ "00rahulthapa@gmail.com", "14mohitchawla@gmail.com", "aakarshjain811@gmail.com", "achandra250@gmail.com", "afs@gmail.com", "aishwaryajadhav70@gmail.com", "akshat.sunbeam03@gmail.com", "am.tanjiro@gmail.com", "anuprajsinghdav@gmail.com", "arnavgupta1920@gmail.com", "asiftair07@gmail.com", "avikadubey124@gmail.com", "ayushmalhotra318@gmail.com", "azakir780@gmail.com", "babulvishal@gmail.com", "bdjsjkek@gdhd.com", "bhushanshinde845@gmail.com", "chetna.lakshwani@gmail.com", "deshnashah29@gmail.com", "devamorenov29@gmail.com", "digicarea@gmail.com", "dishap2904@gmail.com", "ervinaychopra@gmail.com", "firdouskauser20@gmail.com", "friendskaustubhp@gmail.com", "gtnagashree@gmail.com", "harishredy525@gmail.com", "harishvenki001@gmail.com", "hoopervishu@gmail.com", "hrishimundra111219@gmail.com", "imakshatgupta13@gmail.com", "imtiyazz7035@gmail.com", "irfaninblue@gmail.com", "ishika.nair2004@gmail.com", "jyotichaudary27@hotmail.com", "karan1317@gmail.com", "krishrai8570@gmail.com", "kumar.anubhav2@gmail.com", "madhavchaitanyaa@gmail.com", "malodenikita918@gmail.com", "mayihelputoday@gmail.com", "mdturab110786@gmail.com", "mdturab143@gmail.com", "mg137160@gmail.com", "monalisha654321@gmail.com", "munnangisaikumar@gmail.com", "nehadskhan@gmail.com", "nehalhooda031@gmail.com", "nianaique11@gmail.com", "palashrastogi1806@gmail.com" ], "unique_phones": [ "6006213273", "6006740709", "6201912992", "6361960324", "6376779398", "6387536990", "6909199397", "7004674852", "7017730017", "7093746845", "7204503643", "7404444375", "7406646909", "7409792531", "7447044171", "7503396947", "7504729725", "7507799323", "7600044475", "7664865562", "7709462411", "7988403298", "8073804972", "8121281989", "8130584184", "8145106081", "8302078742", "8310731396", "8341119222", "8390906988", "8397055396", "8455872027", "8459792239", "8489384821", "8600120147", "8652756220", "8655224517", "8655225334", "8726614741", "8764008440", "8779629150", "8801084787", "8810967692", "8815150929", "8817020133", "9011750021", "9013189013", "9054595958", "9063606089", "9079988229" ], "recent_bookings": [ { "id": "641", "order_ref": "TBF_BEFB14EE_1780404456", "pnr": "PENDING", "airline_name": "Indigo", "flight_number": "2107", "origin": "DEL", "destination": "DMU", "departure_time": "2026-06-07 12:40:00", "payment_status": "paid", "ticket_status": "Ticketing_Failed", "contact_email": "trongchehonpi@gmail.com", "contact_phone": "6909199397", "fare_total": "8038.00", "created_at": "2026-06-02 05:47:36" }, { "id": "640", "order_ref": "TBF_1A1334CA_1780404224", "pnr": "PENDING", "airline_name": "Indigo", "flight_number": "2107", "origin": "DEL", "destination": "DMU", "departure_time": "2026-06-07 12:40:00", "payment_status": "paid", "ticket_status": "Ticketing_Failed", "contact_email": "trongchehonpi@gmail.com", "contact_phone": "6909199397", "fare_total": "8038.00", "created_at": "2026-06-02 05:43:44" }, { "id": "638", "order_ref": "TBF_FINAL_FE14BB", "pnr": "PENDING", "airline_name": "IX", "flight_number": "IX2019", "origin": "HYD", "destination": "CCU", "departure_time": "2026-06-07 08:25:00", "payment_status": "paid", "ticket_status": "Ticketing_Failed", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "5726.50", "created_at": "2026-06-02 02:53:02" }, { "id": "637", "order_ref": "TBF_F00DE3F6_1780392820_IB", "pnr": "CPF45S", "airline_name": "Spicejet", "flight_number": "529", "origin": "BLR", "destination": "DEL", "departure_time": "2026-06-15 05:05:00", "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "0.00", "created_at": "2026-06-02 02:33:41" }, { "id": "636", "order_ref": "TBF_F00DE3F6_1780392820", "pnr": "CPF45S", "airline_name": "Indigo", "flight_number": "873", "origin": "DEL", "destination": "BLR", "departure_time": "2026-06-09 08:20:00", "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "4053.80", "created_at": "2026-06-02 02:33:41" }, { "id": "635", "order_ref": "TBF_41031F4E_1780391845_IB", "pnr": null, "airline_name": "Spicejet", "flight_number": "529", "origin": "BLR", "destination": "DEL", "departure_time": "2026-06-16 05:05:00", "payment_status": "created", "ticket_status": "Ticketing In Progress", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "0.00", "created_at": "2026-06-02 02:17:26" }, { "id": "634", "order_ref": "TBF_41031F4E_1780391845", "pnr": "ITQU2G", "airline_name": "Indigo", "flight_number": "873", "origin": "DEL", "destination": "BLR", "departure_time": "2026-06-04 08:20:00", "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "10247.80", "created_at": "2026-06-02 02:17:25" }, { "id": "633", "order_ref": "TBF_9C530DDC_1780384400_IB", "pnr": null, "airline_name": "Spicejet", "flight_number": "529", "origin": "BLR", "destination": "DEL", "departure_time": "2026-08-07 05:05:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "0.00", "created_at": "2026-06-02 00:13:21" }, { "id": "632", "order_ref": "TBF_9C530DDC_1780384400", "pnr": "XPQ4WY", "airline_name": "Indigo", "flight_number": "846", "origin": "DEL", "destination": "BLR", "departure_time": "2026-08-02 22:00:00", "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "9986.80", "created_at": "2026-06-02 00:13:21" }, { "id": "631", "order_ref": "TBF_FINAL_80D44B", "pnr": "PENDING", "airline_name": "IX", "flight_number": "IX2019", "origin": "HYD", "destination": "CCU", "departure_time": "2026-06-07 08:25:00", "payment_status": "paid", "ticket_status": "Ticketing_Failed", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "5726.50", "created_at": "2026-06-01 20:25:58" }, { "id": "630", "order_ref": "TBF_WEBTEST_988C85", "pnr": "N2M99X", "airline_name": "Indigo", "flight_number": "873", "origin": "DEL", "destination": "BLR", "departure_time": "2026-06-07 08:20:00", "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "2370.22", "created_at": "2026-06-01 20:22:35" }, { "id": "629", "order_ref": "TBF_PNR09_1A10E4", "pnr": "OZ7KHD", "airline_name": "6E", "flight_number": "6E873", "origin": "DEL", "destination": "BLR", "departure_time": null, "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "support@thebookflight.com", "contact_phone": "9650863349", "fare_total": "4740.45", "created_at": "2026-06-01 17:36:25" }, { "id": "628", "order_ref": "TBF_PNR01_35F82F", "pnr": "Q3CWRK", "airline_name": "6E", "flight_number": "6E873", "origin": "DEL", "destination": "BLR", "departure_time": null, "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "support@thebookflight.com", "contact_phone": "9650863349", "fare_total": "2370.22", "created_at": "2026-06-01 17:36:09" }, { "id": "627", "order_ref": "TBF_WEBTEST_4C7A7D", "pnr": "N2M99X", "airline_name": "Indigo", "flight_number": "873", "origin": "DEL", "destination": "BLR", "departure_time": "2026-06-07 08:20:00", "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "2370.22", "created_at": "2026-06-01 14:16:35" }, { "id": "626", "order_ref": "TBF_PNR09_0968B2", "pnr": "OZ7KHD", "airline_name": "6E", "flight_number": "6E873", "origin": "DEL", "destination": "BLR", "departure_time": null, "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "support@thebookflight.com", "contact_phone": "9650863349", "fare_total": "4740.45", "created_at": "2026-06-01 13:31:59" }, { "id": "625", "order_ref": "TBF_PNR01_81D8A8", "pnr": "Q3CWRK", "airline_name": "6E", "flight_number": "6E873", "origin": "DEL", "destination": "BLR", "departure_time": null, "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "support@thebookflight.com", "contact_phone": "9650863349", "fare_total": "2370.22", "created_at": "2026-06-01 13:31:40" }, { "id": "624", "order_ref": "TBF_E6EE5523_1780343065_IB", "pnr": "ZRQJ8C", "airline_name": "Indigo", "flight_number": "891", "origin": "CCU", "destination": "DEL", "departure_time": "2026-07-12 07:00:00", "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "0.00", "created_at": "2026-06-01 12:44:25" }, { "id": "623", "order_ref": "TBF_E6EE5523_1780343065", "pnr": "U6YBJI", "airline_name": "Spicejet", "flight_number": "476", "origin": "DEL", "destination": "CCU", "departure_time": "2026-07-01 16:30:00", "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "20677.80", "created_at": "2026-06-01 12:44:25" }, { "id": "622", "order_ref": "TBF_A0E87D4C_1780342757_IB", "pnr": null, "airline_name": "Spicejet", "flight_number": "487", "origin": "CCU", "destination": "DEL", "departure_time": "2026-06-28 16:40:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "0.00", "created_at": "2026-06-01 12:39:17" }, { "id": "621", "order_ref": "TBF_A0E87D4C_1780342757", "pnr": "KWIEFI", "airline_name": "Indigo", "flight_number": "894", "origin": "DEL", "destination": "CCU", "departure_time": "2026-06-21 10:15:00", "payment_status": "paid", "ticket_status": "Booking Confirmed", "contact_email": "sales@thebookflight.com", "contact_phone": "9650863349", "fare_total": "19773.80", "created_at": "2026-06-01 12:39:17" } ], "excluded_by_filter": [ { "id": "383", "order_ref": "TBF-TEST-001", "payment_status": "pending", "ticket_status": "Pending", "contact_email": "test@example.com", "created_at": "2026-05-29 11:39:19" } ], "table_columns": [ "id", "order_ref", "rzp_order_id", "rzp_payment_id", "rzp_signature", "payment_amount", "payment_status", "trace_id", "result_index", "is_lcc", "adivaha_booking_id", "pnr", "ticket_status", "offline_booking", "offline_message", "airline_code", "airline_name", "flight_number", "origin", "destination", "departure_time", "arrival_time", "trip_type", "is_domestic", "fare_total", "lead_pax_name", "contact_email", "contact_phone", "customer_ip", "passenger_count", "passenger_data", "booking_payload", "formatted_passengers", "book_response", "ticket_response", "details_response", "poll_count", "last_polled_at", "created_at", "updated_at", "email_sent" ] }