# ConversationMessages: Crisp Conversation Messages - Catalog: `Crisp` - Schema: `Views` - Label: Conversation Messages This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `ConversationMessages` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `automated` | `char` | | ☐ | Whether the message is automated or not (ie. comes from a bot). | | `automated` | `char` | | ☐ | Whether the message is automated or not (ie. comes from a bot). | | `content_duration` | `int32` | | ☐ | Object duration in seconds (only set for the type audio). | | `content_duration` | `int32` | | ☐ | Object duration in seconds (only set for the type audio). | | `content_explain` | `varchar2` | | ☐ | Object explanatory text (only set for the type field). | | `content_explain` | `varchar2` | | ☐ | Object explanatory text (only set for the type field). | | `content_id` | `varchar2` | | ☐ | Object identifier (only set for the types picker and field). | | `content_id` | `varchar2` | | ☐ | Object identifier (only set for the types picker and field). | | `content_name` | `varchar2` | | ☐ | Object name (only set for the type file). | | `content_name` | `varchar2` | | ☐ | Object name (only set for the type file). | | `content_namespace` | `varchar2` | | ☐ | Event namespace (only set for the type event). | | `content_namespace` | `varchar2` | | ☐ | Event namespace (only set for the type event). | | `content_required` | `char` | | ☐ | Whether the message must be filled before continuing (only set for the types picker and field). | | `content_required` | `char` | | ☐ | Whether the message must be filled before continuing (only set for the types picker and field). | | `content_text` | `varchar2` | | ☐ | Object text (only set for the types picker, field, carousel and event). | | `content_text` | `varchar2` | | ☐ | Object text (only set for the types picker, field, carousel and event). | | `content_type` | `varchar2` | | ☐ | Object MIME type (only set for the types file, animation and audio). | | `content_type` | `varchar2` | | ☐ | Object MIME type (only set for the types file, animation and audio). | | `content_url` | `varchar2` | | ☐ | Object URL (only set for the types file, animation and audio). | | `content_url` | `varchar2` | | ☐ | Object URL (only set for the types file, animation and audio). | | `content_value` | `varchar2` | | ☐ | Object value (only set for the type field). | | `content_value` | `varchar2` | | ☐ | Object value (only set for the type field). | | `content` | `varchar2` | | ☐ | Message content; the text itself for the types text and note, otherwise the content object as JSON. | | `content` | `varchar2` | | ☐ | Message content; the text itself for the types text and note, otherwise the content object as JSON. | | `delivered` | `varchar2` | | ☐ | Channel in which the message has last been delivered (can be blank). | | `delivered` | `varchar2` | | ☐ | Channel in which the message has last been delivered (can be blank). | | `edited` | `char` | | ☐ | Whether the message was edited after being sent or not. | | `edited` | `char` | | ☐ | Whether the message was edited after being sent or not. | | `fingerprint` | `int64` | | ☑ | Unique message fingerprint. | | `fingerprint` | `int64` | | ☑ | Unique message fingerprint. | | `from` | `varchar2` | | ☑ | Message sender; one of user and operator. | | `from` | `varchar2` | | ☑ | Message sender; one of user and operator. | | `origin` | `varchar2` | | ☐ | Message origin; chat, email or a URN of the channel used. | | `origin` | `varchar2` | | ☐ | Message origin; chat, email or a URN of the channel used. | | `original_id` | `varchar2` | | ☐ | Identifier of the original message as held by the channel it arrived on (if any). | | `original_id` | `varchar2` | | ☐ | Identifier of the original message as held by the channel it arrived on (if any). | | `properties` | `varchar2` | | ☐ | Arbitrary properties set on the message as JSON (if any). | | `properties` | `varchar2` | | ☐ | Arbitrary properties set on the message as JSON (if any). | | `read` | `varchar2` | | ☐ | Channel in which the message has been read (can be blank). | | `read` | `varchar2` | | ☐ | Channel in which the message has been read (can be blank). | | `session_id` | `varchar2` | | ☑ | Session identifier. | | `session_id` | `varchar2` | | ☑ | Session identifier. | | `stamped` | `char` | | ☐ | Whether the message was fully processed in the internal Crisp pipeline. | | `stamped` | `char` | | ☐ | Whether the message was fully processed in the internal Crisp pipeline. | | `timestamp` | `datetime` | | ☑ | Timestamp at which the message was sent. | | `timestamp` | `datetime` | | ☑ | Timestamp at which the message was sent. | | `translated` | `char` | | ☐ | Whether the message was automatically translated or not. | | `translated` | `char` | | ☐ | Whether the message was automatically translated or not. | | `type` | `varchar2` | | ☑ | Message type; one of text, note, file, animation, audio, picker, field, carousel and event. | | `type` | `varchar2` | | ☑ | Message type; one of text, note, file, animation, audio, picker, field, carousel and event. | | `user_avatar` | `varchar2` | | ☐ | Sending user avatar. | | `user_avatar` | `varchar2` | | ☐ | Sending user avatar. | | `user_nickname` | `varchar2` | | ☐ | Sending user nickname. | | `user_nickname` | `varchar2` | | ☐ | Sending user nickname. | | `user_type` | `varchar2` | | ☐ | Sending user type; one of website and participant. | | `user_type` | `varchar2` | | ☐ | Sending user type; one of website and participant. | | `user_user_id` | `varchar2` | | ☐ | Sending user identifier; an operator user identifier or a session identifier. | | `user_user_id` | `varchar2` | | ☐ | Sending user identifier; an operator user identifier or a session identifier. | | `website_id` | `varchar2` | | ☑ | Website identifier. | | `website_id` | `varchar2` | | ☑ | Website identifier. |# ConversationMessages: Crisp Conversation Messages - Catalog: `Crisp` - Schema: `Views` - Label: Conversation Messages This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `ConversationMessages` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `automated` | `char` | | ☐ | Whether the message is automated or not (ie. comes from a bot). | | `automated` | `char` | | ☐ | Whether the message is automated or not (ie. comes from a bot). | | `content_duration` | `int32` | | ☐ | Object duration in seconds (only set for the type audio). | | `content_duration` | `int32` | | ☐ | Object duration in seconds (only set for the type audio). | | `content_explain` | `varchar2` | | ☐ | Object explanatory text (only set for the type field). | | `content_explain` | `varchar2` | | ☐ | Object explanatory text (only set for the type field). | | `content_id` | `varchar2` | | ☐ | Object identifier (only set for the types picker and field). | | `content_id` | `varchar2` | | ☐ | Object identifier (only set for the types picker and field). | | `content_name` | `varchar2` | | ☐ | Object name (only set for the type file). | | `content_name` | `varchar2` | | ☐ | Object name (only set for the type file). | | `content_namespace` | `varchar2` | | ☐ | Event namespace (only set for the type event). | | `content_namespace` | `varchar2` | | ☐ | Event namespace (only set for the type event). | | `content_required` | `char` | | ☐ | Whether the message must be filled before continuing (only set for the types picker and field). | | `content_required` | `char` | | ☐ | Whether the message must be filled before continuing (only set for the types picker and field). | | `content_text` | `varchar2` | | ☐ | Object text (only set for the types picker, field, carousel and event). | | `content_text` | `varchar2` | | ☐ | Object text (only set for the types picker, field, carousel and event). | | `content_type` | `varchar2` | | ☐ | Object MIME type (only set for the types file, animation and audio). | | `content_type` | `varchar2` | | ☐ | Object MIME type (only set for the types file, animation and audio). | | `content_url` | `varchar2` | | ☐ | Object URL (only set for the types file, animation and audio). | | `content_url` | `varchar2` | | ☐ | Object URL (only set for the types file, animation and audio). | | `content_value` | `varchar2` | | ☐ | Object value (only set for the type field). | | `content_value` | `varchar2` | | ☐ | Object value (only set for the type field). | | `content` | `varchar2` | | ☐ | Message content; the text itself for the types text and note, otherwise the content object as JSON. | | `content` | `varchar2` | | ☐ | Message content; the text itself for the types text and note, otherwise the content object as JSON. | | `delivered` | `varchar2` | | ☐ | Channel in which the message has last been delivered (can be blank). | | `delivered` | `varchar2` | | ☐ | Channel in which the message has last been delivered (can be blank). | | `edited` | `char` | | ☐ | Whether the message was edited after being sent or not. | | `edited` | `char` | | ☐ | Whether the message was edited after being sent or not. | | `fingerprint` | `int64` | | ☑ | Unique message fingerprint. | | `fingerprint` | `int64` | | ☑ | Unique message fingerprint. | | `from` | `varchar2` | | ☑ | Message sender; one of user and operator. | | `from` | `varchar2` | | ☑ | Message sender; one of user and operator. | | `origin` | `varchar2` | | ☐ | Message origin; chat, email or a URN of the channel used. | | `origin` | `varchar2` | | ☐ | Message origin; chat, email or a URN of the channel used. | | `original_id` | `varchar2` | | ☐ | Identifier of the original message as held by the channel it arrived on (if any). | | `original_id` | `varchar2` | | ☐ | Identifier of the original message as held by the channel it arrived on (if any). | | `properties` | `varchar2` | | ☐ | Arbitrary properties set on the message as JSON (if any). | | `properties` | `varchar2` | | ☐ | Arbitrary properties set on the message as JSON (if any). | | `read` | `varchar2` | | ☐ | Channel in which the message has been read (can be blank). | | `read` | `varchar2` | | ☐ | Channel in which the message has been read (can be blank). | | `session_id` | `varchar2` | | ☑ | Session identifier. | | `session_id` | `varchar2` | | ☑ | Session identifier. | | `stamped` | `char` | | ☐ | Whether the message was fully processed in the internal Crisp pipeline. | | `stamped` | `char` | | ☐ | Whether the message was fully processed in the internal Crisp pipeline. | | `timestamp` | `datetime` | | ☑ | Timestamp at which the message was sent. | | `timestamp` | `datetime` | | ☑ | Timestamp at which the message was sent. | | `translated` | `char` | | ☐ | Whether the message was automatically translated or not. | | `translated` | `char` | | ☐ | Whether the message was automatically translated or not. | | `type` | `varchar2` | | ☑ | Message type; one of text, note, file, animation, audio, picker, field, carousel and event. | | `type` | `varchar2` | | ☑ | Message type; one of text, note, file, animation, audio, picker, field, carousel and event. | | `user_avatar` | `varchar2` | | ☐ | Sending user avatar. | | `user_avatar` | `varchar2` | | ☐ | Sending user avatar. | | `user_nickname` | `varchar2` | | ☐ | Sending user nickname. | | `user_nickname` | `varchar2` | | ☐ | Sending user nickname. | | `user_type` | `varchar2` | | ☐ | Sending user type; one of website and participant. | | `user_type` | `varchar2` | | ☐ | Sending user type; one of website and participant. | | `user_user_id` | `varchar2` | | ☐ | Sending user identifier; an operator user identifier or a session identifier. | | `user_user_id` | `varchar2` | | ☐ | Sending user identifier; an operator user identifier or a session identifier. | | `website_id` | `varchar2` | | ☑ | Website identifier. | | `website_id` | `varchar2` | | ☑ | Website identifier. |