invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

recent_tickets: Freshdesk Tickets (Recent)

insert update delete REST

  • Catalogus: Freshdesk
  • Schema: Freshdesk
  • Primaire sleutels: id
  • Label: Tickets (Recent)

Je kunt gegevens ophalen en wijzigen met insert, update en delete.

Samenvatting

Tickets aangemaakt in de laatste 30 dagen.

API-bron

  • Eindpunt: /tickets?include=requester,stats,company

Tabelkolommen

De kolommen van de tabel recent_tickets worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
associated_tickets_count int64 Aantal Gekoppelde Tickets
cf_reference_number decimal Reference Number Custom field #10000152167 of type custom_number.
company_id int64 Bedrijf ID
company_name varchar2 Naam bedrijf
created_at datetime Aangemaakt op 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 Omschrijving (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 Vervalt op 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 E-mail Configuratie ID ID of email config which is used for this ticket.
facebook_id varchar2 Facebook ID Facebook ID of the requester.A contact should exist with this facebook_id in Freshdesk.
fr_due_by datetime Van Vervallen door Timestamp that denotes when the first response is due.
fr_escalated char Van Geëscaleerd Set to true if the ticket has been escalated as the result of first response time being breached.
group_id int64 Groeps-ID ID of Group to which the ticket is assigned.
id int64 ID Unique ID of the ticket.
internal_agent_id int64 Interne Agent-ID
internal_group_id int64 Interne Groep-ID
is_escalated char Is Geëscaleerd Set to true if an escalation was sent.
name varchar2 Name Name of the requester.
nr_due_by datetime Vervalt op (NR)
nr_escalated char Geëscaleerd (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 Product-ID ID of the product to which the ticket is associated.
requester_email varchar2 Aanvrager E-mail Email address of the requester.If no contact exists with this email address in Freshdesk, it will be added as a new contact.
requester_id varchar2 Aanvrager ID User-id of the requester.For existing contacts, requester_id can be passed instead of email.
requester_mobile varchar2 Verzoeker Mobielnummer
requester_name varchar2 Naam Aanvrager Name of the requester.If no contact exists with the above mentioned email address in Freshdesk, it will be added as a new contact with this name.Name of the existing contact won't be overwritten by this name.
requester_phone varchar2 Aanvrager Telefoon Phone number of the requester.If no contact exists with this phone number in Freshdesk, it will be added as a new contact. name is a mandatory attribute if phone number is given.
requester_twitter_id varchar2 Verzoek Twitter-ID Twitter id of the requester.If no contact exists with this twitter_id in Freshdesk, it will be added as a new contact.
responder_id int64 Beantwoorder ID 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 Statistieken Agent Reageerde op
stats_closed_at datetime Statistieken Gesloten op
stats_first_responded_at datetime Statistieken Eerste Reactie op
stats_pending_since datetime Statistieken in Behandeling sinds
stats_reopened_at datetime Statistieken Heropend op
stats_requester_responded_at datetime Statistieken Verzoeker Antwoordde op
stats_resolved_at datetime Statistieken Opgelost op
stats_status_updated_at datetime Statistieken Status Bijgewerkt op
status int16 Status Status of the ticket.
subject varchar2 Subject Ticket subject.
ticket_type varchar2 Ticketsoort Type property field as defined in ticket fields.
to_emails varchar2 Naar E-mails
twitter_id varchar2 Twitter ID 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 Bijgewerkt op Date/time at which the record was last updated.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: