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

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. 1.
    Sign in to Daton
  2. 2.
    Select Survey Monkey from Integrations page
  3. 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. 4.
    In the next step you will be asked to enter survey monkey access token
  5. 5.
    Post successful authentication you will be prompted to choose required tables from the list
  6. 6.
    Then select all required fields
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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
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
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
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
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
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
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
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
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
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