Please enable JavaScript to view this site.

Navigation: Schema: Freshdesk > Tables

tickets: Freshdesk Tickets

Catalog: Freshdesk

Schema: Freshdesk

Primary Keys: id

Label: Tickets

Documentation:

Tickets.

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

Select Freshdesk API URL: /tickets?include=stats

Insert Freshdesk API URL: /tickets

Update Freshdesk API URL: /tickets

Delete Freshdesk API URL: /tickets

Field Selection Method: NotRequired

Table Function Parameters

The following parameters can be used to control the behaviour of the table function tickets. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name

Data Type

Required

Default Value

Documentation

company_id

int64

 

Company ID of requester.

email

string

 

Email address of requester.

filter

string

 

Pre-defined filter: 'new_and_my_open', 'watching', 'spam' and 'deleted'.

query

string

 

Custom query matching Freshdesk specifications, such as 'priority:3 OR priority:2'.

requester_id

int64

 

ID of requester.

updated_since

datetime

01/01/1900 00:00:00

Limit to tickets updated since.

 

Table Function Columns

The columns of the table function 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 or update.

Name

Data Type

Label

Required

Documentation

associated_tickets_count

int64

 

 

company_id

int64

Company ID

 

created_at

datetime

Created at

Date/time at which the record was created.

deleted

boolean

Deleted

Set as true if the ticket is deleted/trashed. Deleted tickets will not be considered in any views except 'deleted' filter.

description_html

string

 

HTML content of the ticket. Description and description_html should not be passed together.

description_text

string

Description

Plain text content of the ticket.

description

string

Description

 

due_by

datetime

Due by

Ticket due-by time.

email_config_id

int64

Email Configuration ID

ID of email config which is used for this ticket.

email

string

Email

Email address of the requester. If no contact exists with this email address in Freshdesk, it will be added as a new contact.

facebook_id

string

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

boolean

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_group_id

int64

 

 

is_escalated

boolean

Is Escalated

Set to true if an escalation was sent.

name

string

Name

Name of the requester.

nr_due_by

datetime

 

 

nr_escalated

boolean

 

 

phone

string

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

string

Requester ID

User-id of the requester. For existing contacts, requester_id can be passed instead of email.

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

string

Spam

Set as true if the ticket is marked as spam.

stats_agent_responded_at

datetime

 

 

stats_closed_at

datetime

 

 

stats_first_responded_at

datetime

 

 

stats_pending_since

datetime

 

 

stats_reopened_at

datetime

 

 

stats_requester_responded_at

datetime

 

 

stats_resolved_at

datetime

 

 

stats_status_updated_at

datetime

 

 

status

int16

Status

Status of the ticket.

subject

string

Subject

Ticket subject.

ticket_type

string

 

Type property field as defined in ticket fields.

to_emails

string

To Emails

 

twitter_id

string

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

string

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.

 

27-12-2021 10:23 Version 20.2.169-PROD+3633