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

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

Integrate Survey Monkey 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

Workflow

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

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