Survey Monkey
Survey Monkey ETL connector for data replication
Snapshot
| Features | Details |
|---|---|
Release Status | Released |
Source API Version | V3 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Survey Monkey access token |
Replication Type | Key Based Replication, Full Replication |
Replication Key | modified_at |
Suggested Replication Frequency | 24 hours |
Tables/APIs Supported
surveys | survey_details |
responses | collectors |
survey_categories | survey_templates |
contacts | rollups |
trends |
Generating Access Token for Survey Monkey
Login to https://developer.surveymonkey.com/
Open My Apps tab and click on Add a New App button
Enter App name, creator mail and select Private App as app type
Once created, open Settings of the app and go to Credentials section
You can find the Access Token for your account here
Scopes required are - users_read, collectors_read, surveys_read, contacts_read, responses_read, responses_read_detail
Use this access token while creating an integration with Daton
Integrate Survey Monkey with Daton
Sign in to Daton
Select Survey Monkey from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
In the next step you will be asked to enter survey monkey access token
Post successful authentication you will be prompted to choose required tables from the list
Then select all required fields
Submit the integration
Workflow
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Survey Monkey Data
surveys
Purpose: This API is used to fetch all surveys in the given account
Source API Documentation: https://api.surveymonkey.com/v3/docs?api_key=3yr7n6m8sjwvm48x8nhxej52#api-endpoints-get-surveys
Replication: Key Based Incremental
Replication Key: start_modified_at, end_modified_at
Fields
| Name | Data Type |
|---|---|
id | STRING |
title | STRING |
nickname | STRING |
href | STRING |
survey_details
Purpose: This API is used to fetch detailed information about the surveys
Source API Documentation: https://api.surveymonkey.com/v3/docs?api_key=3yr7n6m8sjwvm48x8nhxej52#api-endpoints-get-surveys-id-details
Replication: Key Based Incremental
Replication Key: start_modified_at, end_modified_at
Fields
| Name | Data Type |
|---|---|
title | STRING |
nickname | STRING |
language | STRING |
folder_id | STRING |
category | STRING |
question_count | NUMERIC |
page_count | NUMERIC |
response_count | NUMERIC |
date_created | DATETIME |
date_modified | DATETIME |
id | STRING |
buttons_text | RECORD |
is_owner | BOOLEAN |
footer | BOOLEAN |
theme_id | STRING |
href | STRING |
analyze_url | STRING |
edit_url | STRING |
collect_url | STRING |
summary_url | STRING |
preview | STRING |
pages | RECORD |
responses
Purpose: This API is used to fetch all responses registered in the surveys
Source API Documentation: https://api.surveymonkey.com/v3/docs?api_key=3yr7n6m8sjwvm48x8nhxej52#api-endpoints-get-surveys-id-responses-bulk
Replication: Key Based Incremental
Replication Key: start_modified_at, end_modified_at
Fields
| Name | Data Type |
|---|---|
id | STRING |
recipient_id | STRING |
collection_mode | STRING |
response_status | STRING |
custom_value | STRING |
first_name | STRING |
last_name | STRING |
email_address | STRING |
ip_address | STRING |
collector_id | STRING |
survey_id | STRING |
edit_url | STRING |
analyze_url | STRING |
total_time | NUMERIC |
date_modified | TIMESTAMP |
date_created | TIMESTAMP |
href | STRING |
pages | RECORD |
collectors
Purpose: This API is used to fetch about the collectors in all the surveys
Source API Documentation: https://api.surveymonkey.com/v3/docs?api_key=3yr7n6m8sjwvm48x8nhxej52#api-endpoints-get-collectors-id-
Replication: Key Based Incremental
Replication Key: start_modified_at, end_modified_at
Fields
| Name | Data Type |
|---|---|
status | STRING |
id | STRING |
survey_id | STRING |
type | STRING |
name | STRING |
thank_you_message | STRING |
thank_you_page | RECORD |
disqualification_message | STRING |
disqualification_url | STRING |
close_date | TIMESTAMP |
closed_page_message | STRING |
redirect_url | STRING |
display_survey_results | BOOLEAN |
edit_response_type | STRING |
anonymous_type | STRING |
allow_multiple_responses | BOOLEAN |
date_modified | TIMESTAMP |
url | STRING |
date_created | TIMESTAMP |
password_enabled | BOOLEAN |
response_limit | NUMERIC |
redirect_type | STRING |
respondent_authentication | BOOLEAN |
href | STRING |
survey_categories
Purpose: This API is used to fetch all the categories of surveys
Source API Documentation: https://api.surveymonkey.com/v3/docs?api_key=3yr7n6m8sjwvm48x8nhxej52#api-endpoints-get-survey_categories
Replication: Full Replication
Replication Key: N/A
Fields
| Name | Data Type |
|---|---|
name | STRING |
id | STRING |
survey_templates
Purpose: This API is used to fetch all templates of the given account
Source API Documentation: https://api.surveymonkey.com/v3/docs?api_key=3yr7n6m8sjwvm48x8nhxej52#api-endpoints-get-survey_templates
Replication: Full Replication
Replication Key: N/A
Fields
| Name | Data Type |
|---|---|
category | STRING |
name | STRING |
description | STRING |
title | STRING |
available | BOOLEAN |
num_questions | NUMERIC |
id | STRING |
preview_link | STRING |
contacts
Purpose: This API is used to fetch all contact details in the account
Source API Documentation: https://api.surveymonkey.com/v3/docs?api_key=3yr7n6m8sjwvm48x8nhxej52#api-endpoints-get-contacts
Replication: Full Replication
Replication Key: N/A
Fields
| Name | Data Type |
|---|---|
id | STRING |
first_name | STRING |
last_name | STRING |
STRING | |
href | STRING |
status | STRING |
rollups
Purpose: This API is used to fetch rollups for all questions in a survey
Source API Documentation: https://api.surveymonkey.com/v3/docs?api_key=3yr7n6m8sjwvm48x8nhxej52#api-endpoints-get-surveys-id-rollups
Replication: Key Based Incremental
Replication Key: start_modified_at, end_modified_at
Fields
| Name | Data Type |
|---|---|
id | STRING |
family | STRING |
subtype | STRING |
href | STRING |
summary | RECORD |
trends
Purpose: This API is used to fetch answer trends hour wise
Source API Documentation: https://api.surveymonkey.com/v3/docs?api_key=3yr7n6m8sjwvm48x8nhxej52#api-endpoints-get-surveys-id-trends
Replication: Key Based Incremental
Replication Key: start_modified_at, end_modified_at
Fields
| Name | Data Type |
|---|---|
id | STRING |
family | STRING |
subtype | STRING |
href | STRING |
trend_by | STRING |
answered | NUMERIC |
skipped | NUMERIC |
trends | RECORD |
Last updated
