FrontApp NESTA PÁGINA
FrontApp is a customer communication platform that combines emails, apps, and teammates into a single view.
Front integration replicates data using the Front API .
See the
Schema section for a list of objects available for replication.
Snapshot de recursos Uma visão de alto nível desse conector, incluindo links úteis e recursos compatíveis.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Nota informativa Certifique-se de que a conta que você usa tenha acesso de leitura às tabelas que deseja buscar.
Creating the connection Para obter mais informações, consulte Conectando-se a aplicativos SAP
Preencha as propriedades de conexão obrigatórias. Forneça um nome para a conexão em Nome da conexão .
Selecione Abrir metadados de conexão para definir metadados para a conexão quando ela for criada.
Clique em Criar .
Connection settings Setting Description Data gateway
Selecione um Gateway Data Movement se for necessário para seu caso de uso.
Nota informativa Esse campo não está disponível com a assinatura do Iniciante do Qlik Talend Cloud , pois esta não é compatível com o Gateway Data Movement . Se você tiver outro nível de assinatura e não quiser usar o Gateway Data Movement , selecione Nenhum .
Para obter informações sobre os benefícios do Gateway Data Movement e casos de uso que exigem isso, consulte Qlik Data Gateway - Movimentação de dados
Start Date Digite a data, no formato MM/DD/YYYY, a partir da qual os dados devem ser replicados da fonte de dados para o destino.
Token Token.
Nota informativa Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 2.
Depending on your destination, table and column names may not appear as they are outlined below.
accounts_table
The accounts_table table contains data about accounts in your Front account.
Replication Method
CDC
Primary Key
report_id
Replication Keys
analytics_date
analytics_range
Useful links
Front documentation
accounts_table table schema
analytics_date
STRING
analytics_range
STRING
avg_first_response_time
NUMBER
avg_handle_time
NUMBER
avg_response_time
NUMBER
avg_sla_breach_time
NUMBER
avg_total_reply_time
NUMBER
metric_description
STRING
metric_id
STRING
new_segments_count
NUMBER
num_active_segments_full
NUMBER
num_archived_segments
NUMBER
num_archived_segments_with_reply
NUMBER
num_closed_segments
NUMBER
num_csat_survey_response
NUMBER
num_messages_received
NUMBER
num_messages_sent
NUMBER
num_open_segments_end
NUMBER
num_open_segments_start
NUMBER
num_sla_breach
NUMBER
num_workload_segments
NUMBER
pct_csat_survey_satisfaction
NUMBER
pct_tagged_conversations
NUMBER
report_id
STRING
channels_table
The channels_table table contains data about channels in your Front account.
Replication Method
CDC
Primary Key
report_id
Replication Keys
analytics_date
analytics_range
Useful links
Front documentation
channels_table table schema
analytics_date
STRING
analytics_range
STRING
avg_first_response_time
NUMBER
avg_handle_time
NUMBER
avg_response_time
NUMBER
avg_sla_breach_time
NUMBER
avg_total_reply_time
NUMBER
metric_description
STRING
metric_id
STRING
new_segments_count
NUMBER
num_active_segments_full
NUMBER
num_archived_segments
NUMBER
num_archived_segments_with_reply
NUMBER
num_closed_segments
NUMBER
num_csat_survey_response
NUMBER
num_messages_received
NUMBER
num_messages_sent
NUMBER
num_open_segments_end
NUMBER
num_open_segments_start
NUMBER
num_sla_breach
NUMBER
num_workload_segments
NUMBER
pct_csat_survey_satisfaction
NUMBER
pct_tagged_conversations
NUMBER
report_id
STRING
inboxes_table
The inboxes_table table contains data about inboxes in your Front account.
Replication Method
CDC
Primary Key
report_id
Replication Keys
analytics_date
analytics_range
Useful links
Front documentation
inboxes_table table schema
analytics_date
STRING
analytics_range
STRING
avg_first_response_time
NUMBER
avg_handle_time
NUMBER
avg_response_time
NUMBER
avg_sla_breach_time
NUMBER
avg_total_reply_time
NUMBER
metric_description
STRING
metric_id
STRING
new_segments_count
NUMBER
num_active_segments_full
NUMBER
num_archived_segments
NUMBER
num_archived_segments_with_reply
NUMBER
num_closed_segments
NUMBER
num_csat_survey_response
NUMBER
num_messages_received
NUMBER
num_messages_sent
NUMBER
num_open_segments_end
NUMBER
num_open_segments_start
NUMBER
num_sla_breach
NUMBER
num_workload_segments
NUMBER
pct_csat_survey_satisfaction
NUMBER
pct_tagged_conversations
NUMBER
report_id
STRING
The tags_table table contains a list of tag statistics since the last completed replication job through the most recent iteration of the defined Incremental Range Note : During the historical replication job, all increments (defined using the Incremental Range setting) since the Start Date will be replicated. This will result in the first record for this table being an aggregated record across all tags.
Replication Method
CDC
Primary Key
report_id
Replication Keys
analytics_date
analytics_range
Useful links
Front documentation
teammates_table
The teammates_table table contains data about teammates in your Front account.
Replication Method
CDC
Primary Key
report_id
Replication Keys
analytics_date
analytics_range
Useful links
Front documentation
teammates_table table schema
analytics_date
STRING
analytics_range
STRING
avg_first_response_time
NUMBER
avg_handle_time
NUMBER
avg_response_time
NUMBER
avg_sla_breach_time
NUMBER
avg_total_reply_time
NUMBER
metric_description
STRING
metric_id
STRING
new_segments_count
NUMBER
num_active_segments_full
NUMBER
num_archived_segments
NUMBER
num_archived_segments_with_reply
NUMBER
num_closed_segments
NUMBER
num_csat_survey_response
NUMBER
num_messages_received
NUMBER
num_messages_sent
NUMBER
num_open_segments_end
NUMBER
num_open_segments_start
NUMBER
num_sla_breach
NUMBER
num_workload_segments
NUMBER
pct_csat_survey_satisfaction
NUMBER
pct_tagged_conversations
NUMBER
report_id
STRING
teams_table
The teams_table table contains data about teams in your Front account.
Replication Method
CDC
Primary Key
report_id
Replication Keys
analytics_date
analytics_range
Useful links
Front documentation
teams_table table schema
analytics_date
STRING
analytics_range
STRING
avg_first_response_time
NUMBER
avg_handle_time
NUMBER
avg_response_time
NUMBER
avg_sla_breach_time
NUMBER
avg_total_reply_time
NUMBER
metric_description
STRING
metric_id
STRING
new_segments_count
NUMBER
num_active_segments_full
NUMBER
num_archived_segments
NUMBER
num_archived_segments_with_reply
NUMBER
num_closed_segments
NUMBER
num_csat_survey_response
NUMBER
num_messages_received
NUMBER
num_messages_sent
NUMBER
num_open_segments_end
NUMBER
num_open_segments_start
NUMBER
num_sla_breach
NUMBER
num_workload_segments
NUMBER
pct_csat_survey_satisfaction
NUMBER
pct_tagged_conversations
NUMBER
report_id
STRING
