Welcome Guest, you are in: Login

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

Introduction

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.

Image

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.

Authentication

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

Image

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

Image

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

Image

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

Image

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

Image

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:

Image

Tables

GetUserDetails

This table shows some basic user details:

Image

GetSurveyList

This table shows all your surveys:

Image

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.

GetSurveyDetailsAsXml

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

Image

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

Image

GetRespondentList

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

Image

GetResponsesAsXml

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.

Image

GetCollectorList

Shows the collectors for a particular survey (id).

Image

GetResponseCounts

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

Image

GetSummary

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.

Image

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