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 | |
---|---|---|
text |
[pt] ID único do ticket |
|
timestamp |
[pt] Timestamp de atualização do ticket |
|
text |
[pt] Assunto do ticket |
|
timestamp |
||
timestamp |
||
timestamp |
||
timestamp |
||
timestamp |
||
timestamp |
||
timestamp |
||
timestamp |
||
boolean |
[pt] TRUE se o ticket foi marcado como spam |
|
timestamp |
[pt] Timestamp que indica quando o ticket deve ser resolvido |
|
text |
[pt] ID do agente para quem o ticket foi atribuído |
|
text |
[pt] Prioridade do ticket |
|
text |
[pt] O canal por onde o ticket foi criado |
|
text |
[pt] Ajuda a categorizar o ticket de acordo com diferentes níveis de tarefas que o seu time lida |
|
text |
||
text |
[pt] Status do ticket |
|
boolean |
[pt] Verdadeiro caso o ticket seja escalado por qualquer motivo |
|
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) |
|
text |
[en] ID of the company to which this ticket belongs [pt] ID da empresa à qual este ticket pertence |
|
text |
[en] Name of the company to which this ticket belongs [pt] Nome da empresa à qual este ticket pertence |
|
text |
[en] Mobile phone of the requester [pt] Celular do solicitante |
|
text |
[en] Email of the requester [pt] Email do solicitante |
|
text |
[en] User ID of the requester [pt] ID de usuário do solicitante |
|
text |
[en] Phone of the requester [pt] Telefone do solicitante |
|
text |
[en] Name of the requester [pt] Nome do solicitante |
|
text |
[en] ID of the product to which the ticket is associated [pt] ID do produto ao qual o ticket está associado |
|
timestamp |
[en] Timestamp that denotes when the first response is due [pt] Timestamp que denota quando a primeira resposta'deve ser dada |
|
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 |
|
timestamp |
[en] Ticket creation timestamp [pt] Timestamp de criação do Ticket |
|
text |
[en] ID of the group to which the ticket has been assigned [pt] ID do grupo para qual o ticket foi atribuído |
|
text |
[en] HTML content of the ticket [pt] Conteúdo HTML do ticket |
|
text |
[en] Content of the ticket in plain text [pt] Conteúdo do ticket em texto puro |
freshdesk_tickets__tags
Field | Type | |
---|---|---|
text |
[en] Unique ID of the ticket [pt] ID único do ticket |
|
text |
[en] Tag associated with the ticket [pt] Tag associada ao ticket |
freshdesk_tickets__emails
Field | Type | |
---|---|---|
text |
[en] Unique ID of the ticket [pt] ID único do ticket |
|
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 |
|
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 | |
---|---|---|
text |
[en] User ID of the agent |
|
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 |
|
timestamp |
[en] Agent updated timestamp |
|
timestamp |
[en] Timestamp that denotes when the agent became available/unavailable (depending on the value of the 'available' attribute) |
|
timestamp |
||
text |
[en] Ticket permission of the agent (1 -> Global Access, 2 -> Group Access, 3 -> Restricted Access) |
|
timestamp |
[en] Agent creation timestamp |
|
boolean |
[en] Set to true if this is an occasional agent (true => occasional, false => full-time) |
|
timestamp |
[en] Timestamp of the last update |
|
text |
[en] Telephone number of the agent |
|
timestamp |
[en] Timestamp of the agent's last successful login |
|
boolean |
[en] Set to true if the agent is verified |
|
text |
[en] Name of the agent |
|
text |
[en] Language of the agent. Default language is en |
|
text |
[en] Mobile number of the agent |
|
timestamp |
[en] Creation timestamp |
|
text |
[en] Time zone of the agent |
|
text |
[en] Email address of the agent |
|
text |
[en] Job title of the agent |
|
text |
[en] Signature of the agent in HTML format |
|
text |
Contacts
Field | Type | |
---|---|---|
text |
[en] ID of the contact |
|
text |
||
text |
||
text |
[en] A short description of the contact |
|
text |
[en] Language of the contact |
|
text |
[en] Twitter handle of the contact |
|
text |
[en] Mobile number of the contact |
|
text |
[en] Name of the contact |
|
timestamp |
[en] Contact creation timestamp |
|
text |
||
text |
[en] ID of the primary company to which this contact belongs |
|
text |
[en] External ID of the contact |
|
text |
[en] Primary email address of the contact. If you want to associate additional email(s) with this contact, use the other_emails attribute |
|
timestamp |
[en] Contact updated timestamp |
|
text |
[en] Telephone number of the contact |
|
text |
[en] Time zone in which the contact resides |
|
boolean |
||
text |
[en] Address of the contact |
|
boolean |
[en] Set to true if the contact has been verified |
|
text |
||
text |
[en] Job title of the contact |