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 | |
| Priority-first sync | ||
| dbt Package |
* 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.