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

# RecentTickets: Freshservice Tickets (Recent)

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

- Catálogo: `Freshservice`
- Esquema: `Freshservice`
- Llaves Primarias: `id`
- Label: Tickets (Recent)

Permite recuperar y modificar datos utilizando `insert`, `update` y `delete`.

## Resumen

Boletos creados en los últimos 30 días.

## Fuente de la API

- Punto final: `/tickets?include=requester,stats`

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `RecentTickets`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | 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 | [ ] |  |  |


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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