Tickets: Freshservice Tickets
insert update delete REST
- Catalogue :
Freshservice - Schéma :
Freshservice - 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=requester,stats
Paramètres
| Name | Type de données | 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. |
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 |
|---|---|---|---|---|---|
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 |
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 :