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

# search_tickets: Freshdesk Search Tickets

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

- Katalog: `Freshdesk`
- Schema: `Freshdesk`
- Primärschlüssel: `id`
- Label: Search Tickets

Mit `insert`, `update` und `delete` können Daten abgerufen und geändert werden.

## Zusammenfassung

Search for tickets using a query.

## API-Quelle

- Endpunkt: `/search/tickets`

## Parameter

| Name | Datentyp | Required | Default | Documentation |
|---|---|:---:|---|---|
| `query` | `varchar2` | [x] |  | Custom query matching Freshdesk specifications, such as '(priority:3 OR priority:2) AND created_at:>'2022-01-01''.The following fields can be used in the query: agent_id, group_id, priority, status, tag, type, due_by, fr_due_by, created_at and updated_at. |

## Tabellenspalten

Die Spalten der Tabelle `search_tickets` 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 |
|---|---|---|:---:|---|---|
| `associated_tickets_count` | `int64` | Anzahl der zugehörigen Tickets | [ ] |  |  |
| `cf_reference_number` | `decimal` | Referenznummer | [ ] |  | Custom field #10000152167 of type custom_number. |
| `company_id` | `int64` | Firmen ID | [ ] |  |  |
| `created_at` | `datetime` | Erstellt bei | [ ] |  | 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` | Beschreibung (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` | Fällig am | [ ] |  | 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-Mailkonfigurations-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` | Von Fällig bis | [ ] |  | Timestamp that denotes when the first response is due. |
| `fr_escalated` | `char` | Von Eskaliert | [ ] |  | Set to true if the ticket has been escalated as the result of first response time being breached. |
| `group_id` | `int64` | Gruppen-ID | [ ] |  | ID of Group to which the ticket is assigned. |
| `id` | `int64` | ID | [x] |  | Unique ID of the ticket. |
| `internal_agent_id` | `int64` | Interne Agenten-ID | [ ] |  |  |
| `internal_group_id` | `int64` | Interne Gruppen-ID | [ ] |  |  |
| `is_escalated` | `char` | Ist eskaliert | [ ] |  | Set to true if an escalation was sent. |
| `name` | `varchar2` | Name | [ ] |  | Name of the requester. |
| `nr_due_by` | `datetime` | Fällig am (NR) | [ ] |  |  |
| `nr_escalated` | `char` | Eskaliert (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` | Produkt ID | [ ] |  | ID of the product to which the ticket is associated. |
| `requester_id` | `varchar2` | Anforderer 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. |
| `status` | `int16` | Status | [ ] |  | Status of the ticket. |
| `subject` | `varchar2` | Subject | [ ] |  | Ticket subject. |
| `ticket_type` | `varchar2` | Typ der Anfrage | [ ] |  | Type property field as defined in ticket fields. |
| `to_emails` | `varchar2` | An 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` | Aktualisiert am | [ ] |  | Date/time at which the record was last updated. |


## Anmerkungen zu dieser Version

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

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