---
title: "TicketConversations (Freshdesk)"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/freshdesk/Freshdesk.Views.TicketConversations
original: https://documentation.invantive.eu/en/datamodels/freshdesk/Freshdesk.Views.TicketConversations
updated: 2026-11-16T21:06:36Z
license: https://documentation.invantive.eu/fr/
---

# TicketConversations: Freshdesk

`read only`

- Catalogue : `Freshdesk`
- Schéma : `Views`

Permet uniquement de récupérer des données.

## Colonnes de table

Les colonnes de la table `TicketConversations` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `body` | `varchar2` | Body | [ ] |  | Content of the conversation in HTML. |
| `body_text` | `varchar2` | Texte du corps | [ ] |  | Content of the conversation in plain text. |
| `created_at` | `datetime` | Créé le | [ ] |  | Date/time at which the record was created. |
| `from_email` | `varchar2` | Adresse e-mail de l'expéditeur | [ ] |  |  |
| `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.Voir ConversationSources. |
| `support_email` | `varchar2` | Adresse e-mail de l'assistance | [ ] |  | 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` | ID du Ticket | [ ] |  | 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` | Mise à jour à | [ ] |  | Date/time at which the record was last updated. |
| `user_id` | `int64` | ID utilisateur | [ ] |  | ID of the agent/user who is adding the conversation. |


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

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