Adicionando o conector
1) Faça login na sua conta do Hi Platform como Gerente
Atenção:
1) É importante que o usuário que está fazendo login tenha o perfil de Gerente
2) Esta integração é relativa ao Hi Social
2) Após o login, com o mesmo navegador, acesse a seguinte URL: https://plataforma2.seekr.com.br/api_doc/v3
3) Na página de API, na parte superior, clique em “API Key e API Secret”
4) Agora basta copiar os valores de “API Key” e “API Secret” que irão aparecer – sem as aspas
5) Faça login na Kondado, vá para a seção de adicionar conectores e selecione o conector do Hi Platform
6) No conector, em “Nome” dê um nome para o seu conector e em “URL de acesso ao app da HiPlatform” coloque a URL que você utiliza para fazer login no HiPlatform (por exemplo https://plataforma1.seekr.com.br ou https://plataforma2.seekr.com.br, etc ) , em “API Key” e “API Secret” cole os valores obtidos no passo (4)
Agora basta clicar em SALVAR e para começar a receber dados do Hi Platform no Data Warehouse ou Data Lake
Integrações
Gráfico de relacionamento entre tabelas
Chamados
Objeto principal
| Campo | Tipo | |
|---|---|---|
id |
text |
|
account_id |
float |
|
attendant__email |
text |
|
attendant__id |
float |
|
attendant__name |
text |
|
content |
text |
|
created_at |
timestamp |
|
crm_user__custom_identifier |
text |
|
crm_user__email |
text |
|
crm_user__following |
text |
|
crm_user__gender |
text |
|
crm_user__id |
text |
|
crm_user__image |
text |
|
crm_user__name |
text |
|
crm_user__unknown |
boolean |
|
crm_user__username |
text |
|
first_search_result_created_at |
timestamp |
|
first_search_result_published_at |
timestamp |
|
first_search_result_published_at_hour |
float |
|
first_search_result_search_term_id |
text |
|
first_search_result_type_on_media |
text |
|
forked |
boolean |
|
has_note |
boolean |
|
hibot_id |
text |
|
hidden |
text |
|
interactions |
float |
|
last_seen_at |
timestamp |
|
locale__city |
text |
|
locale__city_id |
text |
|
locale__country |
text |
|
locale__country_id |
text |
|
locale__country_short |
text |
|
locale__latitude |
text |
|
locale__longitude |
text |
|
locale__state |
text |
|
locale__state_id |
text |
|
locale__state_short |
text |
|
most_recent_search_result_created_at |
timestamp |
|
most_recent_search_result_crm_user_id |
float |
|
most_recent_search_result_hide_on_ticket |
text |
|
most_recent_search_result_member_of |
text |
|
most_recent_search_result_published_at |
timestamp |
|
most_recent_search_result_published_at_hour |
float |
|
new_interaction |
boolean |
|
opened_at |
timestamp |
|
op_times_int_with_sla_anwsered_time |
text |
|
op_times_int_with_sla_opened_time |
text |
|
op_times_int_with_sla_resolved_time |
text |
|
op_times_int_wo_sla_anwsered_time |
text |
|
op_times_int_wo_sla_opened_time |
text |
|
op_times_int_wo_sla_resolved_time |
text |
|
op_times_part_with_sla_anwsered_time |
text |
|
op_times_part_with_sla_opened_time |
text |
|
op_times_part_with_sla_resolved_time |
text |
|
op_times_part_wo_sla_anwsered_time |
text |
|
op_times_part_wo_sla_opened_time |
text |
|
op_times_part_wo_sla_resolved_time |
text |
|
parent_publication_published_at |
timestamp |
|
polarization |
float |
|
priority |
float |
|
protocol |
text |
|
read |
boolean |
|
resolved_at |
timestamp |
|
responded_at |
timestamp |
|
search_setting_id |
float |
|
social_media__crm_key |
text |
|
social_media__description |
text |
|
social_media__id |
float |
|
social_media__title |
text |
|
social_media__type |
text |
|
status |
text |
|
unhidden_on |
text |
|
updated_at |
timestamp |
|
workflow_user |
text |
interactions_texts
| Campo | Tipo | |
|---|---|---|
ticket_id |
text |
|
interaction_order |
int |
|
interaction_text |
text |
tags
| Campo | Tipo | |
|---|---|---|
ticket_id |
text |
|
tag_id |
text |
Ocorrências
Objeto principal
| Campo | Tipo | |
|---|---|---|
id |
text |
|
account_id |
text |
|
attached_image_thumb_url |
text |
|
attached_image_url |
text |
|
auto_polarized |
boolean |
|
bot |
boolean |
|
bot_message |
boolean |
|
content_type |
text |
|
created_at |
timestamp |
|
crm_user__email |
text |
|
crm_user__gender |
text |
|
crm_user__id |
text |
|
crm_user__unknown |
boolean |
|
favorite |
boolean |
|
found_at |
timestamp |
|
interaction_type |
text |
|
interactions__fb_comments |
float |
|
interactions__fb_liked |
boolean |
|
interactions__fb_likes |
float |
|
interactions__fb_reaction_angry |
float |
|
interactions__fb_reaction_haha |
float |
|
interactions__fb_reaction_like |
float |
|
interactions__fb_reaction_love |
float |
|
interactions__fb_reaction_sad |
float |
|
interactions__fb_reaction_wow |
float |
|
interactions__fb_shares |
float |
|
interactions__gp_comments |
float |
|
interactions__gp_likes |
float |
|
interactions__gp_shares |
float |
|
interactions__ig_comments |
float |
|
interactions__ig_likes |
float |
|
interactions__li_comments |
float |
|
interactions__li_liked |
boolean |
|
interactions__li_likes |
float |
|
interactions__ra_back_doing_business |
boolean |
|
interactions__ra_rating |
text |
|
interactions__ra_resolved_issue |
boolean |
|
interactions__tw_liked |
boolean |
|
interactions__tw_likes |
float |
|
interactions__tw_retweeted |
boolean |
|
interactions__tw_retweets |
float |
|
interactions__yt_comments |
float |
|
interactions__yt_dislikes |
float |
|
interactions__yt_likes |
float |
|
interactions__yt_views |
float |
|
locale__city |
text |
|
locale__city_id |
text |
|
locale__country |
text |
|
locale__country_id |
text |
|
locale__country_short |
text |
|
locale__latitude |
text |
|
locale__longitude |
text |
|
locale__state |
text |
|
locale__state_id |
text |
|
locale__state_short |
text |
|
media_id |
text |
|
media_parent_id |
text |
|
polarization |
float |
|
published_on |
text |
|
published_on_date |
date |
|
published_on_hour |
float |
|
published_on_wday |
float |
|
reach |
float |
|
received_at |
text |
|
rules |
text |
|
search_id |
float |
|
search_setting_id |
float |
|
search_term |
text |
|
search_term_id |
float |
|
social_media__crm_key |
text |
|
social_media__custom_name |
text |
|
social_media__editable |
boolean |
|
social_media__hidable |
boolean |
|
social_media__hidden |
boolean |
|
social_media__key |
text |
|
social_media__rejected |
boolean |
|
social_media__removable |
boolean |
|
social_media__user_headline |
text |
|
social_media__user_id |
text |
|
social_media__user_image |
text |
|
social_media__user_name |
text |
|
source |
text |
|
text |
text |
|
ticket_id |
text |
|
title |
text |
|
url |
text |
tags
| Campo | Tipo | |
|---|---|---|
search_result_id |
text |
|
tag_id |
text |
Usuários CRM
Objeto principal
| Campo | Tipo | |
|---|---|---|
id |
text |
|
city |
text |
|
country |
text |
|
created_at |
timestamp |
|
text |
||
gender |
text |
|
name |
text |
|
phone |
text |
|
state |
text |
|
user_image_url |
text |
social_medias
| Campo | Tipo | |
|---|---|---|
crm_user_id |
text |
|
social_medias__media |
text |
|
social_medias__profile_url |
text |
|
social_medias__user_id |
text |
Publicações
| Campo | Tipo | |
|---|---|---|
id |
text |
|
account__active |
boolean |
|
account__authorized |
text |
|
account__bot_enabled |
boolean |
|
account__custom_name |
text |
|
account__group |
text |
|
account__id |
text |
|
account__image |
text |
|
account__name |
text |
|
account__removing |
boolean |
|
account__sac_enabled |
boolean |
|
account__sync_active |
boolean |
|
account__type |
text |
|
account__username |
text |
|
media_id |
text |
|
media_parent_id |
text |
|
media_url |
text |
|
publication__came_from |
text |
|
publication_engagement_clicks |
float |
|
publication_engagement_comments |
float |
|
publication_engagement_dislikes |
float |
|
publication_engagement_likes |
float |
|
publication_engagement_reach |
float |
|
publication_engagement_shares |
float |
|
publication_engagement_stories |
float |
|
publication_engagement_views |
float |
|
publication_engagement_reactions_angry |
float |
|
publication_engagement_reactions_haha |
float |
|
publication_engagement_reactions_like |
float |
|
publication_engagement_reactions_love |
float |
|
publication_engagement_reactions_sad |
float |
|
publication_engagement_reactions_wow |
float |
|
publication__id |
text |
|
publication__link |
text |
|
publication__message |
text |
|
publication__publish_at |
timestamp |
|
publication__status |
text |
|
publication__title |
text |
|
status |
text |
