Error itgendoc001X
xMsg javascript has not been loaded.
Freshdesk API Data ModelCatalog: Freshdesk
Schema: Freshdesk
Primary Keys: id
Label: Tickets
Can retrieve data and change data using insert, update and delete.
Select Freshdesk API URL: /tickets?include=requester,stats,company
Insert Freshdesk API URL: /tickets
Update Freshdesk API URL: /tickets
Delete Freshdesk API URL: /tickets
Field Selection Method: NotRequired
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 or update.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
closed_at |
datetime |
Closed at |
☐ |
|
company_id |
int64 |
Company ID |
☐ |
|
company_name |
string |
Company Name |
☐ |
|
created_at |
datetime |
Created at |
☐ |
|
description |
string |
Description |
☐ |
|
description_text |
string |
Description |
☐ |
|
due_by |
datetime |
Due by |
☐ |
|
string |
☐ |
|
||
email_config_id |
int64 |
Email Configuration ID |
☐ |
|
first_responded_at |
datetime |
First Responded at |
☐ |
|
fr_due_by |
datetime |
From Due by |
☐ |
|
fr_escalated |
boolean |
From Escalated |
☐ |
|
group_id |
int64 |
Group ID |
☐ |
|
id |
int64 |
ID |
☐ |
|
is_escalated |
boolean |
Is Escalated |
☐ |
|
mobile |
string |
Mobile |
☐ |
|
name |
string |
Name |
☐ |
|
phone |
string |
Phone |
☐ |
|
priority |
int16 |
Priority |
☐ |
|
product_id |
int64 |
Product ID |
☐ |
|
requester_id |
string |
Requester ID |
☐ |
|
resolved_at |
datetime |
Resolved at |
☐ |
|
responder_id |
int64 |
Responder ID |
☐ |
|
source |
int16 |
Source |
☐ |
|
spam |
string |
Spam |
☐ |
|
status |
int16 |
Status |
☐ |
|
subject |
string |
Subject |
☐ |
|
to_emails |
string |
To Emails |
☐ |
|
type |
string |
Type |
☐ |
|
updated_at |
datetime |
Updated at |
☐ |
|
12-12-2020 13:14 Version 20.1.301-BETA+3023
