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

# Tickets: Freshservice Tickets

`insert` `update` `delete` `REST`

- Catalogus: `Freshservice`
- Schema: `Freshservice`
- Primaire sleutels: `id`
- Label: Tickets

Je kunt gegevens ophalen en wijzigen met `insert`, `update` en `delete`.

## Samenvatting

Tickets.

## API-bron

- Eindpunt: `/tickets?include=requester,stats`

## Parameters

| Name | Datatype | Required | Default | Documentation |
|---|---|:---:|---|---|
| `email` | `varchar2` | [ ] |  | Email address of requester. |
| `filter` | `varchar2` | [ ] |  | Pre-defined filter: 'new_and_my_open', 'watching', 'spam' and 'deleted'. |
| `requester_id` | `int64` | [ ] |  | ID of requester. |
| `type` | `varchar2` | [ ] |  | Type such as 'incident'. |
| `updated_since` | `datetime` | [ ] | 01/01/1900 00:00:00 | Limit to tickets updated since. |
| `workspace_id` | `int64` | [ ] |  | ID of workspace. |

## Tabelkolommen

De kolommen van de tabel `Tickets` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | 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_email` | `varchar2` | itgen_freshservice_requester_email | [ ] |  | Email address of the requester. |
| `requester_id` | `varchar2` | itgen_freshservice_requester_id | [ ] |  | User-id of the requester.For existing contacts, requester_id can be passed instead of email. |
| `requester_mobile` | `varchar2` | itgen_freshservice_requester_mobile | [ ] |  |  |
| `requester_name` | `varchar2` | itgen_freshservice_requester_name | [ ] |  | Name of the requester. |
| `requester_phone` | `varchar2` | itgen_freshservice_requester_phone | [ ] |  | Phone number of the requester. |
| `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 | [ ] |  |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

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