invantive documentation
Invantive SupportforenAnmelden / Eintragen

TicketsIncremental: Freshservice Tickets (Incremental)

insert update delete

  • Katalog: Freshservice
  • Schema: Freshservice
  • Primärschlüssel: id
  • Label: Tickets (Incremental)

Mit insert, update und delete können Daten abgerufen und geändert werden.

Zusammenfassung

Tickets.

Tabellenspalten

Die Spalten der Tabelle TicketsIncremental sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp 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

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: