---
title: "tickets (Freshdesk)"
description: "Tickets"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/freshdesk/Freshdesk.Freshdesk.tickets
original: https://documentation.invantive.eu/en/datamodels/freshdesk/Freshdesk.Freshdesk.tickets
updated: 2026-06-04T07:55:59Z
license: https://documentation.invantive.eu/en/
---

# tickets: Freshdesk Tickets

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

- Catalog: `Freshdesk`
- Schema: `Freshdesk`
- Primary Keys: `id`
- Label: Tickets

Can retrieve data and change data using `insert`, `update` and `delete`.

## Summary

Tickets.

## API Source

- Endpoint: `/tickets?include=stats`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `company_id` | `int64` | [ ] |  | Company ID of requester. |
| `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. |
| `updated_since` | `datetime` | [ ] | 01/01/1900 00:00:00 | Limit to tickets updated since. |

## Table Columns

The columns of the table `tickets` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `associated_tickets_count` | `int64` | Associated Tickets Count | [ ] |  |  |
| `cf_reference_number` | `decimal` | Reference Number | [ ] |  | Custom field #10000152167 of type custom_number. |
| `company_id` | `int64` | Company ID | [ ] |  |  |
| `created_at` | `datetime` | 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. |
| `description` | `varchar2` | Description | [ ] |  |  |
| `description_html` | `varchar2` | Description (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` | Due by | [ ] |  | 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` | Email Configuration 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` | From Due by | [ ] |  | Timestamp that denotes when the first response is due. |
| `fr_escalated` | `char` | From Escalated | [ ] |  | Set to true if the ticket has been escalated as the result of first response time being breached. |
| `group_id` | `int64` | Group ID | [ ] |  | ID of Group to which the ticket is assigned. |
| `id` | `int64` | ID | [x] |  | Unique ID of the ticket. |
| `internal_agent_id` | `int64` | Internal Agent ID | [ ] |  |  |
| `internal_group_id` | `int64` | Internal Group ID | [ ] |  |  |
| `is_escalated` | `char` | Is Escalated | [ ] |  | Set to true if an escalation was sent. |
| `name` | `varchar2` | Name | [ ] |  | Name of the requester. |
| `nr_due_by` | `datetime` | Due by (NR) | [ ] |  |  |
| `nr_escalated` | `char` | Escalated (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_id` | `varchar2` | Requester 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` | Statistics Agent Responded at | [ ] |  |  |
| `stats_closed_at` | `datetime` | Statistics Closed at | [ ] |  |  |
| `stats_first_responded_at` | `datetime` | Statistics First Responded at | [ ] |  |  |
| `stats_pending_since` | `datetime` | Statistics Pending since | [ ] |  |  |
| `stats_reopened_at` | `datetime` | Statistisc Reopened at | [ ] |  |  |
| `stats_requester_responded_at` | `datetime` | Statistics Requester Responded at | [ ] |  |  |
| `stats_resolved_at` | `datetime` | Statistics Resolved at | [ ] |  |  |
| `stats_status_updated_at` | `datetime` | Statistics Status Updated at | [ ] |  |  |
| `status` | `int16` | Status | [ ] |  | Status of the ticket. |
| `subject` | `varchar2` | Subject | [ ] |  | Ticket subject. |
| `ticket_type` | `varchar2` | Ticket Type | [ ] |  | Type property field as defined in ticket fields. |
| `to_emails` | `varchar2` | To Emails | [ ] |  |  |
| `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` | Updated at | [ ] |  | Date/time at which the record was last updated. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

