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 , 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.
To zoom, open the ERD in a new window.
Update Frequencylink
The following tables are updated according to the update frequency specified in the Fivetran Freshdesk integration dashboard:
- conversation
- conversation_attachment
- conversation_bcc_email
- conversation_cc_email
- conversation_to_email
- satisfaction_rating
- satisfaction_rating_value
- ticket
- ticket_cc_email
- ticket_fwd_email
- ticket_reply_cc_email
- ticket_to_email
And the tables mentioned below are updated once a day as Freshdesk API does not offer incremental updates for them:
- agent
- agent_role
- agent_group
- business_hour
- company
- company_domain
- contact
- discussion
- discussion_category
- discussion_comment
- discussion_forum
- discussion_forum
- email_config
- group
- product
- role
- survey
- survey_question
- time_entries
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.