# TicketsIncremental: Freshservice Tickets (Incremental) ## Documentation Tickets. - Catalog: `Freshservice` - Schema: `Freshservice` - Primary Keys: `id` - Label: Tickets (Incremental) Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `TicketsIncremental` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `business_impact` | `string` | Business impact | ☐ | Custom field #50000103641 of type custom_paragraph. | | `call_code` | `string` | Call_code | ☐ | Custom field #50000011369 of type custom_text. | | `categorie_aariverside` | `string` | Categorie AaRiverside | ☐ | Custom field #50000097751 of type nested_field. | | `categorie_facilitair` | `string` | Categorie Facilitair | ☐ | Custom field #50000010875 of type nested_field. | | `categorie_flex` | `string` | Categorie Flex | ☐ | Custom field #50000010876 of type nested_field. | | `categorie_nocore_intern` | `string` | Categorie Nocore intern | ☐ | Custom field #50000099436 of type custom_dropdown. | | `category` | `string` | | ☐ | | | `created_at` | `datetime` | | ☐ | Date/time at which the record was created. | | `deleted` | `boolean` | | ☐ | Set as true if the ticket is deleted/trashed. Deleted tickets will not be considered in any views except 'deleted' filter. | | `department_id` | `int64` | | ☐ | | | `description_text` | `string` | | ☐ | Plain text content of the ticket. | | `description` | `string` | | ☐ | | | `due_by` | `datetime` | | ☐ | Ticket due-by time. | | `email_config_id` | `int64` | | ☐ | ID of email config which is used for this ticket. | | `fr_due_by` | `datetime` | | ☐ | Timestamp that denotes when the first response is due. | | `fr_escalated` | `boolean` | | ☐ | Set to true if the ticket has been escalated as the result of first response time being breached. | | `group_id` | `int64` | | ☐ | ID of Group to which the ticket is assigned. | | `id` | `int64` | | ☑ | Unique ID of the ticket. | | `impacted_locations` | `string` | Impacted locations | ☐ | Custom field #50000103642 of type custom_text. | | `incident_alleen_zichtbaar_voor_mij_niet_voor_andere_collegas` | `boolean` | Incident visible only to me, not to other colleagues | ☐ | Custom field #50000009057 of type custom_checkbox. | | `incorrect_ingeladen` | `string` | Incorrect ingeladen | ☐ | Custom field #50000011765 of type custom_dropdown. | | `is_escalated` | `boolean` | | ☐ | Set to true if an escalation was sent. | | `item_category` | `string` | | ☐ | | | `major_incident_type` | `string` | Major incident type | ☐ | Custom field #50000103640 of type custom_dropdown. | | `no_of_customers_impacted` | `string` | No. of customers impacted | ☐ | Custom field #50000103643 of type custom_text. | | `priority` | `int16` | | ☐ | Priority of the ticket. | | `requested_for_id` | `int64` | | ☐ | | | `requester_id` | `string` | | ☐ | User-id of the requester. For existing contacts, requester_id can be passed instead of email. | | `source` | `string` | | ☐ | | | `spam` | `boolean` | | ☐ | Set as true if the ticket is marked as spam. | | `stats_agent_responded_at` | `datetime` | | ☐ | | | `stats_assigned_at` | `datetime` | | ☐ | | | `stats_closed_at` | `datetime` | | ☐ | | | `stats_first_assigned_at` | `datetime` | | ☐ | | | `stats_first_resp_time_in_secs` | `int64` | | ☐ | | | `stats_first_responded_at` | `datetime` | | ☐ | | | `stats_group_escalated` | `boolean` | | ☐ | | | `stats_inbound_count` | `int64` | | ☐ | | | `stats_opened_at` | `datetime` | | ☐ | | | `stats_outbound_count` | `int64` | | ☐ | | | `stats_pending_since` | `datetime` | | ☐ | | | `stats_requester_responded_at` | `datetime` | | ☐ | | | `stats_resolution_time_in_secs` | `int64` | | ☐ | | | `stats_resolved_at` | `datetime` | | ☐ | | | `stats_status_updated_at` | `datetime` | | ☐ | | | `status` | `int16` | | ☐ | Status of the ticket. | | `sub_category` | `string` | | ☐ | | | `subcategorie_facilitair` | `string` | Categorie Facilitair | ☐ | Nested field #50000010875 level 2 on custom field 'categorie_facilitair'. | | `subcategorie_flex` | `string` | Categorie Flex | ☐ | Nested field #50000010876 level 2 on custom field 'categorie_flex'. | | `subcategorie` | `string` | Categorie AaRiverside | ☐ | Nested field #50000097751 level 2 on custom field 'categorie_aariverside'. | | `subject` | `string` | | ☐ | Ticket subject. | | `subsubcategorie_facilitair` | `string` | Categorie Facilitair | ☐ | Nested field #50000010875 level 3 on custom field 'categorie_facilitair'. | | `subsubcategorie_flex` | `string` | Categorie Flex | ☐ | Nested field #50000010876 level 3 on custom field 'categorie_flex'. | | `subsubcategorie` | `string` | Categorie AaRiverside | ☐ | Nested field #50000097751 level 3 on custom field 'categorie_aariverside'. | | `tasks_dependency_type` | `int16` | | ☐ | | | `type` | `string` | | ☐ | Helps categorize the ticket according to the different kinds of issues your support team deals with. | | `updated_at` | `datetime` | | ☐ | Date/time at which the record was last updated. | | `workspace_id` | `int64` | | ☐ | |