Connectors

/

Freshdesk

Data replication

Sync Freshdesk data anywhere.

Freshdesk is a service provided by Freshworks for handling the entire spectrum of customer engagement. A customer support software based in the Cloud, Freshdesk provides a scalable solution for managing customer support simply and efficiently. Freshdesk enables teams to track incoming tickets from a variety of channels; provide support across multiple platforms including phone, chat, and other messaging apps; categorize, prioritize, and assign tickets; prepare preformatted answer to common customer support questions; and much more.

  • Certified
  • Generally available
  • 29 streams
  • 10 entities
Sync Freshdesk dataRead the docs
Freshdesk

One connector

Everything Freshdesk can do in Airbyte

  • Sync to your warehouse

    Land 29 Freshdesk tables in 50+ destinations on a schedule you control.

  • Context store search

    Query synced Freshdesk data with filters, sorting and semantic search, without spending Freshdesk API rate limits.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • One authorization

    Authenticate Freshdesk once. The same connection powers scheduled syncs and runtime actions.

Specifications

What to know before you sync Freshdesk

  • Support levelCertified
  • Available onCloud, Self-Managed Enterprise
  • Connector version3.2.26
  • Release stageGenerally available

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Destinations50+ Airbyte connectors

Set up in 10 steps

  1. Open the Airbyte dashboard and click on "Sources" on the left-hand side of the screen.
  2. Click on the "Add Source" button and select "Freshdesk" from the list of available connectors.
  3. Enter a name for the connector and click on "Next".
  4. Enter your Freshdesk credentials, including your Freshdesk domain, API key, and password.
  5. Click on "Test Connection" to ensure that the credentials are correct and the connection is successful.
  6. Once the connection is successful, select the data you want to replicate from Freshdesk, including tickets, contacts, and companies.
  7. Choose the replication frequency and the destination where you want to store the data.
  8. Click on "Create Source" to save the configuration and start the replication process.
  9. Monitor the replication process on the Airbyte dashboard and troubleshoot any errors that may occur.
  10. Once the replication is complete, you can use the data in your destination of choice for analysis and reporting.

29 streams

Every table you can sync from Freshdesk

  • Agents

  • Business Hours

  • Canned Responses

  • Canned Response Folders

  • Companies

  • Contacts

  • Conversations

  • Discussion Categories

  • Discussion Comments

  • Discussion Forums

  • Discussion Topics

  • Email Configs

  • Email Mailboxes

  • Groups

  • Products

  • Roles

  • Satisfaction Ratings

  • Scenario Automations

  • Settings

  • Skills

  • SLA Policies

  • Solution Articles

  • Solution Categories

  • Solution Folders

  • Surveys

  • Tickets

  • Ticket Activities

  • Ticket Fields

  • Time Entries

4 actions

Supported Freshdesk actions

  • List

    Read live records straight from the Freshdesk API.

  • Get

    Fetch a single record by ID.

  • Context Store Search

    Query synced data with filters and sorting, with no API rate limits.

  • Semantic Search

    Natural-language search across synced Freshdesk records.

Full parameter-level details live in the Freshdesk entity reference.

Authentication

Authenticate Freshdesk once

  • API Key

    Freshdesk API Key. See the docs for more information on how to obtain this key.

Use cases

What teams build with Freshdesk

List all open tickets in Freshdesk

Show me all agents in the support team

List all groups configured in Freshdesk

Get the details of ticket #26

Show me all companies in Freshdesk

List all roles defined in the helpdesk

Show me the ticket fields and their options

List time entries for tickets

What are the high priority tickets from last week?

Which tickets have breached their SLA due date?

Show me tickets assigned to agent agent_name

Find all tickets from company company_name

How many tickets were created this month by status?

What are the satisfaction ratings for resolved tickets?

Explore

Related connectors

FreshsalesSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
FrontSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
GenesysSales & Support AnalyticsStandard Sources self-managed-enterprise
GongSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
Help ScoutSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
InsightlySales & Support AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

No. One Freshdesk authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.

No. Entity actions read and write through the Freshdesk API as they are called, so they work immediately. Context store search is the exception: it queries data Airbyte has already synced, which is what lets it filter and sort without spending API rate limits.

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

Freshdesk's API provides access to a wide range of data related to customer support and service management. The following are the categories of data that can be accessed through Freshdesk's API:

1. Tickets: Information related to customer support tickets, including ticket ID, status, priority, and requester details.

2. Contacts: Data related to customer contacts, including contact ID, name, email address, and phone number.

3. Agents: Information about support agents, including agent ID, name, email address, and role.

4. Companies: Data related to companies that use Freshdesk for customer support, including company ID, name, and domain.

5. Conversations: Information related to customer conversations, including conversation ID, status, and participants.

6. Knowledge base: Data related to the knowledge base, including articles, categories, and folders.

7. Surveys: Information related to customer satisfaction surveys, including survey ID, status, and responses.

8. Time entries: Data related to time entries for support agents, including time spent on tickets and activities.

9. Custom fields: Information related to custom fields created in Freshdesk, including field ID, name, and value.

Overall, Freshdesk's API provides access to a comprehensive set of data that can be used to improve customer support and service management.

1. Open the Airbyte dashboard and click on "Sources" on the left-hand side of the screen.

2. Click on the "Add Source" button and select "Freshdesk" from the list of available connectors.

3. Enter a name for the connector and click on "Next".

4. Enter your Freshdesk credentials, including your Freshdesk domain, API key, and password.

5. Click on "Test Connection" to ensure that the credentials are correct and the connection is successful.

6. Once the connection is successful, select the data you want to replicate from Freshdesk, including tickets, contacts, and companies.

7. Choose the replication frequency and the destination where you want to store the data.

8. Click on "Create Source" to save the configuration and start the replication process.

9. Monitor the replication process on the Airbyte dashboard and troubleshoot any errors that may occur.

10. Once the replication is complete, you can use the data in your destination of choice for analysis and reporting.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving Freshdesk data today

Free for 14 days on Airbyte Cloud. One connection powers your scheduled syncs and your live Freshdesk actions.

Try it freeTalk to sales