agents: Freshdesk Agents |
Catalog: Freshdesk
Schema: Freshdesk
Primary Keys: id
Label: Agents
This is a read-only table. The Freshdesk API may not support changing the data or the Invantive SQL driver for Freshdesk does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Freshdesk API.
Select Freshdesk API URL: /agents
Insert Freshdesk API URL: /agents
Update Freshdesk API URL: /agents
Delete Freshdesk API URL: /agents
Field Selection Method: NotRequired
Table Columns
The columns of the table agents are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
available_since |
datetime |
Available since |
☐ |
Timestamp that denotes when the agent became available/unavailable (depending on the value of the 'available' attribute). |
available |
boolean |
Available |
☐ |
If the agent is in a group that has enabled 'Automatic Ticket Assignment', this attribute will be set to true if the agent is accepting new tickets. |
contact_active |
boolean |
Contact Active |
☐ |
|
contact_created_at |
datetime |
Contact Created at |
☐ |
|
contact_email |
string |
Contact Email Address |
☐ |
|
contact_job_title |
string |
Contact Job Title |
☐ |
|
contact_language |
string |
Contact Language |
☐ |
|
contact_last_login_at |
datetime |
Contact Last Login at |
☐ |
|
contact_mobile |
string |
Contact Mobile Phone |
☐ |
|
contact_name |
string |
Contact Name |
☐ |
|
contact_phone |
string |
Contact Phone |
☐ |
|
contact_time_zone |
string |
Contact Time Zone |
☐ |
|
contact_updated_at |
datetime |
Contact Updated at |
☐ |
|
created_at |
datetime |
Created at |
☐ |
Date/time at which the record was created. |
id |
int64 |
ID |
☐ |
ID of an agent. |
occasional |
boolean |
Occasional |
☐ |
Whether the agent is an occasional agent. |
points |
string |
|
☐ |
Points scored by the agent. |
scoreboard_level_id |
int64 |
|
☐ |
Scoreboard level ID. |
signature_html |
string |
|
☐ |
Signature of an agent in HTML format. |
signature |
string |
Signature |
☐ |
|
ticket_permission |
int64 |
|
☐ |
Ticket permission given to agent. |
ticket_scope |
int64 |
Ticket Scope |
☐ |
Ticket permission given to agent. |
updated_at |
datetime |
Updated at |
☐ |
Date/time at which the record was last updated. |
user_id |
int64 |
User ID |
☐ |
User ID of an agent. |
27-12-2021 10:23 Version 20.2.169-PROD+3633