Integration Specifications

This article will help you learn about how Daasity replicates data from Survey Monkey, limitations to the data we can extract and where the data is stored in the Survey Monkey schema

Integration Overview

Survey Monkey is an online survey software that helps businesses create and run professional online surveys. Survey Monkey gathers feedback through different platforms and provides analytics on response results that can be extracted.

This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.

Integration Availability

This integration is available for:

• Enterprise

API Endpoints

The Daasity Survey Monkey extractor is built based on this Survey Monkey API Documentation. The following endpoints are used by Daasity to replicate data from Survey Monkey:

• Surveys

• Survey Details

• Survey Responses Bulk

Entity Relationship Diagram (ERD)

Click here to view the ERD for the Daasity Survey Monkey integration illustrating the different tables and keys to join across tables.

Survey Monkey Schema

The Daasity Survey Monkey extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

• Surveys

• Survey Questions

• Survey Question Answers

• Responses

• Response Answers

Surveys

• Endpoint: Surveys

• Update Method: UPSERT

• Table Name: [survey_monkey.surveys]

JSON Element	Database Column
surveys::id	id
surveys::title	title
surveys::question_count	question_count
surveys::category	category
surveys::date_created	created_at
surveys::date_modified	updated_at
surveys::archived_at	archived_at
Daasity: account_id	_account_id
Daasity: timestamp when loaded into DB	__synced_at

Survey Questions

• Endpoint: Survey Details

• Update Method: UPSERT

• Table Name: [survey_monkey.survey_questions]

JSON Element	Database Column
surveys::pages::questions::id	id
surveys::id	survey_id
surveys::pages::position	page
surveys::pages::questions::headings::heading	question
surveys::pages::questions::family	family
surveys::pages::questions::subtype	subtype
survey::pages::questions::index	index
Daasity: account_id	_account_id
Daasity: timestamp when loaded into DB	__synced_at

Survey Question Answers

• Endpoint: Survey Details

• Update Method: UPSERT

• Table Name: [survey_monkey.survey_question_answers]

JSON Element	Database Column
survey::pages::questions::answers::id	id
survey::pages::questions::id	question_id
survey::pages::questions::answers::text	answer
survey::pages::questions::answers::type	type
survey::pages::questions::answers::choices::position	position
survey::pages::questions::answers::choices::weight	weight
Daasity: account_id	_account_id
Daasity: timestamp when loaded into DB	__synced_at

Responses

• Endpoint: Survey Responses Bulk

• Update Method: UPSERT

• Table Name: [survey_monkey.survey_responses]

JSON Element	Database Column
responses::id	id
survey::id	survey_id
response_status	status
responses::ip_address	ip_address
responses::collector_id	collector_id
responses::recipient_id	recipient_id
responses::date_created	created_at
responses::date_modified	updated_at
Daasity: account_id	_account_id
Daasity: timestamp when loaded into DB	__synced_at

Response Answers

• Endpoint: Survey Responses Bulk

• Update Method: UPSERT

• Table Name: [survey_monkey.survey_response_answers]

JSON Element	Database Column
responses::id + ':' + responses::pages::questions::id	key
responses::id	response_id
responses::pages::questions::id	question_id
responses::pages::questions::answers::text	answer
responses::pages::questions::answers::choice_id	choice_id
Daasity: account_id	_account_id
Daasity: timestamp when loaded into DB	__synced_at