---
title: "TicketConversations (Freshdesk)"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/freshdesk/Freshdesk.Views.TicketConversations
original: https://documentation.invantive.eu/en/datamodels/freshdesk/Freshdesk.Views.TicketConversations
updated: 2026-06-04T07:55:59Z
license: https://documentation.invantive.eu/en/
---

# TicketConversations: Freshdesk

`read only`

- Catalog: `Freshdesk`
- Schema: `Views`

Can only retrieve data.

## Table Columns

The columns of the table `TicketConversations` 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 |
|---|---|---|:---:|---|---|
| `body` | `varchar2` | Body | [ ] |  | Content of the conversation in HTML. |
| `body_text` | `varchar2` | Body Text | [ ] |  | Content of the conversation in plain text. |
| `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` | `datetime` | itgen_freshdesk_last_edited_at | [ ] |  |  |
| `last_edited_at_user_id` | `int64` | itgen_freshdesk_last_edited_at_user_id | [ ] |  |  |
| `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. |



## Release Notes

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

- [Freshdesk](/en/release-notes/drivers?driver=freshdesk)

