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

# recent_tickets: Freshdesk Tickets (Recent)

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

- Catalogus: `Freshdesk`
- Schema: `Freshdesk`
- Primaire sleutels: `id`
- Label: Tickets (Recent)

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

## Samenvatting

Tickets aangemaakt in de laatste 30 dagen.

## API-bron

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

## Tabelkolommen

De kolommen van de tabel `recent_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 |
|---|---|---|:---:|---|---|
| `associated_tickets_count` | `int64` | Aantal Gekoppelde Tickets | [ ] |  |  |
| `cf_reference_number` | `decimal` | Reference Number | [ ] |  | Custom field #10000152167 of type custom_number. |
| `company_id` | `int64` | Bedrijf ID | [ ] |  |  |
| `company_name` | `varchar2` | Naam bedrijf | [ ] |  |  |
| `created_at` | `datetime` | Aangemaakt op | [ ] |  | 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` | Omschrijving (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` | Vervalt op | [ ] |  | 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-mail Configuratie 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` | Van Vervallen door | [ ] |  | Timestamp that denotes when the first response is due. |
| `fr_escalated` | `char` | Van Geëscaleerd | [ ] |  | Set to true if the ticket has been escalated as the result of first response time being breached. |
| `group_id` | `int64` | Groeps-ID | [ ] |  | ID of Group to which the ticket is assigned. |
| `id` | `int64` | ID | [x] |  | Unique ID of the ticket. |
| `internal_agent_id` | `int64` | Interne Agent-ID | [ ] |  |  |
| `internal_group_id` | `int64` | Interne Groep-ID | [ ] |  |  |
| `is_escalated` | `char` | Is Geëscaleerd | [ ] |  | Set to true if an escalation was sent. |
| `name` | `varchar2` | Name | [ ] |  | Name of the requester. |
| `nr_due_by` | `datetime` | Vervalt op (NR) | [ ] |  |  |
| `nr_escalated` | `char` | Geëscaleerd (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` | Product-ID | [ ] |  | ID of the product to which the ticket is associated. |
| `requester_email` | `varchar2` | Aanvrager E-mail | [ ] |  | Email address of the requester.If no contact exists with this email address in Freshdesk, it will be added as a new contact. |
| `requester_id` | `varchar2` | Aanvrager ID | [ ] |  | User-id of the requester.For existing contacts, requester_id can be passed instead of email. |
| `requester_mobile` | `varchar2` | Verzoeker Mobielnummer | [ ] |  |  |
| `requester_name` | `varchar2` | Naam Aanvrager | [ ] |  | Name of the requester.If no contact exists with the above mentioned email address in Freshdesk, it will be added as a new contact with this name.Name of the existing contact won't be overwritten by this name. |
| `requester_phone` | `varchar2` | Aanvrager Telefoon | [ ] |  | Phone number of the requester.If no contact exists with this phone number in Freshdesk, it will be added as a new contact. name is a mandatory attribute if phone number is given. |
| `requester_twitter_id` | `varchar2` | Verzoek Twitter-ID | [ ] |  | Twitter id of the requester.If no contact exists with this twitter_id in Freshdesk, it will be added as a new contact. |
| `responder_id` | `int64` | Beantwoorder 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` | Statistieken Agent Reageerde op | [ ] |  |  |
| `stats_closed_at` | `datetime` | Statistieken Gesloten op | [ ] |  |  |
| `stats_first_responded_at` | `datetime` | Statistieken Eerste Reactie op | [ ] |  |  |
| `stats_pending_since` | `datetime` | Statistieken in Behandeling sinds | [ ] |  |  |
| `stats_reopened_at` | `datetime` | Statistieken Heropend op | [ ] |  |  |
| `stats_requester_responded_at` | `datetime` | Statistieken Verzoeker Antwoordde op | [ ] |  |  |
| `stats_resolved_at` | `datetime` | Statistieken Opgelost op | [ ] |  |  |
| `stats_status_updated_at` | `datetime` | Statistieken Status Bijgewerkt op | [ ] |  |  |
| `status` | `int16` | Status | [ ] |  | Status of the ticket. |
| `subject` | `varchar2` | Subject | [ ] |  | Ticket subject. |
| `ticket_type` | `varchar2` | Ticketsoort | [ ] |  | Type property field as defined in ticket fields. |
| `to_emails` | `varchar2` | Naar 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` | Bijgewerkt op | [ ] |  | Date/time at which the record was last updated. |


## Release Notes

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

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