invantive documentation
Invantive Support ForumsLog In / Sign Up

RecentTickets: Freshservice Tickets (Recent)

insert update delete REST

  • Catalog: Freshservice
  • Schema: Freshservice
  • Primary Keys: id
  • Label: Tickets (Recent)

Can retrieve data and change data using insert, update and delete.

Summary

Tickets created in the last 30 days.

API Source

  • Endpoint: /tickets?include=requester,stats

Table Columns

The columns of the table RecentTickets are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type 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

What changed per release in the tables, columns, attributes and capabilities of the driver: