invantive documentation
Invantive Support ForumsLog In / Sign Up

recent_tickets: Freshdesk Tickets (Recent)

insert update delete REST

  • Catalog: Freshdesk
  • Schema: Freshdesk
  • Primary Keys: id
  • Label: Tickets (Recent)

Can retrieve data and change data using insert, update and delete.

Summary

Tickets created in the last 30 days.

API Source

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

Table Columns

The columns of the table recent_tickets are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
associated_tickets_count int64 Associated Tickets Count
cf_reference_number decimal Reference Number Custom field #10000152167 of type custom_number.
company_id int64 Company ID
company_name varchar2 Company Name
created_at datetime 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.
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 by 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 Email Configuration 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 From Due by Timestamp that denotes when the first response is due.
fr_escalated char From Escalated Set to true if the ticket has been escalated as the result of first response time being breached.
group_id int64 Group ID ID of Group to which the ticket is assigned.
id int64 ID Unique ID of the ticket.
internal_agent_id int64 Internal Agent ID
internal_group_id int64 Internal Group ID
is_escalated char Is Escalated Set to true if an escalation was sent.
name varchar2 Name Name of the requester.
nr_due_by datetime Due by (NR)
nr_escalated char Escalated (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 Requester Email 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 Requester ID User-id of the requester. For existing contacts, requester_id can be passed instead of email.
requester_mobile varchar2 Requester Mobile
requester_name varchar2 Requester Name 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 Requester Phone 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 Requester 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 Responder 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 Statistics Agent Responded at
stats_closed_at datetime Statistics Closed at
stats_first_responded_at datetime Statistics First Responded at
stats_pending_since datetime Statistics Pending since
stats_reopened_at datetime Statistisc Reopened at
stats_requester_responded_at datetime Statistics Requester Responded at
stats_resolved_at datetime Statistics Resolved at
stats_status_updated_at datetime Statistics Status Updated at
status int16 Status Status of the ticket.
subject varchar2 Subject Ticket subject.
ticket_type varchar2 Ticket Type Type property field as defined in ticket fields.
to_emails varchar2 To Emails
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 Updated at Date/time at which the record was last updated.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: