# TicketConversations - Catalog: `Freshdesk` - Schema: `Views` This is a read-only view. The Freshdesk API may not support changing the data or the Invantive UniversalSQL driver for Freshdesk does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Freshdesk API. ## View Columns The columns of the view `TicketConversations` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `body_text` | `varchar2` | Body Text | ☐ | Content of the conversation in plain text. | | `body` | `varchar2` | Body | ☐ | Content of the conversation in HTML. | | `created_at` | `datetime` | Created at | ☐ | Date/time at which the record was created. | | `from_email` | `varchar2` | From Email Address | ☐ | | | `id` | `int64` | ID | ☐ | ID of the conversation. | | `incoming` | `char` | Incoming | ☐ | Whether a particular conversation should appear as being created from outside (i.e., not through web portal). | | `last_edited_at_user_id` | `int64` | | ☐ | | | `last_edited_at` | `datetime` | | ☐ | | | `private` | `char` | Private | ☐ | Whether the note is private. | | `source` | `int64` | Source | ☐ | Type of the conversation. See ConversationSources. | | `support_email` | `varchar2` | Support Email Address | ☐ | Email address from which the reply is sent. For notes, this value will be null. | | `ticket_email` | `varchar2` | Email | ☐ | Email address of the requester. If no contact exists with this email address in Freshdesk, it will be added as a new contact. | | `ticket_id` | `int64` | Ticket ID | ☐ | ID of the ticket to which this conversation is being added. | | `ticket_name` | `varchar2` | Name | ☐ | Name of the requester. | | `ticket_subject` | `varchar2` | Subject | ☐ | Ticket subject. | | `updated_at` | `datetime` | Updated at | ☐ | Date/time at which the record was last updated. | | `user_id` | `int64` | User ID | ☐ | ID of the agent/user who is adding the conversation. |