---
title: "tickets_incremental (Freshdesk)"
description: "Tickets (Incremental)"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/freshdesk/Freshdesk.Freshdesk.tickets_incremental
original: https://documentation.invantive.eu/en/datamodels/freshdesk/Freshdesk.Freshdesk.tickets_incremental
updated: 2026-11-16T21:06:30Z
license: https://documentation.invantive.eu/de/
---

# tickets_incremental: Freshdesk Tickets (Incremental)

`insert` `update` `delete`

- Katalog: `Freshdesk`
- Schema: `Freshdesk`
- Primärschlüssel: `id`
- Label: Tickets (Incremental)

Mit `insert`, `update` und `delete` können Daten abgerufen und geändert werden.

## Zusammenfassung

Tickets.

## Tabellenspalten

Die Spalten der Tabelle `tickets_incremental` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `associated_tickets_count` | `int64` | Anzahl der zugehörigen Tickets | [ ] |  |  |
| `cf_reference_number` | `decimal` | Referenznummer | [ ] |  | Custom field #10000152167 of type custom_number. |
| `company_id` | `int64` | Firmen ID | [ ] |  |  |
| `created_at` | `datetime` | Erstellt bei | [ ] |  | 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` | Beschreibung (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` | Fällig am | [ ] |  | 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` | E-Mailkonfigurations-ID | [ ] |  | ID of email config which is used for this ticket. |
| `facebook_id` | `varchar2` | Facebook ID | [ ] |  | Facebook ID of the requester.A contact should exist with this facebook_id in Freshdesk. |
| `fr_due_by` | `datetime` | Von Fällig bis | [ ] |  | Timestamp that denotes when the first response is due. |
| `fr_escalated` | `char` | Von Eskaliert | [ ] |  | Set to true if the ticket has been escalated as the result of first response time being breached. |
| `group_id` | `int64` | Gruppen-ID | [ ] |  | ID of Group to which the ticket is assigned. |
| `id` | `int64` | ID | [x] |  | Unique ID of the ticket. |
| `internal_agent_id` | `int64` | Interne Agenten-ID | [ ] |  |  |
| `internal_group_id` | `int64` | Interne Gruppen-ID | [ ] |  |  |
| `is_escalated` | `char` | Ist eskaliert | [ ] |  | Set to true if an escalation was sent. |
| `name` | `varchar2` | Name | [ ] |  | Name of the requester. |
| `nr_due_by` | `datetime` | Fällig am (NR) | [ ] |  |  |
| `nr_escalated` | `char` | Eskaliert (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` | Produkt ID | [ ] |  | ID of the product to which the ticket is associated. |
| `requester_id` | `varchar2` | Anforderer ID | [ ] |  | User-id of the requester.For existing contacts, requester_id can be passed instead of email. |
| `responder_id` | `int64` | Responder ID | [ ] |  | 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` | Statistik: Der Mitarbeiter hat geantwortet am | [ ] |  |  |
| `stats_closed_at` | `datetime` | Statistik geschlossen um | [ ] |  |  |
| `stats_first_responded_at` | `datetime` | Statistiken: Erste Reaktion bei | [ ] |  |  |
| `stats_pending_since` | `datetime` | Statistiken ausstehend seit | [ ] |  |  |
| `stats_reopened_at` | `datetime` | Statistisc wiedereröffnet am | [ ] |  |  |
| `stats_requester_responded_at` | `datetime` | Der Anfragende hat am | [ ] |  |  |
| `stats_resolved_at` | `datetime` | Statistiken, die unter folgender Adresse abgerufen wurden: | [ ] |  |  |
| `stats_status_updated_at` | `datetime` | Statistikstatus, aktualisiert am | [ ] |  |  |
| `status` | `int16` | Status | [ ] |  | Status of the ticket. |
| `subject` | `varchar2` | Subject | [ ] |  | Ticket subject. |
| `ticket_type` | `varchar2` | Typ der Anfrage | [ ] |  | Type property field as defined in ticket fields. |
| `to_emails` | `varchar2` | An E-Mails | [ ] |  |  |
| `twitter_id` | `varchar2` | Twitter ID | [ ] |  | 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` | Aktualisiert am | [ ] |  | Date/time at which the record was last updated. |


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

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