---
title: "ConversationMessages (Crisp)"
description: "Conversation Messages"
language: it
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/datamodels/crisp/Crisp.Views.ConversationMessages
original: https://documentation.invantive.eu/en/datamodels/crisp/Crisp.Views.ConversationMessages
updated: 2026-11-16T20:43:41Z
license: https://documentation.invantive.eu/it/
---

# ConversationMessages: Crisp Conversation Messages

`read only`

- Catalogo: `Crisp`
- Schema: `Views`
- Label: Conversation Messages

È possibile solo recuperare i dati.

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `ConversationMessages`. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `automated` | `char` | itgen_crp_automated | [ ] | filters on the platform, writable | Whether the message is automated or not (ie. comes from a bot). |
| `content` | `varchar2` | itgen_crp_content | [ ] | filters on the platform, writable | Message content; the text itself for the types text and note, otherwise the content object as JSON. |
| `content_duration` | `int32` | itgen_crp_content_duration | [ ] | filters on the platform, writable | Object duration in seconds (only set for the type audio). |
| `content_explain` | `varchar2` | itgen_crp_content_explain | [ ] | filters on the platform, writable | Object explanatory text (only set for the type field). |
| `content_id` | `varchar2` | itgen_crp_content_id | [ ] | filters on the platform, writable | Object identifier (only set for the types picker and field). |
| `content_name` | `varchar2` | itgen_crp_content_name | [ ] | filters on the platform, writable | Object name (only set for the type file). |
| `content_namespace` | `varchar2` | itgen_crp_content_namespace | [ ] | filters on the platform, writable | Event namespace (only set for the type event). |
| `content_required` | `char` | itgen_crp_content_required | [ ] | filters on the platform, writable | Whether the message must be filled before continuing (only set for the types picker and field). |
| `content_text` | `varchar2` | itgen_crp_content_text | [ ] | filters on the platform, writable | Object text (only set for the types picker, field, carousel and event). |
| `content_type` | `varchar2` | itgen_crp_content_type | [ ] | filters on the platform, writable | Object MIME type (only set for the types file, animation and audio). |
| `content_url` | `varchar2` | itgen_crp_content_url | [ ] | filters on the platform, writable | Object URL (only set for the types file, animation and audio). |
| `content_value` | `varchar2` | itgen_crp_content_value | [ ] | filters on the platform, writable | Object value (only set for the type field). |
| `conversation_active_last` | `datetime` | itgen_crp_active_last | [ ] | filters on the platform, writable, `conversation_active_last` | Timestamp at which the user was last active. |
| `conversation_created_at` | `datetime` | itgen_crp_created_at | [x] | filters on the platform, writable, `conversation_created_at` | Conversation creation timestamp. |
| `conversation_topic` | `varchar2` | itgen_crp_topic | [ ] | filters on the platform, writable, `conversation_topic` | Topic for conversation (based on messages). |
| `conversation_updated_at` | `datetime` | itgen_crp_updated_at | [x] | filters on the platform, writable, `conversation_updated_at` | Conversation update timestamp. |
| `conversation_waiting_since` | `datetime` | itgen_crp_waiting_since | [ ] | filters on the platform, writable, `conversation_waiting_since` | Conversation waiting since timestamp (if any). |
| `delivered` | `varchar2` | itgen_crp_delivered | [ ] | filters on the platform, writable | Channel in which the message has last been delivered (can be blank). |
| `edited` | `char` | itgen_crp_edited | [ ] | filters on the platform, writable | Whether the message was edited after being sent or not. |
| `fingerprint` | `int64` | itgen_crp_fingerprint | [x] | filters on the platform, writable | Unique message fingerprint. |
| `from` | `varchar2` | itgen_crp_from | [x] | filters on the platform, writable | Message sender; one of user and operator. |
| `origin` | `varchar2` | itgen_crp_origin | [ ] | filters on the platform, writable | Message origin; chat, email or a URN of the channel used. |
| `original_id` | `varchar2` | itgen_crp_original_id | [ ] | filters on the platform, writable | Identifier of the original message as held by the channel it arrived on (if any). |
| `properties` | `varchar2` | itgen_crp_properties | [ ] | filters on the platform, writable | Arbitrary properties set on the message as JSON (if any). |
| `read` | `varchar2` | itgen_crp_read | [ ] | filters on the platform, writable | Channel in which the message has been read (can be blank). |
| `session_id` | `varchar2` | itgen_crp_session_id | [x] | filters on the platform, writable | Session identifier. |
| `stamped` | `char` | itgen_crp_stamped | [ ] | filters on the platform, writable | Whether the message was fully processed in the internal Crisp pipeline. |
| `timestamp` | `datetime` | itgen_crp_timestamp | [x] | filters on the platform, writable | Timestamp at which the message was sent. |
| `translated` | `char` | itgen_crp_translated | [ ] | filters on the platform, writable | Whether the message was automatically translated or not. |
| `type` | `varchar2` | itgen_crp_type | [x] | filters on the platform, writable | Message type; one of text, note, file, animation, audio, picker, field, carousel and event. |
| `user_avatar` | `varchar2` | itgen_crp_user_avatar | [ ] | filters on the platform, writable | Sending user avatar. |
| `user_nickname` | `varchar2` | itgen_crp_user_nickname | [ ] | filters on the platform, writable | Sending user nickname. |
| `user_type` | `varchar2` | itgen_crp_user_type | [ ] | filters on the platform, writable | Sending user type; one of website and participant. |
| `user_user_id` | `varchar2` | itgen_crp_user_user_id | [ ] | filters on the platform, writable | Sending user identifier; an operator user identifier or a session identifier. |
| `website_id` | `varchar2` | itgen_crp_website_id | [x] | filters on the platform, writable | Website identifier. |


## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

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