invantive documentation
Invantive SupportforenAnmelden / Eintragen

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 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 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: