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 | Table level and schema level. |
| Column Hashing | ||
| 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 ERD in 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.