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

Please enable JavaScript to view this site.

Freshdesk API Data Model Forums

agents: Freshdesk Agents

Table Columns