FrontApp BU SAYFADA
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.
Özellik anlık görüntüsü Yararlı bağlantılar ve desteklenen özellikler de dahil olmak üzere bu bağlayıcıya üst düzey bir bakış.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Bilgi notu Kullandığınız hesabın, almak istediğiniz tablolar için okuma erişimine sahip olduğundan emin olun.
Creating the connection Daha fazla bilgi için bk. SaaS uygulamalarına bağlanma .
Zorunlu bağlantı özelliklerini doldurun. Bağlantı adı kısmında bağlantı için bir ad sağlayın.
Oluşturulduğu zaman bağlantı için meta verileri tanımlamak üzere Bağlantı meta verilerini aç 'ı seçin.
Oluştur 'a tıklayın.
Connection settings Setting Description Data gateway
Kullanım durumunuz gerektiriyorsa bir Veri Hareketi ağ geçidi seçin.
Bilgi notu Qlik Talend Cloud Başlangıç Kılavuzu aboneliği Veri Hareketi ağ geçidi desteklenmediğinden bu alan, söz konusu abonelikle kullanılamaz. Başka bir abonelik kademeniz varsa ve Veri Hareketi ağ geçidi kullanmak istemiyorsanız Hiçbiri 'ni seçin.
Veri Hareketi ağ geçidi avantajları ve bunu gerektiren kullanım durumları hakkında bilgi için bkz. Qlik Data Gateway - Veri Hareketi .
Start Date Verilerin kaynağınızdan hedefinize çoğaltılması gereken tarihi MM/DD/YYYY biçiminde girin.
Token Token.
SchemaBilgi notu 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 (day or hour).
This table will include tags in your Front account.
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