Update, delete, and query from agents table
Table Specific Information
The component will use the FreshDesk API to process WHERE clause conditions built with the following columns and operators. Most of the columns support server side filtering with the following operators: = > < <= >= AND OR. The rest of the filter is executed client side within the component.
For example, the following query is processed server side:
SELECT * FROM Agents WHERE Id = 100
Note: To query Agents table, All Agent APIs other than the Currently Authenticated Agent API require admin privileges.
Following is an example of how to update an agent:
UPDATE Agents SET GroupIdsAggregate = '111' WHERE Id = 100
Following is an example of how to delete an agent:
DELETE FROM Agents WHERE Id = 100
ID of the agent.
Indicates if agent is taking new tickets.
Group IDs associated with the agent.
True if this is an occasional agent.
Role IDs associated with the agent.
Signature of the agent in HTML format.
Skill ids associated with the agent.
Ticket permission of the agent (1 -> Global Access, 2 -> Group Access, 3 -> Restricted Access).
Whether or not the agent has been verified.
Email address of the agent.
Job title of the agent.
Language of the agent.
Last login date of the agent.
Mobile phone number of the agent.
Name of the agent.
Telephone number of the agent.
Time zone of the agent.
Created at datetime of the agent.
Updated at datetime of the agent.
Agent creation timestamp.
Agent updated timestamp.