Tables
The adapter models the data in FreshDesk into a list of tables that can be queried using standard SQL statements.
Generally, querying FreshDesk tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
FreshDesk Adapter 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 |
TicketFields | Query from ticketFields table |
Tickets | Create, update, delete, and query from tickets table |
TimeEntries | Create, update, delete, and query from TimeEntries table |