invantive documentation
Forum di supporto InvantiveAccedi / Registrati

recent_tickets: Freshdesk Tickets (Recent)

insert update delete REST

  • Catalogo: Freshdesk
  • Schema: Freshdesk
  • Chiavi primarie: id
  • Label: Tickets (Recent)

È possibile recuperare e modificare i dati utilizzando insert, update e delete.

Ticket creati negli ultimi 30 giorni.

Codice sorgente dell'API

  • Punto finale: /tickets?include=requester,stats,company

Colonne della tabella

Di seguito sono riportate le colonne della tabella recent_tickets. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
associated_tickets_count int64 Numero di biglietti associati
cf_reference_number decimal Numero di riferimento Custom field #10000152167 of type custom_number.
company_id int64 ID dell'azienda
company_name varchar2 Nome dell'impresa
created_at datetime Creato il 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 Descrizione (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 Scaduta entro 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 ID di configurazione e-mail ID of email config which is used for this ticket.
facebook_id varchar2 ID Facebook Facebook ID of the requester.A contact should exist with this facebook_id in Freshdesk.
fr_due_by datetime Da: Scadenza il Timestamp that denotes when the first response is due.
fr_escalated char Da "Escalated" Set to true if the ticket has been escalated as the result of first response time being breached.
group_id int64 ID del gruppo ID of Group to which the ticket is assigned.
id int64 ID Unique ID of the ticket.
internal_agent_id int64 ID agente interno
internal_group_id int64 ID interno del gruppo
is_escalated char È intensificato Set to true if an escalation was sent.
name varchar2 Name Name of the requester.
nr_due_by datetime Scadenza (NR)
nr_escalated char Escalato (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 ID del prodotto ID of the product to which the ticket is associated.
requester_email varchar2 Indirizzo e-mail del richiedente 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 ID richiedente User-id of the requester.For existing contacts, requester_id can be passed instead of email.
requester_mobile varchar2 Dispositivo mobile del richiedente
requester_name varchar2 Nome del richiedente 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 Numero di telefono del richiedente 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 ID Twitter del richiedente 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 ID del risponditore 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 L'agente statistico ha risposto alle
stats_closed_at datetime Statistiche chiuse alle
stats_first_responded_at datetime Statistiche relative ai primi soccorritori intervenuti presso
stats_pending_since datetime Statistiche in sospeso dal
stats_reopened_at datetime Statistisc ha riaperto alle
stats_requester_responded_at datetime Il richiedente dei dati statistici ha risposto alle ore
stats_resolved_at datetime Statistiche risolte alle
stats_status_updated_at datetime Stato delle statistiche aggiornato alle
status int16 Status Status of the ticket.
subject varchar2 Subject Ticket subject.
ticket_type varchar2 Tipo di biglietto Type property field as defined in ticket fields.
to_emails varchar2 Alle e-mail
twitter_id varchar2 ID Twitter 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 Aggiornato il Date/time at which the record was last updated.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: