invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

tickets_incremental: Freshdesk Tickets (Incremental)

insert update delete

  • Catálogo: Freshdesk
  • Esquema: Freshdesk
  • Llaves Primarias: id
  • Label: Tickets (Incremental)

Permite recuperar y modificar datos utilizando insert, update y delete.

Resumen

Tickets.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla tickets_incremental. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
associated_tickets_count int64 Número de entradas asociadas
cf_reference_number decimal Número de Referencia Custom field #10000152167 of type custom_number.
company_id int64 ID de la Empresa
created_at datetime Creado en 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 Descripción (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 Debido por 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 Configuración del Correo Electrónico ID of email config which is used for this ticket.
facebook_id varchar2 ID de Facebook Facebook ID of the requester.A contact should exist with this facebook_id in Freshdesk.
fr_due_by datetime Desde Vencido por Timestamp that denotes when the first response is due.
fr_escalated char Desde Escalado Set to true if the ticket has been escalated as the result of first response time being breached.
group_id int64 ID del Grupo ID of Group to which the ticket is assigned.
id int64 ID Unique ID of the ticket.
internal_agent_id int64 Identificador interno del agente
internal_group_id int64 ID interno del grupo
is_escalated char Es Escalado Set to true if an escalation was sent.
name varchar2 Name Name of the requester.
nr_due_by datetime Fecha límite: (sin especificar)
nr_escalated char Escalado (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 ID del Producto ID of the product to which the ticket is associated.
requester_id varchar2 ID del Solicitante User-id of the requester.For existing contacts, requester_id can be passed instead of email.
responder_id int64 ID del Remitente 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 El agente de estadísticas respondió a las
stats_closed_at datetime Estadísticas Cerrado a las
stats_first_responded_at datetime Estadísticas sobre las primeras intervenciones en
stats_pending_since datetime Estadísticas pendientes desde
stats_reopened_at datetime Statistisc ha reabierto sus puertas en
stats_requester_responded_at datetime El solicitante de las estadísticas respondió a las
stats_resolved_at datetime Estadísticas resueltas en
stats_status_updated_at datetime Estado de las estadísticas actualizado a las
status int16 Status Status of the ticket.
subject varchar2 Subject Ticket subject.
ticket_type varchar2 Tipo de billete Type property field as defined in ticket fields.
to_emails varchar2 A Correos Electrónicos
twitter_id varchar2 ID de 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 Actualizado en Date/time at which the record was last updated.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: