{ "query_time": "2026-06-16 14:17:29", "order_ref": "TBF_F75ACE4F_1780484400", "orders": [ { "id": "717", "order_ref": "TBF_F75ACE4F_1780484400", "rzp_order_id": "order_Sx8NYxjAthMjfP", "rzp_payment_id": "pay_Sx8Nud2j2chVC0", "rzp_signature": null, "payment_amount": "997780", "payment_status": "paid", "trace_id": "ff17f958-bcb7-4fc7-927b-1e3fbc8f4e34", "result_index": "OB1[TBO]7TRrSnOT tQObSvxrDH8AN2O9aokbuJTze\/mCIQx8xhgX\/9VNmRo8yGsEnA0vR\/HrzjHgh9N9f4JcVqkENcSg\/vnwkRE2vTAx E\/ke6WhTuz9551v842SImB5Nt5vpfMCng9bL8N4BMvnIbqcmJli0bVF6tNEgtWffONAT5fAyagfGtNj5jUOTdO1OjJzibqN8pcDizyLNWkscABNaFTbhFr8QNmFAwjwiP9rSW9xU5WAZSC60jtYb6OFB8t6XdPwEen\/fPvKizWxeC9RnXusV2juDNHHi7aDzc4TwaFDuZlLReKYz5QHgrTSJ55IA0s\/Uc48d7uyO0xuRpOxHZ1336d33KDS9JTyIhaVhxIt9TQPmA9 9c4FRCF5LHP4gn9tLFEmQomoVKY50WC\/8TODno3oohCx3GMv\/fojq\/4y0dHOialVQwfQYvQJPHf63p6j PC1ZWM5OvBdR9ygLBtOfGksLYST7xjItX Kz4SPpaXS6i2uiX28SKQCDC1Zxf304toGzQCmbXUY9tDWiWYOjKx7Ep\/j2h 9pD0mv7dPaZKkkFqGmleyEydUCukMamJVxRm8XS b\/CPZ044\/7nAXVaLik3E0pIGIyARDe4MMt4UAVP4YGBTowcodbYA5yfiqO176WDSmLtBmDilUiyDgTBZx0oqoAwvyxDF81zgXaOGFevpCmbIQIp60OaQLwX6Gc dsNOuGCUCSHh tbPYesz89gavuyOY15yHPSeKj7pvxBbAgqljm KEd9 SQYEFS5hee5tZ4yCHGbytfNxsJNm7oU2P IqsnQRb2WNbooESvZiNjx8Hzt3wg1hoGRBznZDrOKgQCWPcr kP6vmXRWLGofOFdkIhIzMow0XYvl5QiQyA23zS0678lA4CsJB0cqtgpRT ds2DPZrrtkHQ85XFdcZPuzmJfi6LBcQ2SDRrjkrKIYL0FJEzn91fsILKypFMu1AZAU3SU\/bvxCLzRQ==", "is_lcc": "1", "adivaha_booking_id": null, "pnr": "PENDING", "ticket_status": "Ticketing_Failed", "offline_booking": "0", "offline_message": "", "airline_code": "6E", "airline_name": "Indigo", "flight_number": "873", "origin": "DEL", "destination": "BLR", "departure_time": "2026-06-11 08:20:00", "arrival_time": "2026-06-11 11:10:00", "trip_type": "roundtrip", "is_domestic": "1", "fare_total": "9977.80", "lead_pax_name": "test test", "contact_email": "thebookflight@gmail.com", "contact_phone": "9650863349", "customer_ip": "202.140.128.11", "passenger_count": "1", "passenger_data": [ { "PaxType": "1", "Title": "Mr", "FirstName": "test", "LastName": "test" } ], "booking_payload": { "action": "ticketForLcc", "ResultIndex": "OB1[TBO]7TRrSnOT tQObSvxrDH8AN2O9aokbuJTze\/mCIQx8xhgX\/9VNmRo8yGsEnA0vR\/HrzjHgh9N9f4JcVqkENcSg\/vnwkRE2vTAx E\/ke6WhTuz9551v842SImB5Nt5vpfMCng9bL8N4BMvnIbqcmJli0bVF6tNEgtWffONAT5fAyagfGtNj5jUOTdO1OjJzibqN8pcDizyLNWkscABNaFTbhFr8QNmFAwjwiP9rSW9xU5WAZSC60jtYb6OFB8t6XdPwEen\/fPvKizWxeC9RnXusV2juDNHHi7aDzc4TwaFDuZlLReKYz5QHgrTSJ55IA0s\/Uc48d7uyO0xuRpOxHZ1336d33KDS9JTyIhaVhxIt9TQPmA9 9c4FRCF5LHP4gn9tLFEmQomoVKY50WC\/8TODno3oohCx3GMv\/fojq\/4y0dHOialVQwfQYvQJPHf63p6j PC1ZWM5OvBdR9ygLBtOfGksLYST7xjItX Kz4SPpaXS6i2uiX28SKQCDC1Zxf304toGzQCmbXUY9tDWiWYOjKx7Ep\/j2h 9pD0mv7dPaZKkkFqGmleyEydUCukMamJVxRm8XS b\/CPZ044\/7nAXVaLik3E0pIGIyARDe4MMt4UAVP4YGBTowcodbYA5yfiqO176WDSmLtBmDilUiyDgTBZx0oqoAwvyxDF81zgXaOGFevpCmbIQIp60OaQLwX6Gc dsNOuGCUCSHh tbPYesz89gavuyOY15yHPSeKj7pvxBbAgqljm KEd9 SQYEFS5hee5tZ4yCHGbytfNxsJNm7oU2P IqsnQRb2WNbooESvZiNjx8Hzt3wg1hoGRBznZDrOKgQCWPcr kP6vmXRWLGofOFdkIhIzMow0XYvl5QiQyA23zS0678lA4CsJB0cqtgpRT ds2DPZrrtkHQ85XFdcZPuzmJfi6LBcQ2SDRrjkrKIYL0FJEzn91fsILKypFMu1AZAU3SU\/bvxCLzRQ==", "TraceId": "ff17f958-bcb7-4fc7-927b-1e3fbc8f4e34", "IsLCC": "1", "isoneway": "Yes", "isDomestic": "Yes", "IsDomesticReturn": "No", "Passengers": [ { "Title": "Mr", "FirstName": "test", "LastName": "test", "PaxType": "1", "DateOfBirth": "1996-06-30T00:00:00", "Gender": 1, "AddressLine1": "TheBookFlight TBF ONLINE PRIVATE LIMITED ", "AddressLine2": "", "City": "Delhi", "CountryCode": "IN", "CountryName": "India", "Nationality": "Indian", "ContactNo": "9650863349", "Email": "thebookflight@gmail.com", "IsLeadPax": true, "PassportNo": "", "PassportExpiry": "", "IsWheelchair": true, "Fare": { "Currency": "INR", "BaseFare": 1000, "Tax": 1383, "YQTax": 800, "AdditionalTxnFeePub": 0, "AdditionalTxnFeeOfrd": 0, "PGCharge": 0, "OtherCharges": 0, "Discount": 0, "PublishedFare": 2383, "CommissionEarned": 0, "PLBEarned": 0, "IncentiveEarned": 0, "OfferedFare": 2370.22, "TdsOnCommission": 0, "TdsOnPLB": 0, "TdsOnIncentive": 0, "ServiceFee": 0, "CFARAmount": 0, "DCFARAmount": 0, "ServiceFeeDisplayType": 0, "TotalBaggageCharges": 0, "TotalMealCharges": 0, "TotalSeatCharges": 0, "TotalSpecialServiceCharges": 0 }, "Baggage": [ { "AirlineCode": "6E", "FlightNumber": "873", "WayType": 2, "Code": "XBPE", "Description": 2, "Weight": 3, "Currency": "INR", "Price": 1515, "Origin": "DEL", "Destination": "BLR" } ], "SeatDynamic": [ { "AirlineCode": "6E", "FlightNumber": "873", "CraftType": "A321-220", "Origin": "DEL", "Destination": "BLR", "Code": "6A", "RowNo": "6", "SeatNo": "A", "SeatType": 1, "AvailablityType": 1, "Description": 2, "SeatWayType": 2, "Compartment": 2, "Deck": 1, "Currency": "INR", "Price": 805 } ], "MealDynamic": [ { "AirlineCode": "6E", "FlightNumber": "873", "WayType": 2, "Code": "VGAN", "Description": 2, "AirlineDescription": "Vegan Meal", "Quantity": 1, "Currency": "INR", "Price": 400, "Origin": "DEL", "Destination": "BLR" } ], "GSTCompanyAddress": null, "GSTCompanyContactNumber": null, "GSTCompanyName": null, "GSTNumber": null, "GSTCompanyEmail": null } ] }, "formatted_passengers": [ { "Title": "Mr", "FirstName": "test", "LastName": "test", "PaxType": "1", "DateOfBirth": "1996-06-30T00:00:00", "Gender": 1, "AddressLine1": "TheBookFlight TBF ONLINE PRIVATE LIMITED ", "AddressLine2": "", "City": "Delhi", "CountryCode": "IN", "CountryName": "India", "Nationality": "Indian", "ContactNo": "9650863349", "Email": "thebookflight@gmail.com", "IsLeadPax": true, "PassportNo": "", "PassportExpiry": "", "IsWheelchair": true, "Fare": { "Currency": "INR", "BaseFare": 1000, "Tax": 1383, "YQTax": 800, "AdditionalTxnFeePub": 0, "AdditionalTxnFeeOfrd": 0, "PGCharge": 0, "OtherCharges": 0, "Discount": 0, "PublishedFare": 2383, "CommissionEarned": 0, "PLBEarned": 0, "IncentiveEarned": 0, "OfferedFare": 2370.22, "TdsOnCommission": 0, "TdsOnPLB": 0, "TdsOnIncentive": 0, "ServiceFee": 0, "CFARAmount": 0, "DCFARAmount": 0, "ServiceFeeDisplayType": 0, "TotalBaggageCharges": 0, "TotalMealCharges": 0, "TotalSeatCharges": 0, "TotalSpecialServiceCharges": 0 }, "Baggage": [ { "AirlineCode": "6E", "FlightNumber": "873", "WayType": 2, "Code": "XBPE", "Description": 2, "Weight": 3, "Currency": "INR", "Price": 1515, "Origin": "DEL", "Destination": "BLR" } ], "SeatDynamic": [ { "AirlineCode": "6E", "FlightNumber": "873", "CraftType": "A321-220", "Origin": "DEL", "Destination": "BLR", "Code": "6A", "RowNo": "6", "SeatNo": "A", "SeatType": 1, "AvailablityType": 1, "Description": 2, "SeatWayType": 2, "Compartment": 2, "Deck": 1, "Currency": "INR", "Price": 805 } ], "MealDynamic": [ { "AirlineCode": "6E", "FlightNumber": "873", "WayType": 2, "Code": "VGAN", "Description": 2, "AirlineDescription": "Vegan Meal", "Quantity": 1, "Currency": "INR", "Price": 400, "Origin": "DEL", "Destination": "BLR" } ], "GSTCompanyAddress": null, "GSTCompanyContactNumber": null, "GSTCompanyName": null, "GSTNumber": null, "GSTCompanyEmail": null } ], "book_response": "{\"status\":\"Processing\"}", "ticket_response": { "Status": 7606, "status_message": "Oops something went wrong.Please contact support team.", "status_type": "Failed" }, "details_response": null, "poll_count": "150", "last_polled_at": "2026-06-03 16:30:03", "created_at": "2026-06-03 04:00:00", "updated_at": "2026-06-03 16:30:03", "email_sent": "Ticketing In Progress" }, { "id": "718", "order_ref": "TBF_F75ACE4F_1780484400_IB", "rzp_order_id": "order_Sx8NYxjAthMjfP", "rzp_payment_id": null, "rzp_signature": null, "payment_amount": "0", "payment_status": "created", "trace_id": "ff17f958-bcb7-4fc7-927b-1e3fbc8f4e34", "result_index": "IB1[TBO]2iTDyI51Phk9IOXjbjfTFYov l1lqo Rsa9OAlEnReCC0iEujJNlH7LKhKUCIfU5fCV2gEEt9FrdLtK8644 rZsAblzXu7xQ39E\/FYwuzlvd7URCGZSuYExq5bjbluV\/eVHdDaL60Vfr\/ooHs0zPENhVPOgMKwa8b63nE0KRmjy4yh\/FMpsPuWgA\/5L3M8bRRZl2 v3k4fnNgCJ1GdFhalpEZ tp9k9bOTW9xMP0ESdR4jnkGmq99PsElxzk6kW2PSaXOIIw\/YXPGr4zNrvjEk6IyTwAHB9 r2VNQTujj6BZ00K3hdjwgfgxgyx DTKHMhy\/qc1YFAvq\/3ReTVTm0YjzgznquY8n1kJP3QyIpZxyHhupy036CrYRdAFt7bgoOe6h4BpKSnWGXW9y nOzQW0sYHewEHvZtzi01H8UCOcrhMXbqnbcvSB\/r\/RvUiSG5FsJGgkcmQ82WIcOt7xZdLjuooa4Tr5Tq0T6873MpLkAYPn0WvEWhGqgHpYsaEzc9rRxZ1CZ8Gt0TwKVqPohoffayIJ3X7X0Hu DYyhX2mB2udpsdqZYtzequpGumJQKfA61x\/6QJ1VOpOeKyLFOlaXYHi5b3gZmAbIzCqmh8kgJgazW8DWFdHNOz wmAtp2aaCBrbUdz05 5TOT9gM1Hof0Et3FhfVPQz5n 9eitpTIH3idu1f7roF6cxwAgAIRRpq2SlgkYLJNi3GEDBScl4cwEAZfrMxbj xoRZwGqg7TQZ KsXU9OLip563znFOGD1ST8GeVE8se5 wtkFQ2WLza4unlTXMF0ozXZjaLF5rdGC9unSRYq0K55JX9nX01i2MjOOJtFY9lLbLYpnFLwBoXqvpxEH0WdcZsKdaDB9\/\/7dQ4vU4IW0JWgWTjEsC OGixfx o66NDhCDq9d0h3VksFeTYfYX93GMOiMDfvYv McXP8O3K9kiNLo6scGz3GENj4SG REdyGH2VR42ax5AIyBz8xPMBz8JvOtyxHjE=", "is_lcc": "1", "adivaha_booking_id": null, "pnr": null, "ticket_status": "Booking Pending Confirmation", "offline_booking": "0", "offline_message": "", "airline_code": "SG", "airline_name": "Spicejet", "flight_number": "529", "origin": "BLR", "destination": "DEL", "departure_time": "2026-06-24 05:05:00", "arrival_time": "2026-06-24 07:45:00", "trip_type": "roundtrip", "is_domestic": "1", "fare_total": "0.00", "lead_pax_name": "test test", "contact_email": "thebookflight@gmail.com", "contact_phone": "9650863349", "customer_ip": "202.140.128.11", "passenger_count": "1", "passenger_data": [ { "PaxType": "1", "Title": "Mr", "FirstName": "test", "LastName": "test" } ], "booking_payload": { "TraceId": "ff17f958-bcb7-4fc7-927b-1e3fbc8f4e34", "ResultIndex": "IB1[TBO]2iTDyI51Phk9IOXjbjfTFYov l1lqo Rsa9OAlEnReCC0iEujJNlH7LKhKUCIfU5fCV2gEEt9FrdLtK8644 rZsAblzXu7xQ39E\/FYwuzlvd7URCGZSuYExq5bjbluV\/eVHdDaL60Vfr\/ooHs0zPENhVPOgMKwa8b63nE0KRmjy4yh\/FMpsPuWgA\/5L3M8bRRZl2 v3k4fnNgCJ1GdFhalpEZ tp9k9bOTW9xMP0ESdR4jnkGmq99PsElxzk6kW2PSaXOIIw\/YXPGr4zNrvjEk6IyTwAHB9 r2VNQTujj6BZ00K3hdjwgfgxgyx DTKHMhy\/qc1YFAvq\/3ReTVTm0YjzgznquY8n1kJP3QyIpZxyHhupy036CrYRdAFt7bgoOe6h4BpKSnWGXW9y nOzQW0sYHewEHvZtzi01H8UCOcrhMXbqnbcvSB\/r\/RvUiSG5FsJGgkcmQ82WIcOt7xZdLjuooa4Tr5Tq0T6873MpLkAYPn0WvEWhGqgHpYsaEzc9rRxZ1CZ8Gt0TwKVqPohoffayIJ3X7X0Hu DYyhX2mB2udpsdqZYtzequpGumJQKfA61x\/6QJ1VOpOeKyLFOlaXYHi5b3gZmAbIzCqmh8kgJgazW8DWFdHNOz wmAtp2aaCBrbUdz05 5TOT9gM1Hof0Et3FhfVPQz5n 9eitpTIH3idu1f7roF6cxwAgAIRRpq2SlgkYLJNi3GEDBScl4cwEAZfrMxbj xoRZwGqg7TQZ KsXU9OLip563znFOGD1ST8GeVE8se5 wtkFQ2WLza4unlTXMF0ozXZjaLF5rdGC9unSRYq0K55JX9nX01i2MjOOJtFY9lLbLYpnFLwBoXqvpxEH0WdcZsKdaDB9\/\/7dQ4vU4IW0JWgWTjEsC OGixfx o66NDhCDq9d0h3VksFeTYfYX93GMOiMDfvYv McXP8O3K9kiNLo6scGz3GENj4SG REdyGH2VR42ax5AIyBz8xPMBz8JvOtyxHjE=", "IsLCC": true, "airlineCode": "SG", "airlineName": "Spicejet", "flightNumber": "529", "origin": "BLR", "destination": "DEL", "departureTime": "2026-06-24T05:05:00", "arrivalTime": "2026-06-24T07:45:00" }, "formatted_passengers": null, "book_response": null, "ticket_response": null, "details_response": null, "poll_count": "0", "last_polled_at": null, "created_at": "2026-06-03 04:00:00", "updated_at": "2026-06-03 04:00:00", "email_sent": null } ], "events": [ { "id": "3468", "order_ref": "TBF_F75ACE4F_1780484400", "event_type": "payment_created", "event_data": "{\"rzp_order_id\":\"order_Sx8NYxjAthMjfP\",\"amount_paise\":997780,\"flight_info\":\"6E DEL-BLR | SG BLR-DEL\"}", "created_at": "2026-06-03 04:00:00" }, { "id": "3469", "order_ref": "TBF_F75ACE4F_1780484400", "event_type": "book_sent", "event_data": "{\"action\":\"ticketForLcc\",\"isLCC\":true}", "created_at": "2026-06-03 04:00:37" }, { "id": "3470", "order_ref": "TBF_F75ACE4F_1780484400", "event_type": "pre_ticket_farequote_skipped_ob", "event_data": "{\"reason\":\"Extra FQ invalidates session → EC35\",\"ri_len\":992}", "created_at": "2026-06-03 04:00:37" }, { "id": "3471", "order_ref": "TBF_F75ACE4F_1780484400", "event_type": "ticket_lcc_sync_start", "event_data": "{\"action\":\"ticketForLcc\"}", "created_at": "2026-06-03 04:00:37" }, { "id": "3472", "order_ref": "TBF_F75ACE4F_1780484400", "event_type": "lcc_last_resort_recovery_start", "event_data": "{\"error_code\":0,\"wrapper\":7606}", "created_at": "2026-06-03 04:00:53" }, { "id": "3473", "order_ref": "TBF_F75ACE4F_1780484400", "event_type": "lcc_last_resort_recovery_no_pnr", "event_data": "[]", "created_at": "2026-06-03 04:00:56" }, { "id": "3474", "order_ref": "TBF_F75ACE4F_1780484400", "event_type": "ticket_lcc_provider_error", "event_data": "{\"error\":7606}", "created_at": "2026-06-03 04:00:56" } ], "logs": [] }