Freshdesk

Freshdesk is a cloud customer support ticketing system.

Data integration: Skyvia supports importing data to and from Freshdesk, exporting Freshdesk data to CSV files, replicating Freshdesk data to relational databases, and synchronizing Freshdesk data with other cloud apps and relational databases.

Backup: Skyvia Backup supports Freshdesk backup.

Query: Skyvia Query supports Freshdesk.

Establishing Connection

To create connection to Freshdesk, you need to specify the API version to use, the URL to connect to, and the API key.

Getting Credentials

To find your API Key, perform the following actions:

  1. Sign in to your Freshdesk Support Portal
  2. Click your profile picture in the top right corner of your portal page.
  3. Go to the Profile settings page.

    getting API Key

  4. Click View API Key on the right.

    Connection Editor window

  5. Copy the API Key.

Creating Connection

Connection Editor window

To connect to Freshdesk, perform the following steps:

  1. Select the API Version to use (v1 or v2). API v2 version provides access to more Freshdesk objects than API v1, and the structure of common objects may be different for different API versions.
  2. Specify the URL — address of your Freshdesk subdomain.
  3. Enter the obtained API Key.

Connector Specifics

Object Peculiarities

Custom Fields

Skyvia does not support custom Freshdesk fields having double quotation marks in their names.

Ticket

When querying Freshdesk tickets via API v2, the amount of required Freshdesk API calls doubles if you query the ticket Description field. It’s better not to query it if you don’t need it.

Attachments

Information about ticket attachments is stored in the TicketAttachment object.

Each record in this table corresponds to the single attachment existing in the Ticket object and contains the attachment body binary data. The TicketAttachment object supports the INSERT and DELETE DML operations.

To successfully insert data to the TicketAttachment table, you must map the TicketId, FileName, and Body fields. You can pass the Body values in base64 format.

Supported Actions

Skyvia supports all the common actions for Freshdesk.