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.
|Capture deletes||check|| All tables and fields.|
|Custom data||check|| |
|Data blocking||check||Column level|
|API configurable||check||API configuration|
|Fivetran data models|
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.
Follow our step-by-step Freshdesk setup guide to connect Freshdesk with your destination using Fivetran connectors.
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.
We update the following tables according to the update frequency you specify in the Freshdesk dashboard:
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:
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.