---
title: "tickets_incremental (Freshdesk)"
description: "Tickets (Incremental)"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/freshdesk/Freshdesk.Freshdesk.tickets_incremental
original: https://documentation.invantive.eu/en/datamodels/freshdesk/Freshdesk.Freshdesk.tickets_incremental
updated: 2026-11-18T00:29:46Z
license: https://documentation.invantive.eu/fr/
---

# tickets_incremental: Freshdesk Tickets (Incremental)

`insert` `update` `delete`

- Catalogue : `Freshdesk`
- Schéma : `Freshdesk`
- Clés primaires : `id`
- Label: Tickets (Incremental)

Permet de récupérer et de modifier des données à l'aide de `insert`, `update` et `delete`.

## Résumé

Tickets.

## Colonnes de table

Les colonnes de la table `tickets_incremental` 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 |
|---|---|---|:---:|---|---|
| `associated_tickets_count` | `int64` | Nombre de billets associés | [ ] |  |  |
| `cf_reference_number` | `decimal` | Numéro de Référence | [ ] |  | Custom field #10000152167 of type custom_number. |
| `company_id` | `int64` | ID de l'entreprise | [ ] |  |  |
| `created_at` | `datetime` | Créé le | [ ] |  | Date/time at which the record was created. |
| `deleted` | `char` | Deleted | [ ] |  | Set as true if the ticket is deleted/trashed.Deleted tickets will not be considered in any views except 'deleted' filter. |
| `description` | `varchar2` | Description | [ ] |  |  |
| `description_html` | `varchar2` | Description (HTML) | [ ] |  | HTML content of the ticket.Description and description_html should not be passed together. |
| `description_text` | `varchar2` | Description | [ ] |  | Plain text content of the ticket. |
| `due_by` | `datetime` | Due par | [ ] |  | Ticket due-by time. |
| `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. |
| `email_config_id` | `int64` | ID de configuration d'e-mail | [ ] |  | ID of email config which is used for this ticket. |
| `facebook_id` | `varchar2` | Identifiant Facebook | [ ] |  | Facebook ID of the requester.A contact should exist with this facebook_id in Freshdesk. |
| `fr_due_by` | `datetime` | De dû par | [ ] |  | Timestamp that denotes when the first response is due. |
| `fr_escalated` | `char` | À partir de Escalated | [ ] |  | Set to true if the ticket has been escalated as the result of first response time being breached. |
| `group_id` | `int64` | ID de groupe | [ ] |  | ID of Group to which the ticket is assigned. |
| `id` | `int64` | ID | [x] |  | Unique ID of the ticket. |
| `internal_agent_id` | `int64` | Identifiant interne de l'agent | [ ] |  |  |
| `internal_group_id` | `int64` | Identifiant interne du groupe | [ ] |  |  |
| `is_escalated` | `char` | Est escaladé | [ ] |  | Set to true if an escalation was sent. |
| `name` | `varchar2` | Name | [ ] |  | Name of the requester. |
| `nr_due_by` | `datetime` | Date limite : (NR) | [ ] |  |  |
| `nr_escalated` | `char` | Transmis à un niveau supérieur (NR) | [ ] |  |  |
| `phone` | `varchar2` | Phone | [ ] |  | Phone number of the requester.If no contact exists with this phone number in Freshdesk, it will be added as a new contact.If the phone number is set and the email address is not, then the name attribute is mandatory. |
| `priority` | `int16` | Priority | [ ] |  | Priority of the ticket. |
| `product_id` | `int64` | Produit ID | [ ] |  | ID of the product to which the ticket is associated. |
| `requester_id` | `varchar2` | ID du demandeur | [ ] |  | User-id of the requester.For existing contacts, requester_id can be passed instead of email. |
| `responder_id` | `int64` | Identifiant du répondeur | [ ] |  | ID of the agent to whom the ticket is assigned. |
| `source` | `int16` | Source | [ ] |  | The channel through which the ticket was created. |
| `spam` | `char` | Spam | [ ] |  | Set as true if the ticket is marked as spam. |
| `stats_agent_responded_at` | `datetime` | L'agent chargé des statistiques a répondu à | [ ] |  |  |
| `stats_closed_at` | `datetime` | Statistiques clôturées à | [ ] |  |  |
| `stats_first_responded_at` | `datetime` | Statistiques relatives aux premiers intervenants à | [ ] |  |  |
| `stats_pending_since` | `datetime` | Statistiques en attente depuis | [ ] |  |  |
| `stats_reopened_at` | `datetime` | Statistisc a rouvert ses portes à | [ ] |  |  |
| `stats_requester_responded_at` | `datetime` | Le demandeur de statistiques a répondu à | [ ] |  |  |
| `stats_resolved_at` | `datetime` | Statistiques établies à | [ ] |  |  |
| `stats_status_updated_at` | `datetime` | État des statistiques - Mise à jour le | [ ] |  |  |
| `status` | `int16` | Status | [ ] |  | Status of the ticket. |
| `subject` | `varchar2` | Subject | [ ] |  | Ticket subject. |
| `ticket_type` | `varchar2` | Type de billet | [ ] |  | Type property field as defined in ticket fields. |
| `to_emails` | `varchar2` | Aux e-mails | [ ] |  |  |
| `twitter_id` | `varchar2` | Identifiant Twitter | [ ] |  | Twitter handle of the requester.If no contact exists with this handle in Freshdesk, it will be added as a new contact. |
| `type` | `varchar2` | Type | [ ] |  | Helps categorize the ticket according to the different kinds of issues your support team deals with. |
| `updated_at` | `datetime` | Mise à jour à | [ ] |  | Date/time at which the record was last updated. |


## 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)
