Welcome Guest, you are in: Login

QVSource: The QlikView & Qlik Sense API Connector (Docs)

This will replace v1 of this Connector.


Overview

This page is being developed for the new connector, so may be subject to change.

This connector downloads data from the MailChimp API directly into your QlikView application.

You can see the listing for this connector on the MailChimp website here including a 5/5 review from one of our users.

Tables

QVSource is able to extract a number of tables from MailChimp, centred around the Lists and Campaigns of your profile.

Image

On selecting a table, the area below will display useful information about it, as shown in the image above.

Further, on selecting a table, the area to right will change, prompting you for additional information that's required in order to get the data. So, for example, on selecting the CampaignUnsubscribe table you need to enter the Campaign's ID.

Image

Usage

You should first obtain your MailChimp API key, which should be located here: https://us2.admin.mailchimp.com/account/api

Image

You can then enter this into the connector:

Image

For some of the tables, such as the Lists and Campaigns tables, just being authenticated is all you need.

On clicking 'Run' along the bottom you can then run the table.

Image

So, in this data we get each of the Lists available along with their IDs, name etc.

As mentioned earlier, some of the tables required extra parameters in order to get data. So, if we take for example the ListGrowth table we need to enter a ListID.

From the table we just ran, we can copy one of the List IDs and paste it in.

Image

Caching

This connector currently caches data returned from the API for 6 hours. For further information on clearing the cache see here.

Troubleshooting

DOMException: Invalid Character Error with Campaigns Table

If you receive an error containing the text:
DOMException: Invalid Character Error with Campaigns Table

When running the Campaigns table then this is an issue which MailChimp may need to help you resolve (as this error is being returned from their API).

We have heard from one user who fixed this issue by deleting a very old unused legacy auto responder from their account.

However, if this does not apply to you we would recommend you contact MailChimp's support (feel free to cc us) including the error response from the API.

Change Log

1.0.1 - 06/03/2015
  • Campaigns table now extracted in batches of 100 rows each in the background.
  • Better error message if error returned from MailChimp API.

1.0.0 - 16/06/2014
  • Initial release (replacement for V1). Please note, as there have been several changes to the MailChimp API this Connector is not backwards compatible with the previous version. We would recommed you regenerate load scripts using this new version and test these in copies of your existing applications before moving into production.


(QVSource works with Qlik Sense as well as QlikView - See this page for notes.)
QVSource - The QlikView & Qlik Sense API Connector | © Copyright 2011 - 2016 Industrial CodeBox Ltd