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.
Riepilogo
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_ |
int64 |
Numero di biglietti associati | |||
cf_ |
decimal |
Numero di riferimento | Custom field #10000152167 of type custom_number. | ||
company_ |
int64 |
ID dell'azienda | |||
company_ |
varchar2 |
Nome dell'impresa | |||
created_ |
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_ |
varchar2 |
Descrizione (HTML) | HTML content of the ticket.Description and description_html should not be passed together. | ||
description_ |
varchar2 |
Description | Plain text content of the ticket. | ||
due_by |
datetime |
Scaduta entro | Ticket due-by time. | ||
email |
varchar2 |
Email address of the requester.If no contact exists with this email address in Freshdesk, it will be added as a new contact. | |||
email_ |
int64 |
ID di configurazione e-mail | ID of email config which is used for this ticket. | ||
facebook_ |
varchar2 |
ID Facebook | Facebook ID of the requester.A contact should exist with this facebook_id in Freshdesk. | ||
fr_ |
datetime |
Da: Scadenza il | Timestamp that denotes when the first response is due. | ||
fr_ |
char |
Da "Escalated" | Set to true if the ticket has been escalated as the result of first response time being breached. | ||
group_ |
int64 |
ID del gruppo | ID of Group to which the ticket is assigned. | ||
id |
int64 |
ID | Unique ID of the ticket. | ||
internal_ |
int64 |
ID agente interno | |||
internal_ |
int64 |
ID interno del gruppo | |||
is_ |
char |
È intensificato | Set to true if an escalation was sent. | ||
name |
varchar2 |
Name | Name of the requester. | ||
nr_ |
datetime |
Scadenza (NR) | |||
nr_ |
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_ |
int64 |
ID del prodotto | ID of the product to which the ticket is associated. | ||
requester_ |
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_ |
varchar2 |
ID richiedente | User-id of the requester.For existing contacts, requester_id can be passed instead of email. | ||
requester_ |
varchar2 |
Dispositivo mobile del richiedente | |||
requester_ |
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_ |
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_ |
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_ |
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_ |
datetime |
L'agente statistico ha risposto alle | |||
stats_ |
datetime |
Statistiche chiuse alle | |||
stats_ |
datetime |
Statistiche relative ai primi soccorritori intervenuti presso | |||
stats_ |
datetime |
Statistiche in sospeso dal | |||
stats_ |
datetime |
Statistisc ha riaperto alle | |||
stats_ |
datetime |
Il richiedente dei dati statistici ha risposto alle ore | |||
stats_ |
datetime |
Statistiche risolte alle | |||
stats_ |
datetime |
Stato delle statistiche aggiornato alle | |||
status |
int16 |
Status | Status of the ticket. | ||
subject |
varchar2 |
Subject | Ticket subject. | ||
ticket_ |
varchar2 |
Tipo di biglietto | Type property field as defined in ticket fields. | ||
to_ |
varchar2 |
Alle e-mail | |||
twitter_ |
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_ |
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: