Freshdesk
Freshdesk is a cloud-based customer support software that helps businesses provide exceptional customer service.
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | |
| Custom data | True | |
| History | False | |
| ReSync | True | Table level |
| Templates | True |
Data Schema
Loading diagram…
agent
agent
id
stringorg_agent_id
stringdeactivated
booleanavailable
booleanavailable_since
dateoccasional
booleanticket_scope
inttype
stringlast_active_at
datecreated_at
dateupdated_at
datesignature
stringcontact_active
booleancontact_email
stringcontact_job_title
stringcontact_language
stringcontact_last_login_at
datecontact_mobile
stringcontact_name
stringcontact_phone
stringcontact_time_zone
stringcontact_created_at
datecontact_updated_at
datescope
intfocus_mode
boolean_weld_synced
dateagent_role
role_id
stringagent_id
stringindex
int_weld_synced
dateagent_skill
agent_id
stringskill_id
stringindex
int_weld_synced
dateagent_contribution_group
agent_id
stringcontribution_group_id
stringindex
int_weld_synced
dateagent_org_contribution_group
agent_id
stringorg_contribution_group_id
stringindex
int_weld_synced
dateagent_org_group
agent_id
stringorg_group_id
stringindex
int_weld_synced
dateagent_group
group_id
stringagent_id
stringindex
int_weld_synced
dateagent_availability
agent_id
stringchannel
stringindex
intavailable
booleanavailable_since
date_weld_synced
dateautomation
automation
id
stringautomation_type_id
stringname
stringposition
intactive
booleanperformer_type
stringoperator
stringoutdated
booleanlast_updated_by
stringaffected_tickets_count
intsummary_performer
stringsummary_events
stringsummary_conditions_condition_set_1
stringsummary_conditions_condition_set_2
stringsummary_actions
stringcreated_at
dateupdated_at
date_weld_synced
dateautomation_performer_member
automation_id
stringmember_id
stringindex
int_weld_synced
dateautomation_condition
automation_id
stringname
stringmatch_type
string_weld_synced
dateautomation_condition_property
automation_id
stringautomation_condition_name
stringresource_type
stringfield_name
stringoperator
stringvalue
stringbusiness_hours_id
stringcase_senstive
booleannested_fields_level_field_name
stringnested_fields_level_value
stringassociated_fields_field_name
stringassociated_fields_operator
stringassociated_fields_value
intrelated_conditions
string_weld_synced
dateautomation_action
automation_id
stringfield_name
stringvalue
stringemail_to
doubleemail_body
stringapi_key
stringauth_header_username
stringauth_header_password
stringcustom_headers_value
stringcontent_content_layout
stringcontent_content_type
stringrequest_type
stringurl
stringnote_body
stringnotify_agents
stringnested_fields_level_value
stringnested_fields_level_field_name
stringfwd_to
stringfwd_cc
stringfwd_bcc
stringfwd_note_body
stringpush_to
stringslack_text
stringoffice_365_text
stringresource_type
string_weld_synced
dateautomation_event
automation_id
stringfield_name
stringfrom
stringto
stringvalue
stringfrom_nested_field_level_field_name
stringfrom_nested_field_level_value
stringto_nested_field_level_field_name
stringto_nested_field_level_value
string_weld_synced
dateautomation_type
id
stringname
string_weld_synced
datecompany
company
id
stringname
stringdescription
stringnote
stringcreated_at
dateupdated_at
datehealth_score
stringaccount_tier
stringrenewal_date
dateindustry
stringorg_company_id
string_weld_synced
datecompany_domain
company_id
stringdomain
stringindex
int_weld_synced
datediscussion_category
discussion_category
id
stringname
stringdescription
stringcreated_at
dateupdated_at
date_weld_synced
datediscussion_forum
id
stringname
stringdescription
stringposition
stringforum_category_id
stringforum_type
intforum_visibility
inttopics_count
intcomments_count
int_weld_synced
datediscussion_topic
id
stringtitle
stringforum_id
stringuser_id
stringlocked
booleanpublished
booleanstamp_type
intreplied_by
stringuser_votes
intmerged_topic_id
stringcomments_count
intsticky
booleancreated_at
dateupdated_at
datereplied_at
datehits
int_weld_synced
datediscussion_comment
id
stringtopic_id
stringcreated_at
dateupdated_at
dateuser_id
stringforum_id
stringanswer
booleanpublished
booleanspam
booleantrash
booleanbody
stringbody_text
string_weld_synced
dateportal
portal
id
stringproduct_id
stringname
stringportal_url
stringmain_portal
booleanssl_enabled
booleanpreferences_bg_color
stringpreferences_header_color
stringpreferences_tab_color
stringpreferences_personalized_articles
booleanpreferences_display_in_portal
booleancreated_at
dateupdated_at
datelanguage
stringtemplate_id
stringspam_score
intknowledge_base_preferences_knowledge_base_enabled
booleanknowledge_base_preferences_viewed_by_everyone
booleanknowledge_base_preferences_display_author
booleanknowledge_base_preferences_count_agent_interactions
booleanknowledge_base_preferences_enable_article_feedback_captcha
booleanproduct_name
stringenabled
booleanforum_preferences_forums_enabled
booleanforum_preferences_viewed_by_everyone
booleanforum_preferences_enable_forum_captcha
booleanforum_preferences_moderation_type
intticket_preferences_tickets_enabled
booleanticket_preferences_submitted_by_everyone
booleanticket_preferences_enable_ticket_captcha
booleanticket_preferences_auto_suggest_solutions
booleanticket_preferences_viewed_by_anyone
booleanticket_preferences_prevent_ticket_creation_for_others
booleanticket_preferences_view_portal_specific_tickets
booleanticket_preferences_advanced_ticket_filters
booleanticket_preferences_ticket_forms_page_title
stringticket_preferences_ticket_forms_forms_placeholder_text
stringsupported_languages
string_weld_synced
dateportal_solution_category
portal_id
stringsolution_category_id
stringindex
int_weld_synced
dateportal_forum_moderator
portal_id
stringmoderator_id
stringindex
int_weld_synced
dateportal_forum_category
portal_id
stringcategory_id
stringindex
int_weld_synced
dateportal_ticket_form
ticket_form_id
stringportal_id
stringindex
int_weld_synced
datesatisfaction_rating
satisfaction_rating
id
stringsurvey_id
stringagent_id
stringgroup_id
stringticket_id
stringuser_id
stringfeedback
stringcreated_at
dateupdated_at
date_weld_synced
datesatisfaction_rating_value
satisfaction_rating_id
stringsurvey_question_id
stringvalue
int_weld_synced
datesla_policy
sla_policy
id
stringname
stringdescription
stringactive
booleanis_default
booleanposition
intcreated_at
dateupdated_at
date_weld_synced
datesla_policy_target
sla_policy_id
stringpriority
stringrespond_within
intresolve_within
intbusiness_hours
booleanescalation_enabled
boolean_weld_synced
datesla_policy_applicable_to
sla_policy_id
stringtype
stringvalue
string_weld_synced
datesla_policy_escalation_resolution
sla_policy_id
stringagent_id
stringlevel
stringescalation_time
int_weld_synced
datesla_policy_escalation_response
sla_policy_id
stringagent_id
stringescalation_time
int_weld_synced
datesla_policy_escalation_next_response
sla_policy_id
stringagent_id
stringescalation_time
int_weld_synced
datesla_policy_escalation_reminder_response
sla_policy_id
stringagent_id
stringescalation_time
int_weld_synced
datesla_policy_escalation_reminder_resolution
sla_policy_id
stringagent_id
stringescalation_time
int_weld_synced
datesla_policy_escalation_reminder_next_response
sla_policy_id
stringagent_id
stringescalation_time
int_weld_synced
datesurvey
survey
id
stringtitle
stringactive
booleancreated_at
dateupdated_at
date_weld_synced
datesurvey_question
id
stringsurvey_id
stringlabel
stringaccepted_ratings
stringdefault
boolean_weld_synced
dateticket
ticket
id
stringemail_config_id
stringgroup_id
stringcompany_id
stringproduct_id
stringfr_escalated
booleanspam
booleanpriority
intrequester_id
stringresponder_id
stringsource
intstatus
intsubject
stringassociation_type
stringsupport_email
stringtype
stringdue_by
datefr_due_by
dateis_escalated
booleancreated_at
dateupdated_at
dateassociated_tickets_count
doublesentiment_score
doublenr_due_by
datenr_escalated
booleancf_brand
stringcf_site
string_weld_synced
dateticket_to_email
ticket_id
stringemail
stringindex
int_weld_synced
dateticket_cc_email
ticket_id
stringemail
stringindex
int_weld_synced
dateticket_fwd_email
ticket_id
stringemail
stringindex
int_weld_synced
dateticket_reply_cc_email
ticket_id
stringemail
stringindex
int_weld_synced
dateticket_ticket_cc_email
ticket_id
stringemail
stringindex
int_weld_synced
dateticket_tag
ticket_id
stringtag
stringindex
int_weld_synced
dateticket_conversation
ticket_conversation
id
stringautomation_id
stringautomation_type_id
stringticket_id
stringbody
stringbody_text
stringincoming
booleanprivate
booleanuser_id
stringsupport_email
stringsource
intcategory
intfrom_email
stringemail_failure_count
intoutgoing_failures
stringthread_id
stringthread_message_id
stringcreated_at
dateupdated_at
datelast_edited_at
datelast_edited_user_id
stringauto_response
booleansource_additional_info
string_weld_synced
dateticket_conversation_to_email
ticket_conversation_id
stringemail
stringindex
int_weld_synced
dateticket_conversation_cc_email
ticket_conversation_id
stringemail
stringindex
int_weld_synced
dateticket_conversation_bcc_email
ticket_conversation_id
stringemail
stringindex
int_weld_synced
dateticket_conversation_attachment
id
stringticket_conversation_id
stringname
stringcontent_type
stringsize
intcreated_at
dateupdated_at
dateattachment_url
string_weld_synced
dateaccount
account_id
stringorganisation_id
stringorganisation_name
stringaccount_name
stringaccount_domain
stringbundle_id
stringhipaa_compliant
booleantotal_agents_full_time
inttotal_agents_occasional
inttotal_agents_field_service
inttotal_agents_collaborators
inttimezone
stringdata_center
stringtier_type
stringaddress_country
stringaddress_state
stringaddress_city
stringaddress_street
stringaddress_postalcode
stringcontact_person_firstname
stringcontact_person_lastname
stringcontact_person_email
string_weld_synced
datebusiness_hour
id
stringname
stringis_default
booleandescription
stringbusiness_hours_monday_start_time
stringbusiness_hours_monday_end_time
stringbusiness_hours_tuesday_start_time
stringbusiness_hours_tuesday_end_time
stringbusiness_hours_wednesday_start_time
stringbusiness_hours_wednesday_end_time
stringbusiness_hours_thursday_start_time
stringbusiness_hours_thursday_end_time
stringbusiness_hours_friday_start_time
stringbusiness_hours_friday_end_time
stringtime_zone
stringcreated_at
dateupdated_at
date_weld_synced
datecontact
id
stringcompany_id
stringactive
booleanaddress
stringdescription
stringemail
stringjob_title
stringlanguage
stringmobile
stringname
stringphone
stringtime_zone
stringtwitter_id
stringfacebook_id
stringcreated_at
dateupdated_at
datecsat_rating
stringpreferred_source
stringunique_external_id
stringfirst_name
stringlast_name
stringvisitor_id
stringorg_contact_id
stringother_phone_numbers
string_weld_synced
dateemail_config
id
stringproduct_id
stringgroup_id
stringname
stringto_email
stringreply_email
stringprimary_role
booleanactive
booleancreated_at
dateupdated_at
date_weld_synced
dategroup
id
stringbusiness_hour_id
stringname
stringdescription
stringescalate_to
stringunassigned_for
stringgroup_type
stringcreated_at
dateupdated_at
dateauto_ticket_assign
intagent_availability_status
boolean_weld_synced
dateproduct
id
stringname
stringdescription
stringprimary_email
stringcreated_at
dateupdated_at
datedefault
boolean_weld_synced
daterole
id
stringname
stringdescription
stringdefault
booleancreated_at
dateupdated_at
dateagent_type
int_weld_synced
dateticket_form
id
stringname
stringtitle
stringdefault
booleandescription
stringcreated_at
dateupdated_at
datelast_updated_by
string_weld_synced
dateTable
Sub table
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
Open full-page schema explorer
Setup Guide
Prerequisites
To connect your Freshdesk account to Weld, you need:
- Access to a Freshdesk account.
Step 1 - Begin Configuration
- Choose a name for your connection.
- Fill in your Freshdesk domain.
For example, if your Freshdesk URL is https://example.freshdesk.com, you should enter example.freshdesk.com as the domain. - Fill in your Freshdesk API key.
To find your API key, log in to your Freshdesk account and navigate to Profile settings and click View API key. Copy the API key and paste it into the Weld configuration form.
Step 2 - Click connect
- After you click on Connect Weld will make sure that your credentials are correct and that we can connect to your Freshdesk account.
Step 3 - Data To Sync
- Select the data you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 4 - Configure Sync
- Select how often you would like the data to sync.
- Provide a unique destination table name.
Weld will take over from here and commence syncing data from your Freshdesk account.