invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

tickets: Freshdesk Tickets

insert update delete REST

  • Catalogus: Freshdesk
  • Schema: Freshdesk
  • Primaire sleutels: id
  • Label: Tickets

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

Samenvatting

Tickets.

API-bron

  • Eindpunt: /tickets?include=stats

Parameters

Name Datatype 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.

Tabelkolommen

De kolommen van de tabel 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
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_id varchar2 Aanvrager ID User-id of the requester.For existing contacts, requester_id can be passed instead of email.
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: