Tickets: Freshservice Tickets
insert update delete REST
- Catálogo:
Freshservice - Esquema:
Freshservice - 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=requester,stats
Parámetros
| Name | Tipo de Datos | Required | Default | Documentation |
|---|---|---|---|---|
email |
varchar2 |
Email address of requester. | ||
filter |
varchar2 |
Pre-defined filter: 'new_and_my_open', 'watching', 'spam' and 'deleted'. | ||
requester_ |
int64 |
ID of requester. | ||
type |
varchar2 |
Type such as 'incident'. | ||
updated_ |
datetime |
01/01/1900 00:00:00 | Limit to tickets updated since. | |
workspace_ |
int64 |
ID of workspace. |
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 |
|---|---|---|---|---|---|
business_ |
varchar2 |
Business impact | Custom field #50000103641 of type custom_paragraph. | ||
call_ |
varchar2 |
Call_code | Custom field #50000011369 of type custom_text. | ||
categorie_ |
varchar2 |
Categorie AaRiverside | Custom field #50000097751 of type nested_field. | ||
categorie_ |
varchar2 |
Categorie Facilitair | Custom field #50000010875 of type nested_field. | ||
categorie_ |
varchar2 |
Categorie Flex | Custom field #50000010876 of type nested_field. | ||
categorie_ |
varchar2 |
Categorie Nocore intern | Custom field #50000099436 of type custom_dropdown. | ||
category |
varchar2 |
Category | |||
created_ |
datetime |
itgen_freshservice_created_at | 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. | ||
department_ |
int64 |
itgen_freshservice_department_id | |||
description |
varchar2 |
Description | |||
description_ |
varchar2 |
itgen_freshservice_description_text | Plain text content of the ticket. | ||
due_by |
datetime |
itgen_freshservice_due_by | Ticket due-by time. | ||
email_ |
int64 |
itgen_freshservice_email_config_id | ID of email config which is used for this ticket. | ||
fr_ |
datetime |
itgen_freshservice_fr_due_by | Timestamp that denotes when the first response is due. | ||
fr_ |
char |
itgen_freshservice_fr_escalated | Set to true if the ticket has been escalated as the result of first response time being breached. | ||
group_ |
int64 |
itgen_freshservice_group_id | ID of Group to which the ticket is assigned. | ||
id |
int64 |
ID | Unique ID of the ticket. | ||
impacted_ |
varchar2 |
Impacted locations | Custom field #50000103642 of type custom_text. | ||
incident_ |
char |
Incident alleen zichtbaar voor mij, niet voor andere collega's | Custom field #50000009057 of type custom_checkbox. | ||
incorrect_ |
varchar2 |
Incorrect ingeladen | Custom field #50000011765 of type custom_dropdown. | ||
is_ |
char |
itgen_freshservice_is_escalated | Set to true if an escalation was sent. | ||
item_ |
varchar2 |
itgen_freshservice_item_category | |||
major_ |
varchar2 |
Major incident type | Custom field #50000103640 of type custom_dropdown. | ||
no_ |
varchar2 |
No. of customers impacted | Custom field #50000103643 of type custom_text. | ||
priority |
int16 |
Priority | Priority of the ticket. | ||
requested_ |
int64 |
itgen_freshservice_requested_for_id | |||
requester_ |
varchar2 |
itgen_freshservice_requester_email | Email address of the requester. | ||
requester_ |
varchar2 |
itgen_freshservice_requester_id | User-id of the requester.For existing contacts, requester_id can be passed instead of email. | ||
requester_ |
varchar2 |
itgen_freshservice_requester_mobile | |||
requester_ |
varchar2 |
itgen_freshservice_requester_name | Name of the requester. | ||
requester_ |
varchar2 |
itgen_freshservice_requester_phone | Phone number of the requester. | ||
source |
varchar2 |
Source | |||
spam |
char |
Spam | Set as true if the ticket is marked as spam. | ||
stats_ |
datetime |
itgen_freshservice_stats_agent_responded_at | |||
stats_ |
datetime |
itgen_freshservice_stats_assigned_at | |||
stats_ |
datetime |
itgen_freshservice_stats_closed_at | |||
stats_ |
datetime |
itgen_freshservice_stats_first_assigned_at | |||
stats_ |
int64 |
itgen_freshservice_stats_first_resp_time_in_secs | |||
stats_ |
datetime |
itgen_freshservice_stats_first_responded_at | |||
stats_ |
char |
itgen_freshservice_stats_group_escalated | |||
stats_ |
int64 |
itgen_freshservice_stats_inbound_count | |||
stats_ |
datetime |
itgen_freshservice_stats_opened_at | |||
stats_ |
int64 |
itgen_freshservice_stats_outbound_count | |||
stats_ |
datetime |
itgen_freshservice_stats_pending_since | |||
stats_ |
datetime |
itgen_freshservice_stats_requester_responded_at | |||
stats_ |
int64 |
itgen_freshservice_stats_resolution_time_in_secs | |||
stats_ |
datetime |
itgen_freshservice_stats_resolved_at | |||
stats_ |
datetime |
itgen_freshservice_stats_status_updated_at | |||
status |
int16 |
Status | Status of the ticket. | ||
sub_ |
varchar2 |
itgen_freshservice_sub_category | |||
subcategorie |
varchar2 |
Categorie AaRiverside | Nested field #50000097751 level 2 on custom field 'categorie_aariverside'. | ||
subcategorie_ |
varchar2 |
Categorie Facilitair | Nested field #50000010875 level 2 on custom field 'categorie_facilitair'. | ||
subcategorie_ |
varchar2 |
Categorie Flex | Nested field #50000010876 level 2 on custom field 'categorie_flex'. | ||
subject |
varchar2 |
Subject | Ticket subject. | ||
subsubcategorie |
varchar2 |
Categorie AaRiverside | Nested field #50000097751 level 3 on custom field 'categorie_aariverside'. | ||
subsubcategorie_ |
varchar2 |
Categorie Facilitair | Nested field #50000010875 level 3 on custom field 'categorie_facilitair'. | ||
subsubcategorie_ |
varchar2 |
Categorie Flex | Nested field #50000010876 level 3 on custom field 'categorie_flex'. | ||
tasks_ |
int16 |
itgen_freshservice_tasks_dependency_type | |||
type |
varchar2 |
Type | Helps categorize the ticket according to the different kinds of issues your support team deals with. | ||
updated_ |
datetime |
itgen_freshservice_updated_at | Date/time at which the record was last updated. | ||
workspace_ |
int64 |
itgen_freshservice_workspace_id |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: