# fm_tickets

ref: FM-200326-0EQN6
estate: Flat-44,Green house Building, Lane-3,PR Vihar, AV Square, BBSR
customer: Pratipada
source: webchat
priority: urgent
category: electrical
status: NEW
created_at: 2026-03-20 12:36:20
updated_at: 2026-03-20 12:36:20
summary:
  The light in my room is not working. The fan is working, but the bulb does not turn on. This started today.


ref: FM-CE04283B
estate: 18
unit: Oak Estate
customer: Prati
source: webchat
priority: urgent
category: general
status: NEW
created_at: 2026-03-23 11:32:16
updated_at: 2026-03-23 11:32:16
summary:
  Lift not functioning properly and has stopped working, causing difficulty for residents, especially elderly and children


# fm_conversations

ticket_ref: FM-060326-R65A3
sender: customer
source: whatsapp
created_at: 2026-03-06 10:40:28
body:
  My AC has been making a loud noise since last night and the cooling is very weak. I'm in Ikoyi Phase 2, Block A Flat 12.


ticket_ref: FM-160326-CVSRD
sender: customer
source: whatsapp
created_at: 2026-03-16 11:24:44
body:
  The lift in our building is not functioning properly and has stopped working. Residents are facing difficulty using the stairs, especially elderly people and children.


# fm_inbound_events

event_id: bce07e293986060076f35190b719b9aa
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-060326-R65A3
status: processed
received_at: 2026-03-06 10:40:28
processed_at: 2026-03-06 10:40:28
payload_json:
  {"_source": "whatsapp", "category": "hvac", "customer": "Jane Okonkwo", "estate": "Ikoyi Phase 2", "materials": "", "messages": [{"from": "customer", "text": "My AC has been making a loud noise since last night and the cooling is very weak. I'm in Ikoyi Phase 2, Block A Flat 12.", "ts": ""}], "priority": "normal", "summary": "AC making loud noise with weak cooling since last night.", "unit": "Block A Flat 12", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: 311747409e8baf5a9866d6bc93c9246f
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-060326-A8HXK
status: processed
received_at: 2026-03-06 10:43:57
processed_at: 2026-03-06 10:43:57
payload_json:
  {"_source": "whatsapp", "category": "plumbing", "customer": "Dev Test 1", "estate": "Century Building", "materials": "", "messages": [{"from": "customer", "text": "My plumbing is broken, the taps leak and i cant stop it I'm in Century Building, Block A Flat 12.", "ts": ""}], "priority": "urgent", "summary": "Plumbing broken with leaking taps that cannot be stopped.", "unit": "Block A Flat 12", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: c2ec6f5da639353f887564710ceb0317
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-060326-3FDEV
status: processed
received_at: 2026-03-06 10:45:41
processed_at: 2026-03-06 10:45:41
payload_json:
  {"_source": "whatsapp", "category": "hvac", "customer": "Pratipad", "estate": "Ikoyi Phase 2", "materials": "", "messages": [{"from": "customer", "text": "My AC is making a very loud noise and the cooling is weaker than normal.", "ts": ""}, {"from": "customer", "text": "It started last night. I am in Ikoyi Phase 2, Block A Flat 12.", "ts": ""}, {"from": "customer", "text": "No burning smell but the noise is constant. Can a technician come?", "ts": ""}, {"from": "customer", "text": "done", "ts": ""}], "priority": "normal", "summary": "AC making loud noise with weak cooling, started last night.", "unit": "Block A Flat 12", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: a1bcbb001db231e905b3e4c4b3ddfa47
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-160326-YTIHI
status: processed
received_at: 2026-03-16 06:12:54
processed_at: 2026-03-16 06:12:54
payload_json:
  {"_source": "whatsapp", "category": "general", "customer": "Sam", "estate": "", "materials": "", "messages": [{"from": "customer", "text": "Hello", "ts": ""}], "priority": "low", "summary": "Tenant initiated contact with no specific issue mentioned.", "unit": "", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: f7c1b9ed54e82b541b42b3bc65eaac8e
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-160326-2DZOE
status: processed
received_at: 2026-03-16 06:12:55
processed_at: 2026-03-16 06:12:55
payload_json:
  {"_source": "whatsapp", "category": "plumbing", "customer": "Pratipada Behera", "estate": "", "materials": "", "messages": [{"from": "customer", "text": "Water leak in Flat 3, it's very urgent", "ts": ""}], "priority": "urgent", "summary": "Water leak reported in Flat 3.", "unit": "Flat 3", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: f9faa439aa226b20b895affd5fa10959
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-160326-CVSRD
status: processed
received_at: 2026-03-16 11:24:44
processed_at: 2026-03-16 11:24:44
payload_json:
  {"_source": "whatsapp", "category": "general", "customer": "8114780031", "estate": "", "materials": "", "messages": [{"from": "customer", "text": "The lift in our building is not functioning properly and has stopped working. Residents are facing difficulty using the stairs, especially elderly people and children.", "ts": ""}], "priority": "normal", "summary": "Lift not functioning, causing difficulty for residents including elderly and children.", "unit": "", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: 385a52ba2bd6e1ab59cd7a8532cd8a15
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-170326-8IAX7
status: processed
received_at: 2026-03-17 10:06:17
processed_at: 2026-03-17 10:06:17
payload_json:
  {"_source": "whatsapp", "category": "electrical", "customer": "Test-02", "estate": "", "materials": "", "messages": [{"from": "customer", "text": "Electrical issue Flat 7", "ts": ""}], "priority": "normal", "summary": "Electrical issue reported in Flat 7.", "unit": "Flat 7", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: 920d652075c41ca2ef4808ce802e2be4
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-170326-UQWOW
status: processed
received_at: 2026-03-17 11:49:07
processed_at: 2026-03-17 11:49:07
payload_json:
  {"_source": "whatsapp", "category": "plumbing", "customer": "7846932854", "estate": "", "materials": "", "messages": [{"from": "customer", "text": "Water leak in Flat 3 urgent", "ts": ""}], "priority": "urgent", "summary": "Water leak reported in Flat 3.", "unit": "Flat 3", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: bafe39fed6744705c2311444e190d06d
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-180326-Y54Q7
status: processed
received_at: 2026-03-18 09:22:24
processed_at: 2026-03-18 09:22:24
payload_json:
  {"_session_id": 9, "_source": "whatsapp", "category": "plumbing", "customer": "Test-06", "estate": "", "issue": "Water leak in Flat 3 and lift not working.", "materials": "", "messages": [{"from": "customer", "text": "Lift not working", "ts": ""}, {"from": "customer", "text": "Water leak in Flat 3 urgent", "ts": ""}], "priority": "urgent", "summary": "Water leak in Flat 3 and lift not working.", "unit": "Flat 3", "urgency": "low", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: 2723d240f23601217ff11ef0cb51054a
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-180326-U0A9C
status: processed
received_at: 2026-03-18 09:24:06
processed_at: 2026-03-18 09:24:06
payload_json:
  {"_session_id": 10, "_source": "whatsapp", "category": "plumbing", "customer": "8114780030", "estate": "", "issue": "Water leak in Flat 3 and lift not working.", "materials": "", "messages": [{"from": "customer", "text": "Lift not working", "ts": ""}, {"from": "customer", "text": "Water leak in Flat 3 urgent", "ts": ""}], "priority": "urgent", "summary": "Water leak in Flat 3 and lift not working.", "unit": "Flat 3", "urgency": "low", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: 1cd592bccd9ef7c49fc3fbc0a9117396
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-180326-6CQGD
status: processed
received_at: 2026-03-18 13:17:49
processed_at: 2026-03-18 13:17:49
payload_json:
  {"_session_id": 11, "_source": "whatsapp", "category": "electrical", "customer": "pratipada", "estate": "", "issue": "Switchboard is sparking, tenant inquiring if it is dangerous.", "materials": "", "messages": [{"from": "customer", "text": "My switchboard is sparking. Is it dangerous", "ts": ""}], "priority": "urgent", "summary": "Switchboard is sparking, tenant inquiring if it is dangerous.", "unit": "", "urgency": "low", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: 11af1d18b97ceb819a5695edae1ba912
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-190326-8JSTZ
status: processed
received_at: 2026-03-19 12:35:16
processed_at: 2026-03-19 12:35:16
payload_json:
  {"_session_id": 12, "_source": "whatsapp", "category": "electrical", "customer": "Test-10", "estate": "", "issue": "Power outage in one room, potentially affecting critical medical equipment.", "materials": "", "messages": [{"from": "customer", "text": "The power is out in one room. this affecting anything critical like medical equipment.", "ts": ""}], "priority": "urgent", "summary": "Power outage in one room, potentially affecting critical medical equipment.", "unit": "", "urgency": "low", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: 18f55b4a5f17a06c8667b4bfe28b85c7
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-200326-42WK6
status: processed
received_at: 2026-03-20 07:07:45
processed_at: 2026-03-20 07:07:45
payload_json:
  {"_session_id": 13, "_source": "whatsapp", "category": "electrical", "customer": "8114780031", "estate": "", "issue": "Frequent power cuts in the house.", "materials": "", "messages": [{"from": "customer", "text": "Frequent power cuts in my house.", "ts": ""}], "priority": "urgent", "summary": "Frequent power cuts in the house.", "unit": "", "urgency": "low", "source": "whatsapp_json", "type": "whatsapp_json.import"}


event_id: 7b1ff2ebbbc9d21afc1c3791c6af96ed
source: manual
event_type: ticket.updated
ticket_ref: FM-180326-U0A9C
status: processed
received_at: 2026-03-20 07:12:48
processed_at: 2026-03-20 07:12:48
payload_json:
  {"estate": "", "unit": "Flat 3", "customer": "8114780030", "status": "NEW", "priority": "urgent", "category": "plumbing", "assignee": "", "summary": "Water leak in Flat 3 and lift not working.", "materials": "", "location_note": ""}


event_id: 607aa69193b66b8539d15882264d42ff
source: whatsapp_json
event_type: whatsapp_json.import
ticket_ref: FM-230326-T6EKE
status: processed
received_at: 2026-03-23 09:20:19
processed_at: 2026-03-23 09:20:19
payload_json:
  {"_session_id": 14, "_source": "whatsapp", "category": "general", "customer": "8114780031", "estate": "", "issue": "Lift not functioning, causing difficulty for residents including elderly and children.", "materials": "", "messages": [{"from": "customer", "text": "The lift in our building is not functioning properly and has stopped working. Residents are facing difficulty using the stairs, especially elderly people and children.", "ts": ""}], "priority": "normal", "summary": "Lift not functioning, causing difficulty for residents including elderly and children.", "unit": "", "urgency": "low", "source": "whatsapp_json", "type": "whatsapp_json.import"}


# wa_sessions

wa_from: whatsapp:+2348012345678
wa_to: whatsapp:+14155238886
display_name: Jane Okonkwo
status: done
ticket_ref: FM-060326-R65A3
last_message_at: 2026-03-06 10:35:01
created_at: 2026-03-06 10:35:01
flushed_at: 2026-03-06 10:40:21
flush_trigger: timeout
deepseek_response:
  {"customer": "Jane Okonkwo", "estate": "Ikoyi Phase 2", "unit": "Block A Flat 12", "summary": "AC making loud noise with weak cooling since last night.", "priority": "normal", "category": "hvac", "materials": "", "messages": [{"from": "customer", "text": "My AC has been making a loud noise since last night and the cooling is very weak. I'm in Ikoyi Phase 2, Block A Flat 12.", "ts": ""}]}


wa_from: whatsapp:+4407904269607
wa_to: whatsapp:+14155238886
display_name: Dev Test 1
status: done
ticket_ref: FM-060326-A8HXK
last_message_at: 2026-03-06 10:38:50
created_at: 2026-03-06 10:38:50
flushed_at: 2026-03-06 10:43:51
flush_trigger: manual
deepseek_response:
  {"customer": "Dev Test 1", "estate": "Century Building", "unit": "Block A Flat 12", "summary": "Plumbing broken with leaking taps that cannot be stopped.", "priority": "urgent", "category": "plumbing", "materials": "", "messages": [{"from": "customer", "text": "My plumbing is broken, the taps leak and i cant stop it I'm in Century Building, Block A Flat 12.", "ts": ""}]}


wa_from: whatsapp:8114780031
wa_to: whatsapp:+14155238886
display_name: Pratipad
status: done
ticket_ref: FM-060326-3FDEV
last_message_at: 2026-03-06 10:45:32
created_at: 2026-03-06 10:45:28
flushed_at: 2026-03-06 10:45:32
flush_trigger: keyword
deepseek_response:
  {"customer": "Pratipad", "estate": "Ikoyi Phase 2", "unit": "Block A Flat 12", "summary": "AC making loud noise with weak cooling, started last night.", "priority": "normal", "category": "hvac", "materials": "", "messages": [{"from": "customer", "text": "My AC is making a very loud noise and the cooling is weaker than normal.", "ts": ""}, {"from": "customer", "text": "It started last night. I am in Ikoyi Phase 2, Block A Flat 12.", "ts": ""}, {"from": "customer", "text": "No burning smell but the noise is constant. Can a technician come?", "ts": ""}, {"from": "customer", "text": "done", "ts": ""}]}


wa_from: whatsapp:+447944269607
wa_to: whatsapp:+14155238886
display_name: Sam
status: done
ticket_ref: FM-160326-YTIHI
last_message_at: 2026-03-06 11:14:02
created_at: 2026-03-06 11:14:02
flushed_at: 2026-03-16 06:12:48
flush_trigger: timeout
deepseek_response:
  {"customer": "Sam", "estate": "", "unit": "", "summary": "Tenant initiated contact with no specific issue mentioned.", "priority": "low", "category": "general", "materials": "", "messages": [{"from": "customer", "text": "Hello", "ts": ""}]}


wa_from: whatsapp:+918114780031
wa_to: whatsapp:+14155238886
display_name: Pratipada Behera
status: done
ticket_ref: FM-160326-2DZOE
last_message_at: 2026-03-06 11:14:30
created_at: 2026-03-06 11:14:30
flushed_at: 2026-03-16 06:12:48
flush_trigger: timeout
deepseek_response:
  {"customer": "Pratipada Behera", "estate": "", "unit": "Flat 3", "summary": "Water leak reported in Flat 3.", "priority": "urgent", "category": "plumbing", "materials": "", "messages": [{"from": "customer", "text": "Water leak in Flat 3, it's very urgent", "ts": ""}]}


wa_from: whatsapp:8114780031
wa_to: whatsapp:+14155238886
display_name: Test- 16-03-2026
status: done
ticket_ref: FM-160326-CVSRD
last_message_at: 2026-03-16 11:24:19
created_at: 2026-03-16 11:24:19
flushed_at: 2026-03-16 11:24:37
flush_trigger: manual
deepseek_response:
  {"customer": "8114780031", "estate": "", "unit": "", "summary": "Lift not functioning, causing difficulty for residents including elderly and children.", "priority": "normal", "category": "general", "materials": "", "messages": [{"from": "customer", "text": "The lift in our building is not functioning properly and has stopped working. Residents are facing difficulty using the stairs, especially elderly people and children.", "ts": ""}]}


wa_from: whatsapp:8114780031
wa_to: whatsapp:+14155238886
display_name: Test-02
status: done
ticket_ref: FM-170326-8IAX7
last_message_at: 2026-03-17 10:06:07
created_at: 2026-03-17 10:06:07
flushed_at: 2026-03-17 10:06:13
flush_trigger: manual
deepseek_response:
  {"customer": "Test-02", "estate": "", "unit": "Flat 7", "summary": "Electrical issue reported in Flat 7.", "priority": "normal", "category": "electrical", "materials": "", "messages": [{"from": "customer", "text": "Electrical issue Flat 7", "ts": ""}]}


wa_from: whatsapp:7846932854
wa_to: whatsapp:+14155238886
display_name: Test-05
status: done
ticket_ref: FM-170326-UQWOW
last_message_at: 2026-03-17 11:48:28
created_at: 2026-03-17 11:48:28
flushed_at: 2026-03-17 11:49:02
flush_trigger: manual
deepseek_response:
  {"customer": "7846932854", "estate": "", "unit": "Flat 3", "summary": "Water leak reported in Flat 3.", "priority": "urgent", "category": "plumbing", "materials": "", "messages": [{"from": "customer", "text": "Water leak in Flat 3 urgent", "ts": ""}]}


wa_from: whatsapp:8114780031
wa_to: whatsapp:+14155238886
display_name: Test-06
status: done
ticket_ref: FM-180326-Y54Q7
last_message_at: 2026-03-18 09:21:17
created_at: 2026-03-18 09:21:17
flushed_at: 2026-03-18 09:22:18
flush_trigger: manual
deepseek_response:
  {"customer": "Test-06", "estate": "", "unit": "Flat 3", "summary": "Water leak in Flat 3 and lift not working.", "priority": "urgent", "category": "plumbing", "materials": "", "messages": [{"from": "customer", "text": "Lift not working", "ts": ""}, {"from": "customer", "text": "Water leak in Flat 3 urgent", "ts": ""}]}


wa_from: whatsapp:8114780030
wa_to: whatsapp:+14155238886
display_name: Test-06
status: done
ticket_ref: FM-180326-U0A9C
last_message_at: 2026-03-18 09:23:55
created_at: 2026-03-18 09:23:55
flushed_at: 2026-03-18 09:24:01
flush_trigger: manual
deepseek_response:
  {"customer": "8114780030", "estate": "", "unit": "Flat 3", "summary": "Water leak in Flat 3 and lift not working.", "priority": "urgent", "category": "plumbing", "materials": "", "messages": [{"from": "customer", "text": "Lift not working", "ts": ""}, {"from": "customer", "text": "Water leak in Flat 3 urgent", "ts": ""}]}


wa_from: whatsapp:8114780031
wa_to: whatsapp:+14155238886
display_name: pratipada
status: done
ticket_ref: FM-180326-6CQGD
last_message_at: 2026-03-18 13:16:37
created_at: 2026-03-18 13:16:37
flushed_at: 2026-03-18 13:17:45
flush_trigger: manual
deepseek_response:
  {"customer": "pratipada", "estate": "", "unit": "", "summary": "Switchboard is sparking, tenant inquiring if it is dangerous.", "priority": "urgent", "category": "electrical", "materials": "", "messages": [{"from": "customer", "text": "My switchboard is sparking. Is it dangerous", "ts": ""}]}


wa_from: whatsapp:8114780031
wa_to: whatsapp:+14155238886
display_name: Test-10
status: done
ticket_ref: FM-190326-8JSTZ
last_message_at: 2026-03-19 12:34:28
created_at: 2026-03-19 12:34:28
flushed_at: 2026-03-19 12:35:11
flush_trigger: manual
deepseek_response:
  {"customer": "Test-10", "estate": "", "unit": "", "summary": "Power outage in one room, potentially affecting critical medical equipment.", "priority": "urgent", "category": "electrical", "materials": "", "messages": [{"from": "customer", "text": "The power is out in one room. this affecting anything critical like medical equipment.", "ts": ""}]}


wa_from: whatsapp:8114780031
wa_to: whatsapp:+14155238886
display_name: Test-1
status: done
ticket_ref: FM-200326-42WK6
last_message_at: 2026-03-20 07:07:20
created_at: 2026-03-20 07:07:20
flushed_at: 2026-03-20 07:07:25
flush_trigger: manual
deepseek_response:
  {"customer": "8114780031", "estate": "", "unit": "", "summary": "Frequent power cuts in the house.", "priority": "urgent", "category": "electrical", "materials": "", "messages": [{"from": "customer", "text": "Frequent power cuts in my house.", "ts": ""}]}


