invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

RecentTickets: Freshservice Tickets (Recent)

insert update delete REST

  • Catalogus: Freshservice
  • Schema: Freshservice
  • Primaire sleutels: id
  • Label: Tickets (Recent)

Je kunt gegevens ophalen en wijzigen met insert, update en delete.

Samenvatting

Tickets aangemaakt in de laatste 30 dagen.

API-bron

  • Eindpunt: /tickets?include=requester,stats

Tabelkolommen

De kolommen van de tabel RecentTickets 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_impact varchar2 Business impact Custom field #50000103641 of type custom_paragraph.
call_code varchar2 Call_code Custom field #50000011369 of type custom_text.
categorie_aariverside varchar2 Categorie AaRiverside Custom field #50000097751 of type nested_field.
categorie_facilitair varchar2 Categorie Facilitair Custom field #50000010875 of type nested_field.
categorie_flex varchar2 Categorie Flex Custom field #50000010876 of type nested_field.
categorie_nocore_intern varchar2 Categorie Nocore intern Custom field #50000099436 of type custom_dropdown.
category varchar2 Category
created_at 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_id int64 itgen_freshservice_department_id
description varchar2 Description
description_text varchar2 itgen_freshservice_description_text Plain text content of the ticket.
due_by datetime itgen_freshservice_due_by Ticket due-by time.
email_config_id int64 itgen_freshservice_email_config_id ID of email config which is used for this ticket.
fr_due_by datetime itgen_freshservice_fr_due_by Timestamp that denotes when the first response is due.
fr_escalated char itgen_freshservice_fr_escalated Set to true if the ticket has been escalated as the result of first response time being breached.
group_id int64 itgen_freshservice_group_id ID of Group to which the ticket is assigned.
id int64 ID Unique ID of the ticket.
impacted_locations varchar2 Impacted locations Custom field #50000103642 of type custom_text.
incident_alleen_zichtbaar_voor_mij_niet_voor_andere_collegas char Incident alleen zichtbaar voor mij, niet voor andere collega's Custom field #50000009057 of type custom_checkbox.
incorrect_ingeladen varchar2 Incorrect ingeladen Custom field #50000011765 of type custom_dropdown.
is_escalated char itgen_freshservice_is_escalated Set to true if an escalation was sent.
item_category varchar2 itgen_freshservice_item_category
major_incident_type varchar2 Major incident type Custom field #50000103640 of type custom_dropdown.
no_of_customers_impacted varchar2 No. of customers impacted Custom field #50000103643 of type custom_text.
priority int16 Priority Priority of the ticket.
requested_for_id int64 itgen_freshservice_requested_for_id
requester_email varchar2 itgen_freshservice_requester_email Email address of the requester.
requester_id varchar2 itgen_freshservice_requester_id User-id of the requester.For existing contacts, requester_id can be passed instead of email.
requester_mobile varchar2 itgen_freshservice_requester_mobile
requester_name varchar2 itgen_freshservice_requester_name Name of the requester.
requester_phone 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_agent_responded_at datetime itgen_freshservice_stats_agent_responded_at
stats_assigned_at datetime itgen_freshservice_stats_assigned_at
stats_closed_at datetime itgen_freshservice_stats_closed_at
stats_first_assigned_at datetime itgen_freshservice_stats_first_assigned_at
stats_first_resp_time_in_secs int64 itgen_freshservice_stats_first_resp_time_in_secs
stats_first_responded_at datetime itgen_freshservice_stats_first_responded_at
stats_group_escalated char itgen_freshservice_stats_group_escalated
stats_inbound_count int64 itgen_freshservice_stats_inbound_count
stats_opened_at datetime itgen_freshservice_stats_opened_at
stats_outbound_count int64 itgen_freshservice_stats_outbound_count
stats_pending_since datetime itgen_freshservice_stats_pending_since
stats_requester_responded_at datetime itgen_freshservice_stats_requester_responded_at
stats_resolution_time_in_secs int64 itgen_freshservice_stats_resolution_time_in_secs
stats_resolved_at datetime itgen_freshservice_stats_resolved_at
stats_status_updated_at datetime itgen_freshservice_stats_status_updated_at
status int16 Status Status of the ticket.
sub_category varchar2 itgen_freshservice_sub_category
subcategorie varchar2 Categorie AaRiverside Nested field #50000097751 level 2 on custom field 'categorie_aariverside'.
subcategorie_facilitair varchar2 Categorie Facilitair Nested field #50000010875 level 2 on custom field 'categorie_facilitair'.
subcategorie_flex 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_facilitair varchar2 Categorie Facilitair Nested field #50000010875 level 3 on custom field 'categorie_facilitair'.
subsubcategorie_flex varchar2 Categorie Flex Nested field #50000010876 level 3 on custom field 'categorie_flex'.
tasks_dependency_type 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_at datetime itgen_freshservice_updated_at Date/time at which the record was last updated.
workspace_id int64 itgen_freshservice_workspace_id

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: