Welcome Guest, you are in: Login

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


QVSource 1.6.2 and later contains a dedicated connector to SurveyMonkey which is shown below:

NOTE: This page uses screen shots from the new Web Edition of QVSource which is currently in beta. However the functionality and layout of the connector is very similar in the current WinForms edition.


This provides access to the SurveyMonkey API and additionally a 'Summary' table which makes several API calls internally to produce survey questions and responses in a simplified form.

The guide below uses example surveys. You will first need to create your own surveys using https://www.surveymonkey.com if you want to work through following the guide.


The first step is to get authenticated. Select the CanAuthenticate table and hit the Parameters button. Then click the Authenticate button:


Assuming you have set your browser to allow popups, the SurveyMonkey login page should open:


Enter your username and password and click Authorize. You should be redirected to a page containing an authentication code:


Copy this code and return to the main QVSource page, paste into the Authentication Code field, then click Save.


If all was successful, running the table should display 'true' in the authenticated column.


Note if you later want to revoke access, the CanAuthenticate table description contains a link to your https://www.surveymonkey.com/user/account/ page where you can remove the link to QVSource:




This table shows some basic user details:



This table shows all your surveys:


A note about the basic tables / API calls

The SurveyMonkey API is pretty flexible in how it exposes data, however it can be slightly confusing if you just want to see survey questions and responses. Therefore this connector has a table per API endpoint and additionally includes a Summary table which internally gets the survey details, the corresponding respondent list and responses for each respondent and resolves the question, answer and respondent ids to produce a simplified table (also available as XML). At this point it might make sense to see the Summary table notes below, then return to this point if required.


Retrieves a given survey's metadata as XML. Includes question and answer ids.


Note to see the formatted XML, click either of the links in the QlikView or Qlik Sense tab.



Retrieves a paged list of respondents for a survey (id). Just the respondent ids are returned.



Retrieves the responses for a survey (id) and up to 100 respondent (ids as comma separated list). This includes respondent ids, question ids and answer ids.

Again the formatted XML can be viewed by clicking either of the links in the QlikView or Qlik Sense tab.



Shows the collectors for a particular survey (id).



Shows the number of respondents that have started or completed the survey (for the specified collector id).



Returns a summary of responses for a given survey (id). Note that this internally makes a few SurveyMonkey API calls as described above, and stitches together the results to show a simplified table.

Note that matrix/grid type questions are displayed as Question/Sub Question columns for simplicity. If a column has no value e.g. there is no 'Sub Question' or a Count is not relevant due to other/free text answers then 'N/A' is displayed in the table cell.


Note that there is also an XML version of this table (GetSummaryAsXml).

API and Question Types

Most of the API endpoints and question types are supported. Please contact us if you require an endpoint or question type that is not supported.

Previous Version

The previous version of this page illustrated how to connect to Survey Monkey from QlikView and Qlik Sense using the General Web Connector.

Change Log

0.7.3 - 16/07/15
  • Added Weight column.

0.7.2 - 09/07/15
  • Added SubQuestion column for matrix questions.
  • Added columns to GetCollectorList table.

0.7.1 - 16/06/15
  • Increased API call quota.
  • Added GetSummary and GetSummaryAsXml tables.

0.7.0 - 03/06/15
  • Initial release. Note this is currently in an experimental phase as SurveyMonkey only permit 1000 API calls per day by default and this will be shared by all users of the connector. We have applied to SurveyMonkey for increased access.
  Name Size
- auth_1.png 130.79 KB
- auth_2.png 164.36 KB
- auth_3.png 197.59 KB
- auth_4.png 138.22 KB
- auth_5.png 139.09 KB
- collector_list.png 144.86 KB
- details.png 193.64 KB
- details_as_xml.png 147.78 KB
- respondent_list.png 146.43 KB
- responses_as_xml.png 198.37 KB
- responses_as_xml_2.png 145.83 KB
- response_counts.png 128.35 KB
- sm_main.png 149.89 KB
- summary.png 181.87 KB
- survey_list.png 192.72 KB
- unlink.png 140.53 KB
- user_details.png 142.97 KB

(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