Surveymonkey
Setting up the Surveymonkey connector
| No | Item | Required | Example | Notes |
|---|---|---|---|---|
| 1 | Origin datacenter of the SurveyMonkey account | No | Depending on the originating datacenter of the SurveyMonkey account, the API access URL may be different. | |
| 2 | SurveyMonkey Authorization Method | Yes | The authorization method to use to retrieve data from SurveyMonkey Refer to the documentation in the form while using the connector | |
| 3 | Start Date | Yes | 2021-01-01T00:00:00Z | UTC date and time in the format 2017-01-25T00:00:00Z. Any data before this date will not be replicated. |
| 4 | Survey Monkey survey IDs | No | IDs of the surveys from which you'd like to replicate data. If left empty, data from all boards to which you have access will be replicated. |
Tables in the Surveymonkey connector
| No | Table Name | Columns | Primary Keys | Read Mode | Inc. Sync Keys | API Info |
|---|---|---|---|---|---|---|
| 1 | survey_pages | 6 | Full Refresh | `` | ||
| 2 | survey_questions | 14 | Full Refresh | `` | ||
| 3 | surveys | 21 | Full Refresh, Incremental | date_modified | API Reference | |
| 4 | survey_ids | 4 | ||||
| 5 | survey_responses | 22 | Full Refresh, Incremental | date_modified |
Table: survey_pages
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | question_count | INTEGER | |
| 2 | description | VARCHAR | |
| 3 | position | INTEGER | |
| 4 | id | VARCHAR | |
| 5 | href | VARCHAR | |
| 6 | title | VARCHAR |
Table: survey_questions
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | visible | BOOLEAN | |
| 2 | answers | VARCHAR | |
| 3 | required | VARCHAR | |
| 4 | layout | VARCHAR | |
| 5 | page_id | VARCHAR | |
| 6 | subtype | VARCHAR | |
| 7 | sorting | VARCHAR | |
| 8 | headings | VARCHAR | |
| 9 | id | VARCHAR | |
| 10 | position | INTEGER | |
| 11 | href | VARCHAR | |
| 12 | family | VARCHAR | |
| 13 | forced_ranking | BOOLEAN | |
| 14 | validation | VARCHAR |
Table: surveys
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | preview | VARCHAR | |
| 2 | response_count | INTEGER | |
| 3 | collect_url | VARCHAR | |
| 4 | buttons_text | VARCHAR | |
| 5 | footer | BOOLEAN | |
| 6 | date_created | VARCHAR | |
| 7 | is_owner | BOOLEAN | |
| 8 | custom_variables | VARCHAR | |
| 9 | language | VARCHAR | |
| 10 | title | VARCHAR | |
| 11 | question_count | INTEGER | |
| 12 | date_modified | VARCHAR | Incremental sync key |
| 13 | nickname | VARCHAR | |
| 14 | edit_url | VARCHAR | |
| 15 | id | VARCHAR | |
| 16 | href | VARCHAR | |
| 17 | folder_id | VARCHAR | |
| 18 | category | VARCHAR | |
| 19 | analyze_url | VARCHAR | |
| 20 | summary_url | VARCHAR | |
| 21 | page_count | INTEGER |
Table: survey_ids
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | nickname | VARCHAR | |
| 2 | id | VARCHAR | |
| 3 | href | VARCHAR | |
| 4 | title | VARCHAR |
Table: survey_responses
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | metadata | VARCHAR | |
| 2 | response_status | VARCHAR | |
| 3 | date_created | VARCHAR | |
| 4 | custom_variables | VARCHAR | |
| 5 | custom_value | VARCHAR | |
| 6 | logic_path | VARCHAR | |
| 7 | last_name | VARCHAR | |
| 8 | ip_address | VARCHAR | |
| 9 | survey_id | VARCHAR | |
| 10 | email_address | VARCHAR | |
| 11 | pages | VARCHAR | |
| 12 | date_modified | VARCHAR | Incremental sync key |
| 13 | collection_mode | VARCHAR | |
| 14 | collector_id | VARCHAR | |
| 15 | edit_url | VARCHAR | |
| 16 | page_path | VARCHAR | |
| 17 | id | VARCHAR | |
| 18 | href | VARCHAR | |
| 19 | analyze_url | VARCHAR | |
| 20 | total_time | INTEGER | |
| 21 | first_name | VARCHAR | |
| 22 | recipient_id | VARCHAR |
External Resources
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.