---
title: "ConversationByWebsiteIdAndSessionId (Crisp)"
description: "Conversation Data"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/crisp/Crisp.Crisp.ConversationByWebsiteIdAndSessionId
original: https://documentation.invantive.eu/en/datamodels/crisp/Crisp.Crisp.ConversationByWebsiteIdAndSessionId
updated: 2026-11-01T16:30:21Z
license: https://documentation.invantive.eu/en/
---

# ConversationByWebsiteIdAndSessionId: Crisp Conversation Data

`read only` `REST`

- Catalog: `Crisp`
- Schema: `Crisp`
- Primary Keys: `session_id`
- Label: Conversation Data

Can only retrieve data.

## Summary

One conversation of a website, retrieved by session identifier.

## API Source

- Endpoint: `/website/{website_id}/conversation/{session_id}`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `session_id` | `varchar2` | [x] |  | The conversation session identifier. |
| `website_id` | `varchar2` | [ ] |  | The website identifier. Defaults to the website ID of the connection when left out. |

## Table Columns

The columns of the table `ConversationByWebsiteIdAndSessionId` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `active_last` | `datetime` | itgen_crp_active_last | [ ] | filters on the platform, writable, `active.last` | Timestamp at which the user was last active. |
| `active_now` | `char` | itgen_crp_active_now | [x] | filters on the platform, writable, `active.now` | Whether user is considered active right now or not. |
| `assigned_user_id` | `varchar2` | itgen_crp_assigned_user_id | [ ] | filters on the platform, writable, `assigned.user_id` | Operator user identifier. |
| `availability` | `varchar2` | itgen_crp_availability | [x] | filters on the platform, writable | Visitor availability; one of online and offline. |
| `compose_operator_automated` | `char` | itgen_crp_compose_operator_automated | [ ] | filters on the platform, writable, `compose.operator.automated` | Whether compose is automated or not (ie. comes from a bot). |
| `compose_operator_excerpt` | `varchar2` | itgen_crp_compose_operator_excerpt | [ ] | filters on the platform, writable, `compose.operator.excerpt` | Message excerpt for compose state. |
| `compose_operator_timestamp` | `datetime` | itgen_crp_compose_operator_timestamp | [ ] | filters on the platform, writable, `compose.operator.timestamp` | Timestamp for compose state. |
| `compose_operator_type` | `varchar2` | itgen_crp_compose_operator_type | [ ] | filters on the platform, writable, `compose.operator.type` | Compose state type; one of start and stop. |
| `compose_operator_user_avatar` | `varchar2` | itgen_crp_compose_operator_user_avatar | [ ] | filters on the platform, writable, `compose.operator.user.avatar` | Compose user avatar. |
| `compose_operator_user_nickname` | `varchar2` | itgen_crp_compose_operator_user_nickname | [ ] | filters on the platform, writable, `compose.operator.user.nickname` | Compose user nickname. |
| `compose_operator_user_user_id` | `varchar2` | itgen_crp_compose_operator_user_user_id | [ ] | filters on the platform, writable, `compose.operator.user.user_id` | Compose user identifier. |
| `compose_visitor_automated` | `char` | itgen_crp_compose_visitor_automated | [ ] | filters on the platform, writable, `compose.visitor.automated` | Whether compose is automated or not (ie. comes from a bot). |
| `compose_visitor_excerpt` | `varchar2` | itgen_crp_compose_visitor_excerpt | [ ] | filters on the platform, writable, `compose.visitor.excerpt` | Message excerpt for compose state. |
| `compose_visitor_timestamp` | `datetime` | itgen_crp_compose_visitor_timestamp | [ ] | filters on the platform, writable, `compose.visitor.timestamp` | Timestamp for compose state. |
| `compose_visitor_type` | `varchar2` | itgen_crp_compose_visitor_type | [ ] | filters on the platform, writable, `compose.visitor.type` | Compose state type; one of start and stop. |
| `created_at` | `datetime` | itgen_crp_created_at | [x] | filters on the platform, writable | Conversation creation timestamp. |
| `inbox_id` | `varchar2` | itgen_crp_inbox_id | [ ] | filters on the platform, writable | Inbox identifier. |
| `is_blocked` | `char` | itgen_crp_is_blocked | [x] | filters on the platform, writable | Whether session is blocked or not (block messages from visitor). |
| `is_verified` | `char` | itgen_crp_is_verified | [ ] | filters on the platform, writable | Whether session is verified or not (user email ownership is authenticated). |
| `last_message` | `varchar2` | itgen_crp_last_message | [ ] | filters on the platform, writable | Last message excerpt (from visitor). |
| `meta_address` | `varchar2` | itgen_crp_meta_address | [ ] | filters on the platform, writable, `meta.address` | Visitor address. |
| `meta_avatar` | `varchar2` | itgen_crp_meta_avatar | [ ] | filters on the platform, writable, `meta.avatar` | Visitor avatar. |
| `meta_connection_asn` | `varchar2` | itgen_crp_meta_connection_asn | [ ] | filters on the platform, writable, `meta.connection.asn` | Autonomous system number, derived by Crisp from the IP address. |
| `meta_connection_isp` | `varchar2` | itgen_crp_meta_connection_isp | [ ] | filters on the platform, writable, `meta.connection.isp` | Name of the internet service provider, derived by Crisp from the IP address. |
| `meta_data` | `varchar2` | itgen_crp_meta_data | [ ] | filters on the platform, writable, `meta.data` | Visitor data as JSON. |
| `meta_device_geolocation_city` | `varchar2` | itgen_crp_meta_device_geolocation_city | [ ] | filters on the platform, writable, `meta.device.geolocation.city` | City name. |
| `meta_device_geolocation_coordinates_latitude` | `decimal` | itgen_crp_meta_device_geolocation_coordinates_latitude | [ ] | filters on the platform, writable, `meta.device.geolocation.coordinates.latitude` | Latitude coordinate. |
| `meta_device_geolocation_coordinates_longitude` | `decimal` | itgen_crp_meta_device_geolocation_coordinates_longitude | [ ] | filters on the platform, writable, `meta.device.geolocation.coordinates.longitude` | Longitude coordinate. |
| `meta_device_geolocation_country` | `varchar2` | itgen_crp_meta_device_geolocation_country | [ ] | filters on the platform, writable, `meta.device.geolocation.country` | Country code. |
| `meta_device_geolocation_region` | `varchar2` | itgen_crp_meta_device_geolocation_region | [ ] | filters on the platform, writable, `meta.device.geolocation.region` | Region code. |
| `meta_device_system_browser_major` | `varchar2` | itgen_crp_meta_device_system_browser_major | [ ] | filters on the platform, writable, `meta.device.system.browser.major` | Browser major version (eg: version 8.1 has a major of 8). |
| `meta_device_system_browser_name` | `varchar2` | itgen_crp_meta_device_system_browser_name | [ ] | filters on the platform, writable, `meta.device.system.browser.name` | Browser name. |
| `meta_device_system_browser_version` | `varchar2` | itgen_crp_meta_device_system_browser_version | [ ] | filters on the platform, writable, `meta.device.system.browser.version` | Browser version. |
| `meta_device_system_engine_name` | `varchar2` | itgen_crp_meta_device_system_engine_name | [ ] | filters on the platform, writable, `meta.device.system.engine.name` | Engine name. |
| `meta_device_system_engine_version` | `varchar2` | itgen_crp_meta_device_system_engine_version | [ ] | filters on the platform, writable, `meta.device.system.engine.version` | Engine version. |
| `meta_device_system_os_name` | `varchar2` | itgen_crp_meta_device_system_os_name | [ ] | filters on the platform, writable, `meta.device.system.os.name` | OS name. |
| `meta_device_system_os_version` | `varchar2` | itgen_crp_meta_device_system_os_version | [ ] | filters on the platform, writable, `meta.device.system.os.version` | OS version. |
| `meta_device_system_useragent` | `varchar2` | itgen_crp_meta_device_system_useragent | [ ] | filters on the platform, writable, `meta.device.system.useragent` | Visitor user agent. |
| `meta_device_timezone` | `int32` | itgen_crp_meta_device_timezone | [ ] | filters on the platform, writable, `meta.device.timezone` | Visitor device time zone offset in minutes relative to UTC, negated (-120 stands for UTC+02:00). |
| `meta_email` | `varchar2` | itgen_crp_meta_email | [ ] | filters on the platform, writable, `meta.email` | Visitor email. |
| `meta_ip` | `varchar2` | itgen_crp_meta_ip | [ ] | filters on the platform, writable, `meta.ip` | Visitor IP address. |
| `meta_nickname` | `varchar2` | itgen_crp_meta_nickname | [ ] | filters on the platform, writable, `meta.nickname` | Visitor nickname. |
| `meta_origin` | `varchar2` | itgen_crp_meta_origin | [ ] | filters on the platform, writable, `meta.origin` | Conversation origin; chat, email or a URN of the channel used. |
| `meta_phone` | `varchar2` | itgen_crp_meta_phone | [ ] | filters on the platform, writable, `meta.phone` | Visitor phone. |
| `meta_subject` | `varchar2` | itgen_crp_meta_subject | [ ] | filters on the platform, writable, `meta.subject` | Subject for conversation (if any). |
| `people_id` | `varchar2` | itgen_crp_people_id | [ ] | filters on the platform, writable | People identifier. |
| `preview_message_excerpt` | `varchar2` | itgen_crp_preview_message_excerpt | [ ] | filters on the platform, writable, `preview_message.excerpt` | Preview message excerpt. |
| `preview_message_fingerprint` | `int64` | itgen_crp_preview_message_fingerprint | [ ] | filters on the platform, writable, `preview_message.fingerprint` | Preview message fingerprint. |
| `preview_message_from` | `varchar2` | itgen_crp_preview_message_from | [ ] | filters on the platform, writable, `preview_message.from` | Preview message sender; one of user and operator. |
| `preview_message_type` | `varchar2` | itgen_crp_preview_message_type | [ ] | filters on the platform, writable, `preview_message.type` | Preview message type. |
| `session_id` | `varchar2` | itgen_crp_session_id | [x] | filters on the platform, writable | Session identifier. |
| `state` | `varchar2` | itgen_crp_state | [x] | filters on the platform, writable | Conversation state; one of pending, unresolved and resolved. |
| `status` | `int32` | itgen_crp_status | [x] | filters on the platform, writable | Conversation status (a numeric alias of the state; useful for sorting conversations). |
| `topic` | `varchar2` | itgen_crp_topic | [ ] | filters on the platform, writable | Topic for conversation (based on messages). |
| `unread_operator` | `int32` | itgen_crp_unread_operator | [x] | filters on the platform, writable, `unread.operator` | Unread messages counter for operator. |
| `unread_visitor` | `int32` | itgen_crp_unread_visitor | [x] | filters on the platform, writable, `unread.visitor` | Unread messages counter for visitor. |
| `updated_at` | `datetime` | itgen_crp_updated_at | [x] | filters on the platform, writable | Conversation update timestamp. |
| `waiting_since` | `datetime` | itgen_crp_waiting_since | [ ] | filters on the platform, writable | Conversation waiting since timestamp (if any). |
| `website_id` | `varchar2` | itgen_crp_website_id | [x] | filters on the platform, writable | Website identifier. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Crisp](/en/release-notes/drivers?driver=crisp)

