Freshdesk

Adicionando o conector

Adicionando o conector do Freshdesk na Kondado, você pode ter acesso aos dados dos seus tickets no seu Data Warehouse ou Data Lake – processo também conhecido como ETL ou ELT

Para adicionar o conector do Freshdesk, siga os passos abaixo:

1) Faça login na sua conta do Freshdesk

Atenção: O usuário do Freshdesk utilizado deve ter permissões de Administrador

2) Clique na sua imagem de perfil no canto superior direito e depois em “Profile Settings”

3) Na barra lateral à direita, você encontrará sua chave de API

4) Faça login na Kondado, vá para a seção de adicionar conectores e selecione o conector do Freshdesk

5) Na página de preenchimento dos dados do conector, faça o seguinte:

  • Em Domínio, cole a primeira parte da sua URL de acesso ao Freshdesk. Por exemplo, se a sua URL de acesso é https://empresa.freshdesk.com, utilize o valor empresa
  • Em API key, cole o valor obtido no passo (3)

6) Agora basta dar um nome para o seu conector e clicar em SALVAR

Integrações

Índice

Gráfico de relacionamento

Clique para ampliar

Tickets

Objeto principal

Campo Tipo

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

Campo Tipo

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

Campo Tipo

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

Campo Tipo

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

Campo Tipo

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

Campo Tipo

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