Freshdesk

Adding the data source

By adding the Freshdesk data sourceto Kondado, you can have access to your ticket data in your Data Warehouse or Data Lake – process also known as ETL or ELT

To add the Freshdesk data source, follow the steps below:

1) Log in to your Freshdesk account

Attention: The Freshdesk user used must have Administrator permissions

2) Click on your profile picture in the upper right corner and then on “Profile Settings”

3) In the sidebar on the right you will find your API key

4) Login to Kondado, go to add data sources and select the Freshdesk data source

5) On the data source page, do the following:

  • In Domain, paste the first part of your Freshdesk login URL. For example, if your access URL is https://company.freshdesk.com, use the value company
  • In API key, paste the value obtained in step (3)

6) Now just name your data source and click SAVE

Pipelines

Summary

Relationship Chart

Tickets

Main Object

Field Type

id

text

[pt] ID único do ticket

updated_at

timestamp

[pt] Timestamp de atualização do ticket

subject

text

[pt] Assunto do ticket

stats__reopened_at

timestamp

stats__resolved_at

timestamp

stats__first_responded_at

timestamp

stats__closed_at

timestamp

stats__status_updated_at

timestamp

stats__agent_responded_at

timestamp

stats__pending_since

timestamp

stats__requester_responded_at

timestamp

spam

boolean

[pt] TRUE se o ticket foi marcado como spam

due_by

timestamp

[pt] Timestamp que indica quando o ticket deve ser resolvido

responder_id

text

[pt] ID do agente para quem o ticket foi atribuído

    Agents > > id

priority

text

[pt] Prioridade do ticket

source

text

[pt] O canal por onde o ticket foi criado

type

text

[pt] Ajuda a categorizar o ticket de acordo com diferentes níveis de tarefas que o seu time lida

support_email

text

status

text

[pt] Status do ticket

is_escalated

boolean

[pt] Verdadeiro caso o ticket seja escalado por qualquer motivo

email_config_id

text

[en] ID of email config which is used for this ticket. (i.e., support@yourcompany.com/sales@yourcompany.com)

[pt] ID da configuração de email que foi utilizada neste ticket (por exemplo: support@yourcompany.com/sales@yourcompany.com)

company__id

text

[en] ID of the company to which this ticket belongs

[pt] ID da empresa à qual este ticket pertence

company__name

text

[en] Name of the company to which this ticket belongs

[pt] Nome da empresa à qual este ticket pertence

requester__mobile

text

[en] Mobile phone of the requester

[pt] Celular do solicitante

requester__email

text

[en] Email of the requester

[pt] Email do solicitante

requester__id

text

[en] User ID of the requester

[pt] ID de usuário do solicitante

    Contacts > > id

requester__phone

text

[en] Phone of the requester

[pt] Telefone do solicitante

requester__name

text

[en] Name of the requester

[pt] Nome do solicitante

product_id

text

[en] ID of the product to which the ticket is associated

[pt] ID do produto ao qual o ticket está associado

fr_due_by

timestamp

[en] Timestamp that denotes when the first response is due

[pt] Timestamp que denota quando a primeira resposta'deve ser dada

fr_escalated

boolean

[en] Set to true if the ticket has been escalated as the result of first response time being breached

[pt] Verdadeiro se o ticket foi escalado como resultado de violação do tempo de primeira resposta

created_at

timestamp

[en] Ticket creation timestamp

[pt] Timestamp de criação do Ticket

group_id

text

[en] ID of the group to which the ticket has been assigned

[pt] ID do grupo para qual o ticket foi atribuído

description

text

[en] HTML content of the ticket

[pt] Conteúdo HTML do ticket

description_text

text

[en] Content of the ticket in plain text

[pt] Conteúdo do ticket em texto puro

freshdesk_tickets__tags

Field Type

ticket_id

text

[en] Unique ID of the ticket

[pt] ID único do ticket

tag

text

[en] Tag associated with the ticket

[pt] Tag associada ao ticket

freshdesk_tickets__emails

Field Type

ticket_id

text

[en] Unique ID of the ticket

[pt] ID único do ticket

email_type

text

[en] Type of email address associated with the ticket. Eg: cc, reply_cc, to

[pt] Tipo de endereço de email associado com o ticket. Por exemplo: cc, reply_cc, to

email_address

text

[en] Email address of a given type for a given ticket_id

[pt] Endereço de email de dado type para um dado ticket_id

Agents

Field Type

id

text

[en] User ID of the agent

available

boolean

[en] If the agent is in a group that has enabled Automatic Ticket Assignment, this attribute will be set to true if the agent is accepting new tickets

updated_at

timestamp

[en] Agent updated timestamp

available_since

timestamp

[en] Timestamp that denotes when the agent became available/unavailable (depending on the value of the 'available' attribute)

last_active_at

timestamp

ticket_scope

text

[en] Ticket permission of the agent (1 -> Global Access, 2 -> Group Access, 3 -> Restricted Access)

created_at

timestamp

[en] Agent creation timestamp

occasional

boolean

[en] Set to true if this is an occasional agent (true => occasional, false => full-time)

contact__updated_at

timestamp

[en] Timestamp of the last update

contact__phone

text

[en] Telephone number of the agent

contact__last_login_at

timestamp

[en] Timestamp of the agent's last successful login

contact__active

boolean

[en] Set to true if the agent is verified

contact__name

text

[en] Name of the agent

contact__language

text

[en] Language of the agent. Default language is en

contact__mobile

text

[en] Mobile number of the agent

contact__created_at

timestamp

[en] Creation timestamp

contact__time_zone

text

[en] Time zone of the agent

contact__email

text

[en] Email address of the agent

contact__job_title

text

[en] Job title of the agent

signature

text

[en] Signature of the agent in HTML format

type

text

Contacts

Field Type

id

text

[en] ID of the contact

preferred_source

text

twitter_followers_count

text

description

text

[en] A short description of the contact

language

text

[en] Language of the contact

twitter_id

text

[en] Twitter handle of the contact

mobile

text

[en] Mobile number of the contact

name

text

[en] Name of the contact

created_at

timestamp

[en] Contact creation timestamp

facebook_id

text

company_id

text

[en] ID of the primary company to which this contact belongs

unique_external_id

text

[en] External ID of the contact

email

text

[en] Primary email address of the contact. If you want to associate additional email(s) with this contact, use the other_emails attribute

updated_at

timestamp

[en] Contact updated timestamp

phone

text

[en] Telephone number of the contact

time_zone

text

[en] Time zone in which the contact resides

twitter_profile_status

boolean

address

text

[en] Address of the contact

active

boolean

[en] Set to true if the contact has been verified

csat_rating

text

job_title

text

[en] Job title of the contact

Tickets: Custom Fields

Field Type

id

text

[pt] ID único do ticket

    Tickets > > id

updated_at

timestamp

[pt] Timestamp de atualização do ticket

cf_custom_field_x

text

[pt] Exemplo de custom field x

cf_custom_field_y

text

[pt] Exemplo de custom field x

cf_custom_field_z

text

[pt] Exemplo de custom field x