Freshdesk link
Updated November 1, 2023
Freshdesk is a SaaS customer support software and help desk ticketing system. The solution also includes features like Knowledge Base, Community Platform, Live Chat, Phone Support, etc.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | All tables and fields.* |
| Custom data | check | TICKET, TICKET_HISTORY, CONTACT and COMPANY tables only. |
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | ||
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
* The TICKET table has a deleted field. For all other tables we get all the data once a day and mark the diff as soft deleted in the destination.
Setup guidelink
Follow our step-by-step Freshdesk setup guide to connect Freshdesk with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Freshdesk connections created on or after January 10, 2023.
To zoom, open the ERD in a new window.This schema applies to all Freshdesk connections created before January 10, 2023.
To zoom, open ERD in new window
Update frequencylink
We update the following tables according to the update frequency you specify in the Freshdesk dashboard:
CONTACTCONVERSATIONCONVERSATION_ATTACHMENTCONVERSATION_BCC_EMAILCONVERSATION_CC_EMAILCONVERSATION_TO_EMAILSATISFACTION_RATINGSATISFACTION_RATING_VALUETICKET_CC_EMAILTICKET_FWD_EMAILTICKET_REPLY_CC_EMAILTICKET_TO_EMAIL
We sync the TIME_ENTRIES (add and update) and TICKET_HISTORY (add, update, and delete) tables incrementally using webhooks.
To capture deletes for the TIME_ENTRIES table, we re-import the entire table once a week.
NOTE: You should not delete the Automation rule created on your Freshdesk dashboard.
We update the following tables once a day as Freshdesk API does not offer incremental updates for them:
AGENTAGENT_ROLEAGENT_GROUPBUSINESS_HOURCOMPANYCOMPANY_DOMAINDISCUSSIONDISCUSSION_CATEGORYDISCUSSION_COMMENTDISCUSSION_FORUMEMAIL_CONFIGGROUPPRODUCTROLESURVEYSURVEY_QUESTION
API quota usagelink
We throttle our connector to limit API usage. We have configured the throttling limit at 95% of the total API requests quota. Once the throttle is triggered, we reschedule our connector.