tickets: Freshdesk Tickets
insert update delete REST
- Catálogo:
Freshdesk - Esquema:
Freshdesk - Llaves Primarias:
id - Label: Tickets
Permite recuperar y modificar datos utilizando insert, update y delete.
Resumen
Tickets.
Fuente de la API
- Punto final:
/tickets?include=stats
Parámetros
| Name | Tipo de Datos | 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. |
Columnas de la Tabla
A continuación se muestran las columnas de la tabla tickets. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
associated_ |
int64 |
Número de entradas asociadas | |||
cf_ |
decimal |
Número de Referencia | Custom field #10000152167 of type custom_number. | ||
company_ |
int64 |
ID de la Empresa | |||
created_ |
datetime |
Creado en | 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 |
Descripción (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 |
Debido por | 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 Configuración del Correo Electrónico | ID of email config which is used for this ticket. | ||
facebook_ |
varchar2 |
ID de Facebook | Facebook ID of the requester.A contact should exist with this facebook_id in Freshdesk. | ||
fr_ |
datetime |
Desde Vencido por | Timestamp that denotes when the first response is due. | ||
fr_ |
char |
Desde Escalado | Set to true if the ticket has been escalated as the result of first response time being breached. | ||
group_ |
int64 |
ID del Grupo | ID of Group to which the ticket is assigned. | ||
id |
int64 |
ID | Unique ID of the ticket. | ||
internal_ |
int64 |
Identificador interno del agente | |||
internal_ |
int64 |
ID interno del grupo | |||
is_ |
char |
Es Escalado | Set to true if an escalation was sent. | ||
name |
varchar2 |
Name | Name of the requester. | ||
nr_ |
datetime |
Fecha límite: (sin especificar) | |||
nr_ |
char |
Escalado (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 Producto | ID of the product to which the ticket is associated. | ||
requester_ |
varchar2 |
ID del Solicitante | User-id of the requester.For existing contacts, requester_id can be passed instead of email. | ||
responder_ |
int64 |
ID del Remitente | 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 |
El agente de estadísticas respondió a las | |||
stats_ |
datetime |
Estadísticas Cerrado a las | |||
stats_ |
datetime |
Estadísticas sobre las primeras intervenciones en | |||
stats_ |
datetime |
Estadísticas pendientes desde | |||
stats_ |
datetime |
Statistisc ha reabierto sus puertas en | |||
stats_ |
datetime |
El solicitante de las estadísticas respondió a las | |||
stats_ |
datetime |
Estadísticas resueltas en | |||
stats_ |
datetime |
Estado de las estadísticas actualizado a las | |||
status |
int16 |
Status | Status of the ticket. | ||
subject |
varchar2 |
Subject | Ticket subject. | ||
ticket_ |
varchar2 |
Tipo de billete | Type property field as defined in ticket fields. | ||
to_ |
varchar2 |
A Correos Electrónicos | |||
twitter_ |
varchar2 |
ID de 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 |
Actualizado en | Date/time at which the record was last updated. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: