---
title: "TicketsIncremental (Freshservice)"
description: "Tickets (Incremental)"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/freshservice/Freshservice.Freshservice.TicketsIncremental
original: https://documentation.invantive.eu/en/datamodels/freshservice/Freshservice.Freshservice.TicketsIncremental
updated: 2026-11-16T21:07:13Z
license: https://documentation.invantive.eu/de/
---

# TicketsIncremental: Freshservice Tickets (Incremental)

`insert` `update` `delete`

- Katalog: `Freshservice`
- Schema: `Freshservice`
- 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 `TicketsIncremental` 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 |
|---|---|---|:---:|---|---|
| `business_impact` | `varchar2` | Business impact | [ ] |  | Custom field #50000103641 of type custom_paragraph. |
| `call_code` | `varchar2` | Call_code | [ ] |  | Custom field #50000011369 of type custom_text. |
| `categorie_aariverside` | `varchar2` | Categorie AaRiverside | [ ] |  | Custom field #50000097751 of type nested_field. |
| `categorie_facilitair` | `varchar2` | Categorie Facilitair | [ ] |  | Custom field #50000010875 of type nested_field. |
| `categorie_flex` | `varchar2` | Categorie Flex | [ ] |  | Custom field #50000010876 of type nested_field. |
| `categorie_nocore_intern` | `varchar2` | Categorie Nocore intern | [ ] |  | Custom field #50000099436 of type custom_dropdown. |
| `category` | `varchar2` | Category | [ ] |  |  |
| `created_at` | `datetime` | itgen_freshservice_created_at | [ ] |  | 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. |
| `department_id` | `int64` | itgen_freshservice_department_id | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `description_text` | `varchar2` | itgen_freshservice_description_text | [ ] |  | Plain text content of the ticket. |
| `due_by` | `datetime` | itgen_freshservice_due_by | [ ] |  | Ticket due-by time. |
| `email_config_id` | `int64` | itgen_freshservice_email_config_id | [ ] |  | ID of email config which is used for this ticket. |
| `fr_due_by` | `datetime` | itgen_freshservice_fr_due_by | [ ] |  | Timestamp that denotes when the first response is due. |
| `fr_escalated` | `char` | itgen_freshservice_fr_escalated | [ ] |  | Set to true if the ticket has been escalated as the result of first response time being breached. |
| `group_id` | `int64` | itgen_freshservice_group_id | [ ] |  | ID of Group to which the ticket is assigned. |
| `id` | `int64` | ID | [x] |  | Unique ID of the ticket. |
| `impacted_locations` | `varchar2` | Impacted locations | [ ] |  | Custom field #50000103642 of type custom_text. |
| `incident_alleen_zichtbaar_voor_mij_niet_voor_andere_collegas` | `char` | Incident alleen zichtbaar voor mij, niet voor andere collega's | [ ] |  | Custom field #50000009057 of type custom_checkbox. |
| `incorrect_ingeladen` | `varchar2` | Incorrect ingeladen | [ ] |  | Custom field #50000011765 of type custom_dropdown. |
| `is_escalated` | `char` | itgen_freshservice_is_escalated | [ ] |  | Set to true if an escalation was sent. |
| `item_category` | `varchar2` | itgen_freshservice_item_category | [ ] |  |  |
| `major_incident_type` | `varchar2` | Major incident type | [ ] |  | Custom field #50000103640 of type custom_dropdown. |
| `no_of_customers_impacted` | `varchar2` | No. of customers impacted | [ ] |  | Custom field #50000103643 of type custom_text. |
| `priority` | `int16` | Priority | [ ] |  | Priority of the ticket. |
| `requested_for_id` | `int64` | itgen_freshservice_requested_for_id | [ ] |  |  |
| `requester_id` | `varchar2` | itgen_freshservice_requester_id | [ ] |  | User-id of the requester.For existing contacts, requester_id can be passed instead of email. |
| `source` | `varchar2` | Source | [ ] |  |  |
| `spam` | `char` | Spam | [ ] |  | Set as true if the ticket is marked as spam. |
| `stats_agent_responded_at` | `datetime` | itgen_freshservice_stats_agent_responded_at | [ ] |  |  |
| `stats_assigned_at` | `datetime` | itgen_freshservice_stats_assigned_at | [ ] |  |  |
| `stats_closed_at` | `datetime` | itgen_freshservice_stats_closed_at | [ ] |  |  |
| `stats_first_assigned_at` | `datetime` | itgen_freshservice_stats_first_assigned_at | [ ] |  |  |
| `stats_first_resp_time_in_secs` | `int64` | itgen_freshservice_stats_first_resp_time_in_secs | [ ] |  |  |
| `stats_first_responded_at` | `datetime` | itgen_freshservice_stats_first_responded_at | [ ] |  |  |
| `stats_group_escalated` | `char` | itgen_freshservice_stats_group_escalated | [ ] |  |  |
| `stats_inbound_count` | `int64` | itgen_freshservice_stats_inbound_count | [ ] |  |  |
| `stats_opened_at` | `datetime` | itgen_freshservice_stats_opened_at | [ ] |  |  |
| `stats_outbound_count` | `int64` | itgen_freshservice_stats_outbound_count | [ ] |  |  |
| `stats_pending_since` | `datetime` | itgen_freshservice_stats_pending_since | [ ] |  |  |
| `stats_requester_responded_at` | `datetime` | itgen_freshservice_stats_requester_responded_at | [ ] |  |  |
| `stats_resolution_time_in_secs` | `int64` | itgen_freshservice_stats_resolution_time_in_secs | [ ] |  |  |
| `stats_resolved_at` | `datetime` | itgen_freshservice_stats_resolved_at | [ ] |  |  |
| `stats_status_updated_at` | `datetime` | itgen_freshservice_stats_status_updated_at | [ ] |  |  |
| `status` | `int16` | Status | [ ] |  | Status of the ticket. |
| `sub_category` | `varchar2` | itgen_freshservice_sub_category | [ ] |  |  |
| `subcategorie` | `varchar2` | Categorie AaRiverside | [ ] |  | Nested field #50000097751 level 2 on custom field 'categorie_aariverside'. |
| `subcategorie_facilitair` | `varchar2` | Categorie Facilitair | [ ] |  | Nested field #50000010875 level 2 on custom field 'categorie_facilitair'. |
| `subcategorie_flex` | `varchar2` | Categorie Flex | [ ] |  | Nested field #50000010876 level 2 on custom field 'categorie_flex'. |
| `subject` | `varchar2` | Subject | [ ] |  | Ticket subject. |
| `subsubcategorie` | `varchar2` | Categorie AaRiverside | [ ] |  | Nested field #50000097751 level 3 on custom field 'categorie_aariverside'. |
| `subsubcategorie_facilitair` | `varchar2` | Categorie Facilitair | [ ] |  | Nested field #50000010875 level 3 on custom field 'categorie_facilitair'. |
| `subsubcategorie_flex` | `varchar2` | Categorie Flex | [ ] |  | Nested field #50000010876 level 3 on custom field 'categorie_flex'. |
| `tasks_dependency_type` | `int16` | itgen_freshservice_tasks_dependency_type | [ ] |  |  |
| `type` | `varchar2` | Type | [ ] |  | Helps categorize the ticket according to the different kinds of issues your support team deals with. |
| `updated_at` | `datetime` | itgen_freshservice_updated_at | [ ] |  | Date/time at which the record was last updated. |
| `workspace_id` | `int64` | itgen_freshservice_workspace_id | [ ] |  |  |


## Anmerkungen zu dieser Version

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

- [Freshservice](/de/release-notes/drivers?driver=freshservice)
