{
    "id": 5,
    "chat_id": "45db91c0-e992-11f0-bcf3-b57c1c76c6eb",
    "visitor_id": 5,
    "started_at": "2026-01-04 17:25:31",
    "ended_at": null,
    "status": "open",
    "channel": "tawk.to",
    "domain": "www.skyhost.pk",
    "country": null,
    "rating": 0,
    "raw_payload": "{\"id\": \"45db91c0-e992-11f0-bcf3-b57c1c76c6eb\", \"ip\": \"103.156.136.176\", \"type\": \"chat\", \"agents\": [], \"chatId\": \"45db91c0-e992-11f0-bcf3-b57c1c76c6eb\", \"domain\": \"www.skyhost.pk\", \"pageId\": \"58482e92f9976a1964ca2bf2\", \"rating\": 0, \"status\": \"open\", \"visitor\": {\"id\": \"58482e92f9976a1964ca2bf2-nERl3YfAlwQ27O7STS4P9\", \"name\": \"V1767489803276919\", \"email\": null}, \"location\": {\"city\": \"Karachi\", \"countryCode\": \"PK\"}, \"messages\": [{\"msg\": \"Department (Required) : Technical Support\\r\\nQuestion (Required) : which is IP address or Hostname using for connect database on skyhost to SSMS MSSQL Local\", \"time\": \"2026-01-04T17:25:31.415Z\", \"type\": \"msg\", \"sender\": {\"t\": \"v\"}}, {\"msg\": \"hello anyone there?\", \"time\": \"2026-01-04T17:26:13.473Z\", \"type\": \"msg\", \"sender\": {\"t\": \"v\"}}, {\"msg\": \"hello\", \"time\": \"2026-01-04T17:27:59.815Z\", \"type\": \"msg\", \"sender\": {\"t\": \"v\"}}, {\"data\": {\"url\": \"https://www.skyhost.pk/\", \"title\": \"Web Hosting in Pakistan | Cheap Web Hosting Companies | Web hosting Services | Hosting Server Plans\"}, \"time\": \"2026-01-04T17:28:57.704Z\", \"type\": \"nav\", \"sender\": {\"t\": \"v\"}}, {\"msg\": \"\\\"I am using ASP.NET 8 with MSSQL. I need to run a SQL script to create tables. Please provide access to 'myLittleAdmin' or 'WebSQL' in Plesk.\\\"\\n\\n\\\"Alternatively, please provide a Public/External IP and Port for remote SQL connection so I can connect via SSMS.\\\"\", \"time\": \"2026-01-04T17:37:53.663Z\", \"type\": \"msg\", \"sender\": {\"t\": \"v\"}}], \"personId\": \"6959c10b4233a8192c5798e4\", \"createdOn\": \"2026-01-04T17:25:31.415Z\", \"updatedOn\": \"2026-01-04T17:40:05.383Z\", \"propertyId\": \"58482e92f9976a1964ca2bf2\", \"property_id\": \"58482e92f9976a1964ca2bf2\", \"chatDuration\": 0, \"messageCount\": 4}",
    "created_at": "2026-06-28 07:33:13",
    "updated_at": "2026-06-28 07:33:13",
    "property_id": "58482e92f9976a1964ca2bf2",
    "city": null,
    "ip_address": "103.156.136.176",
    "message_count": 5,
    "chat_duration": null,
    "created_on": "2026-01-04 17:25:31",
    "updated_on": "2026-01-04 17:40:05",
    "deleted": 0,
    "visitor_name": "V1767489803276919",
    "visitor_email": null,
    "visitor_phone": null,
    "visitor_country": "",
    "visitor_city": "",
    "visitor_ip": "103.156.136.176",
    "messages": [
        {
            "id": 110,
            "chat_id": 5,
            "agent_id": null,
            "external_id": "d73949b96c2a7262a1e193b91f673d4faf62c6482576c542bad46e990577ade7",
            "sender_type": "visitor",
            "sender_name": null,
            "body": "Department (Required) : Technical Support\r\nQuestion (Required) : which is IP address or Hostname using for connect database on skyhost to SSMS MSSQL Local",
            "sent_at": "2026-01-04 17:25:31",
            "created_at": "2026-06-28 07:33:13",
            "property_id": null,
            "message_type": null,
            "raw_json": null,
            "agent_name": null,
            "agent_email": null
        },
        {
            "id": 111,
            "chat_id": 5,
            "agent_id": null,
            "external_id": "3d5c08531507dcff560b6e18c57d5f1fe3a9ff7957040b6d1d2b53afc72330f7",
            "sender_type": "visitor",
            "sender_name": null,
            "body": "hello anyone there?",
            "sent_at": "2026-01-04 17:26:13",
            "created_at": "2026-06-28 07:33:13",
            "property_id": null,
            "message_type": null,
            "raw_json": null,
            "agent_name": null,
            "agent_email": null
        },
        {
            "id": 112,
            "chat_id": 5,
            "agent_id": null,
            "external_id": "094fa26ee8d8d0be4d7a3e7ff0ee3726e9fd0e417af680889e1694adca833df4",
            "sender_type": "visitor",
            "sender_name": null,
            "body": "hello",
            "sent_at": "2026-01-04 17:27:59",
            "created_at": "2026-06-28 07:33:13",
            "property_id": null,
            "message_type": null,
            "raw_json": null,
            "agent_name": null,
            "agent_email": null
        },
        {
            "id": 113,
            "chat_id": 5,
            "agent_id": null,
            "external_id": "3a3b112bc023c73e5e03796e57452cb048b448a0df444ec03c6abe4e6cd0464f",
            "sender_type": "visitor",
            "sender_name": null,
            "body": "",
            "sent_at": "2026-01-04 17:28:57",
            "created_at": "2026-06-28 07:33:13",
            "property_id": null,
            "message_type": null,
            "raw_json": null,
            "agent_name": null,
            "agent_email": null
        },
        {
            "id": 114,
            "chat_id": 5,
            "agent_id": null,
            "external_id": "9a00671e3d44a9442b8f5ed85d54494e228f93a25af580df2e7f5b9b309aa909",
            "sender_type": "visitor",
            "sender_name": null,
            "body": "\"I am using ASP.NET 8 with MSSQL. I need to run a SQL script to create tables. Please provide access to 'myLittleAdmin' or 'WebSQL' in Plesk.\"\n\n\"Alternatively, please provide a Public/External IP and Port for remote SQL connection so I can connect via SSMS.\"",
            "sent_at": "2026-01-04 17:37:53",
            "created_at": "2026-06-28 07:33:13",
            "property_id": null,
            "message_type": null,
            "raw_json": null,
            "agent_name": null,
            "agent_email": null
        }
    ],
    "browser": "",
    "os": "",
    "first_visit_at": "2026-01-04 17:25:31",
    "tags": [],
    "agents": [],
    "attachments": [],
    "categories": [
        {
            "id": 2,
            "name": "cPanel",
            "slug": "cpanel",
            "created_at": "2026-06-28 08:33:23",
            "description": null,
            "keywords": null,
            "source": "rule",
            "status": "active",
            "updated_at": null,
            "merged_into_id": null
        }
    ],
    "visitor_chat_count": 3,
    "visitor_average_rating": "0"
}