Create a new app. The client ID and secret are displayed when the app is created.
As the client secret is displayed only once, copy and paste it to a secured file.
Edit an existing app and click Rotate to generate a new client secret.
Make sure Authorized Redirect URIs is set to https://connector.qlik.com/auth/oauth/v3.htm.
Each OAuth app can only have one redirect URI.
Use a unique set of client id and client secret to authenticate each of your connections. Otherwise, your tasks associated with your older connections will fail.
Click Authenticate when you have filled in the required connection settings.
You may be asked to log in to the source application.
A window is displayed with an authentication code.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify.
Tip noteYou may need to scroll down to see this field.
When status is Verified, the authentication is verified.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.
Connection settings
Setting
Description
Data gateway
Select a Data Movement gateway if required by your use case.
Information note
This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.
Enter the date, in the format MM/DD/YYYY, from which the data must be replicated from your source to your target.
Email Activity Date Window
Enter the number of days for which you need to retrieve the email activity reports.
Example: 10. The reports of the last 10 days will be retrieved.
Client ID
Client ID.
Client Secret
Client secret.
Schema
Information note
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 1.
Depending on your destination, table and column names may not appear as they are outlined below.
automations
The automations table contains summary info about your MailChimp account’s automations. In MailChimp, an automation is a feature that sends a series of emails to subscribers when triggered by a specific date, activity, or event.
segment_opts: OBJECT, which is also a nested data structure.
conditions: ARRAY, which is also a nested data structure.
condition_type: STRING
field: STRING
op: STRING
value: STRING
match: STRING
prebuilt_segment_id: STRING
saved_segment_id: INTEGER
segment_text: STRING
report_summary
OBJECT
This is a nested data structure:
click_rate: NUMBER
clicks: INTEGER
ecommerce: OBJECT, which is also a nested data structure.
total_orders: INTEGER
total_revenue: INTEGER
total_spent: INTEGER
open_rate: NUMBER
opens: INTEGER
subscriber_clicks: INTEGER
unique_opens: INTEGER
resendable
BOOLEAN
send_time
DATE-TIME
settings
OBJECT
This is a nested data structure:
authenticate: BOOLEAN
auto_footer: BOOLEAN
auto_tweet: BOOLEAN
drag_and_drop: BOOLEAN
fb_comments: BOOLEAN
folder_id: STRING
from_name: STRING
inline_css: BOOLEAN
preview_text: STRING
reply_to: STRING
subject_line: STRING
template_id: STRING
timewarp: BOOLEAN
title: STRING
to_name: STRING
use_conversation: BOOLEAN
social_card
OBJECT
This is a nested data structure:
description: STRING
image_url: STRING
title: STRING
status
STRING
tracking
OBJECT
This is a nested data structure:
clicktale: STRING
ecomm360: BOOLEAN
goal_tracking: BOOLEAN
google_analytics: STRING
html_clicks: BOOLEAN
opens: BOOLEAN
text_clicks: BOOLEAN
type
STRING
web_id
INTEGER
list_members
The list_members table contains info about the members in a specific MailChimp list, including currently subscribed, unsubscribed, and bounced members.
conditions: ARRAY, which is also a nested data structure.
condition_type: STRING
field: STRING
op: STRING
value: STRING
match: STRING
type
STRING
updated_at
DATE-TIME
lists
The lists table contains info about all the lists in your MailChimp account. A list is also known as an audience, and is where all contacts are stored and managed in MailChimp.
