Tickets: Freshservice Tickets
insert update delete REST
- Catalogo:
Freshservice - Schema:
Freshservice - Chiavi primarie:
id - Label: Tickets
È possibile recuperare e modificare i dati utilizzando insert, update e delete.
Riepilogo
Tickets.
Codice sorgente dell'API
- Punto finale:
/tickets?include=requester,stats
Parametri
| Name | Tipo di dati | 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. |
Colonne della tabella
Di seguito sono riportate le colonne della tabella 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 |
|---|---|---|---|---|---|
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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: