Please enable JavaScript to view this site.

Navigation: Schema: Freshdesk > Tables

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