SQLite Web: db.sqlite

id

Primary key. INTEGER

source

TEXT NOT NULL

payload

{"external_id":"86783635","property_id":131309,"room_id":293385,"room_name":"Chambre Papaye","group_id":null,"group_type":null,"guest_name":"Lucas Sappey","guest_email":"","guest_phone":"33695691978","check_in":"2026-05-14","check_out":"2026-05-16","total_price":122.1,"commission":27.9,"status":"confirmed","substatus":"none","source":"Airbnb","api_reference":"HM8DRZDNYE","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-05-14T13:06:28.004Z","raw_modified_time":"2026-05-14T13:06:22Z","payload_json":"{\"timeStamp\":\"2026-05-14T13:06:27Z\",\"booking\":{\"id\":86783635,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293385,\"unitId\":1,\"roomQty\":1,\"offerId\":0,\"status\":\"confirmed\",\"subStatus\":\"none\",\"arrival\":\"2026-05-14\",\"departure\":\"2026-05-16\",\"numAdult\":2,\"numChild\":0,\"title\":\"\",\"firstName\":\"Lucas\",\"lastName\":\"Sappey\",\"email\":\"\",\"phone\":\"33695691978\",\"mobile\":\"\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"fr\",\"country2\":\"FR\",\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"Note: price less than room min price 65.00\\nBooked 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\":\"HM8DRZDNYE\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-05-14T12:24:35Z\",\"modifiedTime\":\"2026-05-14T13:06:22Z\",\"cancelTime\":null,\"price\":122.1,\"deposit\":0,\"tax\":0,\"commission\":27.9,\"rateDescription\":\"Cancel policy moderate\\nBase Price 150 EUR\\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 0.52 EUR\\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 5.25 EUR\\nHost Fee -27.90 EUR\\nExpected Payout Amount 122.10 EUR\\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":157377645,\"bookingId\":86783635,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":150,\"lineTotal\":150,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-05-14T12:24:35Z\"},{\"id\":157377646,\"bookingId\":86783635,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":-27.9,\"lineTotal\":-27.9,\"vatRate\":0.2,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-05-14T12:24:35Z\"}],\"messages\":[{\"id\":147492801,\"authorOwnerId\":null,\"bookingId\":86783635,\"time\":\"2026-05-14T12:24:39Z\",\"read\":false,\"message\":\"Bonjour Carl, ma partenaire et moi venons chez vous pour visiter le nord de la Martinique pendant 2 jours. Nous arrivons de Paris ce soir vers 18h à l’aéroport ?\",\"source\":\"guest\"}],\"retries\":0}","event_id":"evt_1778763988004_2spem5","should_notify":1,"dedupe_key":"186bd9ed1dff15b71d8c7ba38185697c87360b7b9854d645ac64b1109a9c6159"}

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":"86783635","property_id":131309,"room_id":293385,"room_name":"Chambre Papaye","group_id":null,"group_type":null,"guest_name":"Lucas Sappey","guest_email":"","guest_phone":"33695691978","check_in":"2026-05-14","check_out":"2026-05-16","total_price":122.1,"commission":27.9,"status":"confirmed","substatus":"none","source":"Airbnb","api_reference":"HM8DRZDNYE","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-05-14T13:06:28.004Z","raw_modified_time":"2026-05-14T13:06:22Z","payload_json":"{\"timeStamp\":\"2026-05-14T13:06:27Z\",\"booking\":{\"id\":86783635,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293385,\"unitId\":1,\"roomQty\":1,\"offerId\":0,\"status\":\"confirmed\",\"subStatus\":\"none\",\"arrival\":\"2026-05-14\",\"departure\":\"2026-05-16\",\"numAdult\":2,\"numChild\":0,\"title\":\"\",\"firstName\":\"Lucas\",\"lastName\":\"Sappey\",\"email\":\"\",\"phone\":\"33695691978\",\"mobile\":\"\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"fr\",\"country2\":\"FR\",\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"Note: price less than room min price 65.00\\nBooked 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\":\"HM8DRZDNYE\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-05-14T12:24:35Z\",\"modifiedTime\":\"2026-05-14T13:06:22Z\",\"cancelTime\":null,\"price\":122.1,\"deposit\":0,\"tax\":0,\"commission\":27.9,\"rateDescription\":\"Cancel policy moderate\\nBase Price 150 EUR\\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 0.52 EUR\\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 5.25 EUR\\nHost Fee -27.90 EUR\\nExpected Payout Amount 122.10 EUR\\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":157377645,\"bookingId\":86783635,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":150,\"lineTotal\":150,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-05-14T12:24:35Z\"},{\"id\":157377646,\"bookingId\":86783635,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":-27.9,\"lineTotal\":-27.9,\"vatRate\":0.2,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-05-14T12:24:35Z\"}],\"messages\":[{\"id\":147492801,\"authorOwnerId\":null,\"bookingId\":86783635,\"time\":\"2026-05-14T12:24:39Z\",\"read\":false,\"message\":\"Bonjour Carl, ma partenaire et moi venons chez vous pour visiter le nord de la Martinique pendant 2 jours. Nous arrivons de Paris ce soir vers 18h à l’aéroport ?\",\"source\":\"guest\"}],\"retries\":0}","event_id":"evt_1778763988004_2spem5","should_notify":1,"dedupe_key":"186bd9ed1dff15b71d8c7ba38185697c87360b7b9854d645ac64b1109a9c6159"}

TEXT

Update row 360 in inbox_raw