Tickets: Freshservice Tickets
insert update delete REST
- Catalogus:
Freshservice - Schema:
Freshservice - Primaire sleutels:
id - Label: Tickets
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
Samenvatting
Tickets.
API-bron
- Eindpunt:
/tickets?include=requester,stats
Parameters
| Name | Datatype | 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. |
Tabelkolommen
De kolommen van de tabel Tickets worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | 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 |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: