invantive documentation
Invantive Support ForumsLog In / Sign Up

TicketsIncremental: Freshservice Tickets (Incremental)

insert update delete

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

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

Summary

Tickets.

Table Columns

The columns of the table TicketsIncremental 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_id varchar2 itgen_freshservice_requester_id User-id of the requester. For existing contacts, requester_id can be passed instead of email.
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: