FrontApp NA TEJ STRONIE
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.
Migawka cech Ogólne informacje o tym łączniku, w tym przydatne linki i obsługiwane cechy.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Informacja Upewnij się, że używane konto ma uprawnienia do odczytu interesujących Cię tabel.
Creating the connection Więcej informacji zawiera temat Łączenie się z aplikacjami SaaS
Wprowadź wymagane właściwości połączenia. Podaj nazwę połączenia w polu Nazwa połączenia .
Wybierz opcję Otwórz metadane połączenia , aby zdefiniować metadane połączenia po jegu utworzeniu.
Kliknij polecenie Utwórz .
Connection settings Setting Description Data gateway
Wybierz bramę Brama danych ruchu danych , jeżeli jest wymagana do danego zastosowania.
Informacja To pole jest niedostępne w subskrypcji Qlik Talend Cloud Starter , ponieważ brama Brama danych ruchu danych jest w niej nieobsługiwana. Jeśli masz inny poziom subskrypcji i nie chcesz korzystać z bramy Brama danych ruchu danych , wybierz opcję Brak .
Informacje o zaletach bramy Brama danych ruchu danych i o okolicznościach, w których jest wymagana, zawiera temat Brama danych Qlik — ruch danych
Start Date Wprowadź datę, w formacie MM/DD/YYYY, od której dane muszą być replikowane ze źródła do celu.
Token Token.
Informacja 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
