Survey Monkey
Survey Monkey ETL connector for data replication
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 |
surveys | survey_details |
responses | collectors |
survey_categories | survey_templates |
contacts | rollups |
trends | |
- Open My Apps tab and click on Add a New App button
Creating a new app
- Enter App name, creator mail and select Private App as app type
Creating a new app
- 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
- 1.Sign in to Daton
- 2.Select Survey Monkey from Integrations page
- 3.Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
- 4.In the next step you will be asked to enter survey monkey access token
- 5.Post successful authentication you will be prompted to choose required tables from the list
- 6.Then select all required fields
- 7.Submit the integration
- 1.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
- 2.Users would be able to edit/pause/re-activate/delete integration anytime
- 3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
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 |
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 |
Purpose: This API is used to fetch all responses registered in the surveys
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 |
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 |
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 |
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 |
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 |
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 |
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 modified 21d ago