invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

tickets: Freshdesk Tickets

insert update delete REST

  • Catalogue : Freshdesk
  • Schéma : Freshdesk
  • Clés primaires : id
  • Label: Tickets

Permet de récupérer et de modifier des données à l'aide de insert, update et delete.

Résumé

Tickets.

Source de l'API

  • Point de terminaison : /tickets?include=stats

Paramètres

Name Type de données Required Default Documentation
company_id int64 Company ID of requester.
email varchar2 Email address of requester.
filter varchar2 Pre-defined filter: 'new_and_my_open', 'watching', 'spam' and 'deleted'.
requester_id int64 ID of requester.
updated_since datetime 01/01/1900 00:00:00 Limit to tickets updated since.

Colonnes de table

Les colonnes de la table tickets sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
associated_tickets_count int64 Nombre de billets associés
cf_reference_number decimal Numéro de Référence Custom field #10000152167 of type custom_number.
company_id int64 ID de l'entreprise
created_at datetime Créé le 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.
description varchar2 Description
description_html varchar2 Description (HTML) HTML content of the ticket.Description and description_html should not be passed together.
description_text varchar2 Description Plain text content of the ticket.
due_by datetime Due par Ticket due-by time.
email varchar2 Email Email address of the requester.If no contact exists with this email address in Freshdesk, it will be added as a new contact.
email_config_id int64 ID de configuration d'e-mail ID of email config which is used for this ticket.
facebook_id varchar2 Identifiant Facebook Facebook ID of the requester.A contact should exist with this facebook_id in Freshdesk.
fr_due_by datetime De dû par Timestamp that denotes when the first response is due.
fr_escalated char À partir de Escalated Set to true if the ticket has been escalated as the result of first response time being breached.
group_id int64 ID de groupe ID of Group to which the ticket is assigned.
id int64 ID Unique ID of the ticket.
internal_agent_id int64 Identifiant interne de l'agent
internal_group_id int64 Identifiant interne du groupe
is_escalated char Est escaladé Set to true if an escalation was sent.
name varchar2 Name Name of the requester.
nr_due_by datetime Date limite : (NR)
nr_escalated char Transmis à un niveau supérieur (NR)
phone varchar2 Phone Phone number of the requester.If no contact exists with this phone number in Freshdesk, it will be added as a new contact.If the phone number is set and the email address is not, then the name attribute is mandatory.
priority int16 Priority Priority of the ticket.
product_id int64 Produit ID ID of the product to which the ticket is associated.
requester_id varchar2 ID du demandeur User-id of the requester.For existing contacts, requester_id can be passed instead of email.
responder_id int64 Identifiant du répondeur ID of the agent to whom the ticket is assigned.
source int16 Source The channel through which the ticket was created.
spam char Spam Set as true if the ticket is marked as spam.
stats_agent_responded_at datetime L'agent chargé des statistiques a répondu à
stats_closed_at datetime Statistiques clôturées à
stats_first_responded_at datetime Statistiques relatives aux premiers intervenants à
stats_pending_since datetime Statistiques en attente depuis
stats_reopened_at datetime Statistisc a rouvert ses portes à
stats_requester_responded_at datetime Le demandeur de statistiques a répondu à
stats_resolved_at datetime Statistiques établies à
stats_status_updated_at datetime État des statistiques - Mise à jour le
status int16 Status Status of the ticket.
subject varchar2 Subject Ticket subject.
ticket_type varchar2 Type de billet Type property field as defined in ticket fields.
to_emails varchar2 Aux e-mails
twitter_id varchar2 Identifiant Twitter Twitter handle of the requester.If no contact exists with this handle in Freshdesk, it will be added as a new contact.
type varchar2 Type Helps categorize the ticket according to the different kinds of issues your support team deals with.
updated_at datetime Mise à jour à Date/time at which the record was last updated.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :