invantive documentation
Forum di supporto InvantiveAccedi / Registrati

ConversationByWebsiteIdAndSessionId: Crisp Conversation Data

read only REST

  • Catalogo: Crisp
  • Schema: Crisp
  • Chiavi primarie: session_id
  • Label: Conversation Data

È possibile solo recuperare i dati.

One conversation of a website, retrieved by session identifier.

Codice sorgente dell'API

  • Punto finale: /website/{website_id}/conversation/{session_id}

Parametri

Name Tipo di dati Required Default Documentation
session_id varchar2 The conversation session identifier.
website_id varchar2 The website identifier.Defaults to the website ID of the connection when left out.

Colonne della tabella

Di seguito sono riportate le colonne della tabella ConversationByWebsiteIdAndSessionId. 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
active_last datetime itgen_crp_active_last filtri sulla piattaforma, modificabili, active.last Timestamp at which the user was last active.
active_now char itgen_crp_active_now filtri sulla piattaforma, modificabili, active.now Whether user is considered active right now or not.
assigned_user_id varchar2 itgen_crp_assigned_user_id filtri sulla piattaforma, modificabili, assigned.user_id Operator user identifier.
availability varchar2 itgen_crp_availability filters on the platform, writable Visitor availability; one of online and offline.
compose_operator_automated char itgen_crp_compose_operator_automated filtri sulla piattaforma, modificabili, compose.operator.automated Whether compose is automated or not (ie. comes from a bot).
compose_operator_excerpt varchar2 itgen_crp_compose_operator_excerpt filtri sulla piattaforma, modificabili, compose.operator.excerpt Message excerpt for compose state.
compose_operator_timestamp datetime itgen_crp_compose_operator_timestamp filtri sulla piattaforma, modificabili, compose.operator.timestamp Timestamp for compose state.
compose_operator_type varchar2 itgen_crp_compose_operator_type filtri sulla piattaforma, modificabili, compose.operator.type Compose state type; one of start and stop.
compose_operator_user_avatar varchar2 itgen_crp_compose_operator_user_avatar filtri sulla piattaforma, modificabili, compose.operator.user.avatar Compose user avatar.
compose_operator_user_nickname varchar2 itgen_crp_compose_operator_user_nickname filtri sulla piattaforma, modificabili, compose.operator.user.nickname Compose user nickname.
compose_operator_user_user_id varchar2 itgen_crp_compose_operator_user_user_id filtri sulla piattaforma, modificabili, compose.operator.user.user_id Compose user identifier.
compose_visitor_automated char itgen_crp_compose_visitor_automated filtri sulla piattaforma, modificabili, compose.visitor.automated Whether compose is automated or not (ie. comes from a bot).
compose_visitor_excerpt varchar2 itgen_crp_compose_visitor_excerpt filtri sulla piattaforma, modificabili, compose.visitor.excerpt Message excerpt for compose state.
compose_visitor_timestamp datetime itgen_crp_compose_visitor_timestamp filtri sulla piattaforma, modificabili, compose.visitor.timestamp Timestamp for compose state.
compose_visitor_type varchar2 itgen_crp_compose_visitor_type filtri sulla piattaforma, modificabili, compose.visitor.type Compose state type; one of start and stop.
created_at datetime itgen_crp_created_at 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 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 filtri sulla piattaforma, modificabili, meta.address Visitor address.
meta_avatar varchar2 itgen_crp_meta_avatar filtri sulla piattaforma, modificabili, meta.avatar Visitor avatar.
meta_connection_asn varchar2 itgen_crp_meta_connection_asn filtri sulla piattaforma, modificabili, meta.connection.asn Autonomous system number, derived by Crisp from the IP address.
meta_connection_isp varchar2 itgen_crp_meta_connection_isp filtri sulla piattaforma, modificabili, meta.connection.isp Name of the internet service provider, derived by Crisp from the IP address.
meta_data varchar2 itgen_crp_meta_data filtri sulla piattaforma, modificabili, meta.data Visitor data as JSON.
meta_device_geolocation_city varchar2 itgen_crp_meta_device_geolocation_city filtri sulla piattaforma, modificabili, meta.device.geolocation.city City name.
meta_device_geolocation_coordinates_latitude decimal itgen_crp_meta_device_geolocation_coordinates_latitude filtri sulla piattaforma, modificabili, meta.device.geolocation.coordinates.latitude Latitude coordinate.
meta_device_geolocation_coordinates_longitude decimal itgen_crp_meta_device_geolocation_coordinates_longitude filtri sulla piattaforma, modificabili, meta.device.geolocation.coordinates.longitude Longitude coordinate.
meta_device_geolocation_country varchar2 itgen_crp_meta_device_geolocation_country filtri sulla piattaforma, modificabili, meta.device.geolocation.country Country code.
meta_device_geolocation_region varchar2 itgen_crp_meta_device_geolocation_region filtri sulla piattaforma, modificabili, meta.device.geolocation.region Region code.
meta_device_system_browser_major varchar2 itgen_crp_meta_device_system_browser_major filtri sulla piattaforma, modificabili, 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 filtri sulla piattaforma, modificabili, meta.device.system.browser.name Browser name.
meta_device_system_browser_version varchar2 itgen_crp_meta_device_system_browser_version filtri sulla piattaforma, modificabili, meta.device.system.browser.version Browser version.
meta_device_system_engine_name varchar2 itgen_crp_meta_device_system_engine_name filtri sulla piattaforma, modificabili, meta.device.system.engine.name Engine name.
meta_device_system_engine_version varchar2 itgen_crp_meta_device_system_engine_version filtri sulla piattaforma, modificabili, meta.device.system.engine.version Engine version.
meta_device_system_os_name varchar2 itgen_crp_meta_device_system_os_name filtri sulla piattaforma, modificabili, meta.device.system.os.name OS name.
meta_device_system_os_version varchar2 itgen_crp_meta_device_system_os_version filtri sulla piattaforma, modificabili, meta.device.system.os.version OS version.
meta_device_system_useragent varchar2 itgen_crp_meta_device_system_useragent filtri sulla piattaforma, modificabili, meta.device.system.useragent Visitor user agent.
meta_device_timezone int32 itgen_crp_meta_device_timezone filtri sulla piattaforma, modificabili, 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 filtri sulla piattaforma, modificabili, meta.email Visitor email.
meta_ip varchar2 itgen_crp_meta_ip filtri sulla piattaforma, modificabili, meta.ip Visitor IP address.
meta_nickname varchar2 itgen_crp_meta_nickname filtri sulla piattaforma, modificabili, meta.nickname Visitor nickname.
meta_origin varchar2 itgen_crp_meta_origin filtri sulla piattaforma, modificabili, meta.origin Conversation origin; chat, email or a URN of the channel used.
meta_phone varchar2 itgen_crp_meta_phone filtri sulla piattaforma, modificabili, meta.phone Visitor phone.
meta_subject varchar2 itgen_crp_meta_subject filtri sulla piattaforma, modificabili, 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 filtri sulla piattaforma, modificabili, preview_message.excerpt Preview message excerpt.
preview_message_fingerprint int64 itgen_crp_preview_message_fingerprint filtri sulla piattaforma, modificabili, preview_message.fingerprint Preview message fingerprint.
preview_message_from varchar2 itgen_crp_preview_message_from filtri sulla piattaforma, modificabili, preview_message.from Preview message sender; one of user and operator.
preview_message_type varchar2 itgen_crp_preview_message_type filtri sulla piattaforma, modificabili, preview_message.type Preview message type.
session_id varchar2 itgen_crp_session_id filters on the platform, writable Session identifier.
state varchar2 itgen_crp_state filters on the platform, writable Conversation state; one of pending, unresolved and resolved.
status int32 itgen_crp_status 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 filtri sulla piattaforma, modificabili, unread.operator Unread messages counter for operator.
unread_visitor int32 itgen_crp_unread_visitor filtri sulla piattaforma, modificabili, unread.visitor Unread messages counter for visitor.
updated_at datetime itgen_crp_updated_at 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 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: