01. Plataforma

02. Destinos

03. Conectores

55PBX

ActiveCampaign

Api4com

Apple App Store

ASAAS

AWS CloudWatch Metrics

Azure Table Storage

BigQuery (conector)

Bitrix24 CRM

Bling!

Blip (Take)

Brasil.io

ClickUp

Clockify

ContaAzul

Criteo

E-goi

EADBOX

Exact Sales

Facebook

Fatura Simples

Freshdesk

FTP

Google Ads (Adwords)

Google Analytics 4 (GA4)

Google Cloud Storage

Google Play Store

Google Search Console (Google Webmasters)

Google Sheets

Granatum

Hi Platform

Hotmart

HubSpot

Huggy

InfluxDB v1.x

Infusionsoft (Keap)

Instagram

Jira

Kondado

Linkedin

Loja Integrada

MailChimp

Mandrill

Meetime

Mercado Livre

Microsoft Advertising

Microsoft SQL Server (conector)

Microsoft SQL Server SSH (conector)

Mixpanel

Monday.com

MongoDB

Movidesk

MySQL (conector)

MySQL SSH (conector)

NectarCRM

Notion

Nuvemshop

Omie

Oracle (conector)

Pagar.me

Pinterest Ads

Pipedrive

Pipefy

PipeRun

Ploomes

PostgreSQL (conector)

Pushwoosh

RD Station

RDStation CRM

Recruiterbox

S3 (conector)

Salesforce

Salesforce Marketing Cloud

SenseData

Shopify

Stilingue

Superlógica

Sympla

Taboola

Tangerino

TikTok Ads

TikTok Orgânico

Tiny ERP

Toggl

Tray

Trello

Twilio

VNDA

VTEX

Wake Commerce (antigo Tray Corp by FBits)

Webhook

Wootric

X Ads

YouTube

Zeeng

Zendesk

Zendesk Chat

Índice de Conectores Kondado

04. API

05. Visualização

06. Central de Ajuda

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