tickets: Freshdesk Tickets
insert update delete REST
- Catalogue :
Freshdesk - Schéma :
Freshdesk - Clés primaires :
id - Label: Tickets
Permet de récupérer et de modifier des données à l'aide de insert, update et delete.
Résumé
Tickets.
Source de l'API
- Point de terminaison :
/tickets?include=stats
Paramètres
| Name | Type de données | Required | Default | Documentation |
|---|---|---|---|---|
company_ |
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_ |
int64 |
ID of requester. | ||
updated_ |
datetime |
01/01/1900 00:00:00 | Limit to tickets updated since. |
Colonnes de table
Les colonnes de la table tickets sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
associated_ |
int64 |
Nombre de billets associés | |||
cf_ |
decimal |
Numéro de Référence | Custom field #10000152167 of type custom_number. | ||
company_ |
int64 |
ID de l'entreprise | |||
created_ |
datetime |
Créé le | 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 |
Description (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 |
Due par | 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 de configuration d'e-mail | ID of email config which is used for this ticket. | ||
facebook_ |
varchar2 |
Identifiant Facebook | Facebook ID of the requester.A contact should exist with this facebook_id in Freshdesk. | ||
fr_ |
datetime |
De dû par | Timestamp that denotes when the first response is due. | ||
fr_ |
char |
À partir de Escalated | Set to true if the ticket has been escalated as the result of first response time being breached. | ||
group_ |
int64 |
ID de groupe | ID of Group to which the ticket is assigned. | ||
id |
int64 |
ID | Unique ID of the ticket. | ||
internal_ |
int64 |
Identifiant interne de l'agent | |||
internal_ |
int64 |
Identifiant interne du groupe | |||
is_ |
char |
Est escaladé | Set to true if an escalation was sent. | ||
name |
varchar2 |
Name | Name of the requester. | ||
nr_ |
datetime |
Date limite : (NR) | |||
nr_ |
char |
Transmis à un niveau supérieur (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 |
Produit ID | ID of the product to which the ticket is associated. | ||
requester_ |
varchar2 |
ID du demandeur | User-id of the requester.For existing contacts, requester_id can be passed instead of email. | ||
responder_ |
int64 |
Identifiant du répondeur | 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'agent chargé des statistiques a répondu à | |||
stats_ |
datetime |
Statistiques clôturées à | |||
stats_ |
datetime |
Statistiques relatives aux premiers intervenants à | |||
stats_ |
datetime |
Statistiques en attente depuis | |||
stats_ |
datetime |
Statistisc a rouvert ses portes à | |||
stats_ |
datetime |
Le demandeur de statistiques a répondu à | |||
stats_ |
datetime |
Statistiques établies à | |||
stats_ |
datetime |
État des statistiques - Mise à jour le | |||
status |
int16 |
Status | Status of the ticket. | ||
subject |
varchar2 |
Subject | Ticket subject. | ||
ticket_ |
varchar2 |
Type de billet | Type property field as defined in ticket fields. | ||
to_ |
varchar2 |
Aux e-mails | |||
twitter_ |
varchar2 |
Identifiant 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 |
Mise à jour à | Date/time at which the record was last updated. |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :