invantive documentation
Invantive Support ForumsLog In / Sign Up

SearchTickets: Freshservice Search Tickets

insert update delete REST

  • Catalog: Freshservice
  • Schema: Freshservice
  • Primary Keys: id
  • Label: Search Tickets

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

Summary

Search for tickets using a query.

API Source

  • Endpoint: /tickets/filter

Parameters

Name Data Type Required Default Documentation
query varchar2 Custom query matching Freshservice specifications, such as '(priority:3 OR priority:2) AND created_at:>'2022-01-01''. The following fields to be used can be found on https://api.freshservice.com/#filter_tickets.

Table Columns

The columns of the table SearchTickets 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.
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: