Survey Monkey
Survey Monkey ETL connector for data replication
Survey Monkey
Survey Monkey ETL connector for data replication
Snapshot
| Features | |
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 |
email |
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 |
