Tables
The driver models the data in Freshdesk as a list of tables in a relational database that can be queried using standard SQL statements.
CData JDBC Driver for Freshdesk Tables
| Name | Description |
| Agents | Update, delete, and query from agents table |
| BusinessHours | Query from BusinessHours table |
| CannedResponses | Create, update and query from CannedResponses table |
| CannedResponsesFolder | Query from CannedResponsesFolder table |
| Companies | Create, update, delete, and query from companies table |
| Contacts | Create, update, delete, and query from contacts table |
| Conversations | Delete, and query from conversations table |
| Groups | Create, update, delete, and query from groups table |
| Mailboxes | Create, update, delete, and query from Mailboxes table |
| Products | Query from products table |
| Roles | Query from roles table |
| Skills | Create, update, delete, and query from skills table |
| SLAPolicies | Query, Create and Update SLAPolicies table |
| Surveys | Query from surveys table |
| TicketCreationAutomationRules | Create, update, delete, and query from TicketCreationAutomationRules table |
| TicketFields | Query from ticketFields table |
| Tickets | Create, update, delete, and query from tickets table |
| TicketUpdatesAutomationRules | Create, update, delete, and query from TicketUpdatesAutomationRules table |
| TimeEntries | Create, update, delete, and query from TimeEntries table |
| TimeTriggersAutomationRules | Create, update, delete, and query from TimeTriggersAutomationRules table |