SQLite Web: db.sqlite

Update row 454 in inbox_raw

id

Primary key. INTEGER

source

TEXT NOT NULL

payload

{"external_id":"88793374","property_id":131309,"room_id":293385,"room_name":"Chambre Papaye","group_id":"bm9sYW5lX18yMDI2","group_type":"heuristic","guest_name":"Nolane","guest_email":"","guest_phone":null,"check_in":"2026-06-26","check_out":"2026-06-28","total_price":237.69,"commission":54.31,"status":"inquiry","substatus":"none","source":"Airbnb","api_reference":"HMZKP3J2FW","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-06-25T07:46:02.894Z","raw_modified_time":"2026-06-25T07:45:49Z","payload_json":"{\"timeStamp\":\"2026-06-25T07:46:02Z\",\"booking\":{\"id\":88793374,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293385,\"unitId\":1,\"roomQty\":1,\"offerId\":0,\"status\":\"inquiry\",\"subStatus\":\"none\",\"arrival\":\"2026-06-26\",\"departure\":\"2026-06-28\",\"numAdult\":6,\"numChild\":0,\"title\":\"\",\"firstName\":\"Nolane\",\"lastName\":\"\",\"email\":\"\",\"phone\":\"\",\"mobile\":\"\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"fr\",\"country2\":\"FR\",\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"Booked Maison Kapokier · House with a beautiful sea's view at Saint-Pierre - 327594\\n\",\"message\":\"\",\"groupNote\":\"\",\"custom1\":\"\",\"custom2\":\"\",\"custom3\":\"\",\"custom4\":\"\",\"custom5\":\"\",\"custom6\":\"\",\"custom7\":\"\",\"custom8\":\"\",\"custom9\":\"\",\"custom10\":\"\",\"flagColor\":\"ffaad4\",\"flagText\":\"\",\"statusCode\":0,\"lang\":\"fr\",\"referer\":\"Airbnb\",\"refererEditable\":\"Airbnb\",\"reference\":\"\",\"channel\":\"airbnb\",\"apiSourceId\":46,\"apiSource\":\"Airbnb\",\"apiReference\":\"HMZKP3J2FW\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-06-24T18:16:16Z\",\"modifiedTime\":\"2026-06-25T07:45:49Z\",\"cancelTime\":null,\"price\":237.69,\"deposit\":0,\"tax\":0,\"commission\":54.31,\"rateDescription\":\"Cancel policy moderate\\nBase Price 292 EUR\\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 10.22 EUR\\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 1.02 EUR\\nHost Fee -54.31 EUR\\nExpected Payout Amount 237.69 EUR\\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":161723220,\"bookingId\":88793374,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":292,\"lineTotal\":292,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-24T18:16:16Z\"},{\"id\":161723221,\"bookingId\":88793374,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":-54.31,\"lineTotal\":-54.31,\"vatRate\":0.2,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-24T18:16:16Z\"}],\"messages\":[{\"id\":153466053,\"authorOwnerId\":null,\"bookingId\":88793374,\"time\":\"2026-06-24T18:16:22Z\",\"read\":false,\"message\":\"Bonjour Carl nous sommes intéressés pour un week-end détente après nos examens\",\"source\":\"guest\"},{\"id\":153471024,\"authorOwnerId\":null,\"bookingId\":88793374,\"time\":\"2026-06-24T19:15:13Z\",\"read\":false,\"message\":\"Serait-il possible d’avoir une réponse dès que possible concernant notre demande ? Si jamais le logement n’est finalement pas disponible ou si vous ne pouvez pas accepter la réservation, nous devrons rapidement nous organiser et trouver une autre solution pour ce week-end.\\nNous comprenons bien sûr que vous puissiez être occupé, mais une réponse rapide nous aiderait énormément.\\nMerci beaucoup pour votre compréhension\",\"source\":\"guest\"},{\"id\":153499253,\"authorOwnerId\":null,\"bookingId\":88793374,\"time\":\"2026-06-25T00:48:47Z\",\"read\":false,\"message\":\"??\",\"source\":\"guest\"}],\"retries\":0}","event_id":"evt_1782373562895_5gqf72","should_notify":1,"dedupe_key":"0f4cd3b782d9885c9c1102ef6dcc68e172d409def3ab1875ba050e2fb253c5fa"}

TEXT NOT NULL

received_at

DATETIME (default CURRENT_TIMESTAMP

processed

BOOLEAN (default 0

processed_at

DATETIME

error

TEXT

dedupe_key

TEXT

payload_json

{"external_id":"88793374","property_id":131309,"room_id":293385,"room_name":"Chambre Papaye","group_id":"bm9sYW5lX18yMDI2","group_type":"heuristic","guest_name":"Nolane","guest_email":"","guest_phone":null,"check_in":"2026-06-26","check_out":"2026-06-28","total_price":237.69,"commission":54.31,"status":"inquiry","substatus":"none","source":"Airbnb","api_reference":"HMZKP3J2FW","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-06-25T07:46:02.894Z","raw_modified_time":"2026-06-25T07:45:49Z","payload_json":"{\"timeStamp\":\"2026-06-25T07:46:02Z\",\"booking\":{\"id\":88793374,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293385,\"unitId\":1,\"roomQty\":1,\"offerId\":0,\"status\":\"inquiry\",\"subStatus\":\"none\",\"arrival\":\"2026-06-26\",\"departure\":\"2026-06-28\",\"numAdult\":6,\"numChild\":0,\"title\":\"\",\"firstName\":\"Nolane\",\"lastName\":\"\",\"email\":\"\",\"phone\":\"\",\"mobile\":\"\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"fr\",\"country2\":\"FR\",\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"Booked Maison Kapokier · House with a beautiful sea's view at Saint-Pierre - 327594\\n\",\"message\":\"\",\"groupNote\":\"\",\"custom1\":\"\",\"custom2\":\"\",\"custom3\":\"\",\"custom4\":\"\",\"custom5\":\"\",\"custom6\":\"\",\"custom7\":\"\",\"custom8\":\"\",\"custom9\":\"\",\"custom10\":\"\",\"flagColor\":\"ffaad4\",\"flagText\":\"\",\"statusCode\":0,\"lang\":\"fr\",\"referer\":\"Airbnb\",\"refererEditable\":\"Airbnb\",\"reference\":\"\",\"channel\":\"airbnb\",\"apiSourceId\":46,\"apiSource\":\"Airbnb\",\"apiReference\":\"HMZKP3J2FW\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-06-24T18:16:16Z\",\"modifiedTime\":\"2026-06-25T07:45:49Z\",\"cancelTime\":null,\"price\":237.69,\"deposit\":0,\"tax\":0,\"commission\":54.31,\"rateDescription\":\"Cancel policy moderate\\nBase Price 292 EUR\\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 10.22 EUR\\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 1.02 EUR\\nHost Fee -54.31 EUR\\nExpected Payout Amount 237.69 EUR\\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":161723220,\"bookingId\":88793374,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":292,\"lineTotal\":292,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-24T18:16:16Z\"},{\"id\":161723221,\"bookingId\":88793374,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":-54.31,\"lineTotal\":-54.31,\"vatRate\":0.2,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-24T18:16:16Z\"}],\"messages\":[{\"id\":153466053,\"authorOwnerId\":null,\"bookingId\":88793374,\"time\":\"2026-06-24T18:16:22Z\",\"read\":false,\"message\":\"Bonjour Carl nous sommes intéressés pour un week-end détente après nos examens\",\"source\":\"guest\"},{\"id\":153471024,\"authorOwnerId\":null,\"bookingId\":88793374,\"time\":\"2026-06-24T19:15:13Z\",\"read\":false,\"message\":\"Serait-il possible d’avoir une réponse dès que possible concernant notre demande ? Si jamais le logement n’est finalement pas disponible ou si vous ne pouvez pas accepter la réservation, nous devrons rapidement nous organiser et trouver une autre solution pour ce week-end.\\nNous comprenons bien sûr que vous puissiez être occupé, mais une réponse rapide nous aiderait énormément.\\nMerci beaucoup pour votre compréhension\",\"source\":\"guest\"},{\"id\":153499253,\"authorOwnerId\":null,\"bookingId\":88793374,\"time\":\"2026-06-25T00:48:47Z\",\"read\":false,\"message\":\"??\",\"source\":\"guest\"}],\"retries\":0}","event_id":"evt_1782373562895_5gqf72","should_notify":1,"dedupe_key":"0f4cd3b782d9885c9c1102ef6dcc68e172d409def3ab1875ba050e2fb253c5fa"}

TEXT

Cancel