Skip to main content

Survey Monkey

The Qlik Survey Monkey Connector uses the Survey Monkey API to fetch data about collector types or survey respondents.

Note: This Survey Monkey connector is only available in SaaS editions of Qlik Sense. For the client managed version, see Qlik Web Connectors: Survey Monkey.

Supported offerings

  • Qlik Sense Business
  • Qlik Sense Enterprise SaaS

Accessing data

You will need to authenticate the connector with your Survey Monkey account credentials to access your data. After you create a connection and select Survey Monkey as your data source, you will be redirected to a Survey Monkey login page to retrieve your authentication token.

Creating a data source connection

Selecting data

After you authenticate the connector with your account credentials, use the tables to fetch your data. Some tables are preconfigured to access a specific set of data while others let you create custom queries.

Do the following:

  1. Select a table from the Tables column.
  2. Enter table parameters, if required.

    Required parameters are marked with a *.

  3. Click Data preview to see a sample of your data and to select the table fields that you want to load.

The table below outlines some of the use cases for some of the tables that are available.

Tables that can be loaded Tables that can be loaded
Table Available in Description
GetCollectorList Data load editor Retrieves a paged list of collectors for a survey in a user's account.
GetRespondentList Data load editor Use this table to fetch the list of respondent IDs for a collector list. This list displays the respondent IDs which are needed to run other tables.
GetResponses Data manager and Data load editor Use this table to fetch the list of responses for a survey.
GetSurveyList Data manager and Data load editor Use this table to fetch the list of surveys associated with your account. The list displays the survey IDs which are needed to run the other tables.
GetUserDetails Data load editor Returns basic information about the authenticated user.

Table parameters

To run some of the tables, you need to enter specific table parameters, usually in the form of an object ID or an object name. You can find many of these parameters when you run other tables.

For example, to run the GetCollectorList table you need to enter a survey ID. You can fetch the list of surveys and their IDs by running the GetSurveyList table.

Loading data into your Qlik Sense app

Once you have finished selecting data, you can load your data into your Qlik Sense app. How you proceed will depend on whether you load data with Add data or the Data load editor.

Add data

To load data using Add data, click Add data. This will open the data in the Associations view of the data manager. In the associations view, you can continue to add data sources, transform the data, and associate the tables in Data manager.

Data profiling is enabled by default when you click Add data. Data profiling does the following:

  • Recommends data associations.
  • Auto-qualifies common fields between tables. This adds a unique prefix based on table name.
  • Maps date and time fields to autoCalendar.

Tables are not associated on common field names automatically. You can associate tables in the Associations view.

Managing data associations

Tip:

If you want to load the data directly into your app, click More and then disable data profiling.

When you add data with data profiling disabled, all existing data from data sources will be reloaded when you add the data. Tables will be associated on common field names automatically. Date and time fields will not be created.

Data load editor

To load data with the Data load editor, click Insert script once you are finished selecting the data. A load script is inserted into the script editor of the Data load editor. You can continue to edit the script in the script editor or you can click Load data to run the data load script.

Working with the Survey Monkey API quota limit

You receive an error message that you have reached the API rate limit

Reference - Survey Monkey developer documentation

You can refer to the SurveyMonkey API documentation to learn more about the requirements and restriction imposed by the APIs when making requests.

Troubleshooting

You receive an error message that you have reached the API rate limit

Possible cause

You have exceeded the API limits that are imposed on the Qlik Web Connectors by the Survey Monkey API.

Proposed action

To reduce the impact of reaching the API rate limits, develop your app with the following in mind:

  • Extract only the data you need.
  • Reload one Survey Monkey-based application at a time.
  • Ensure that loops in your script that make API calls will not result in infinite loops.