JDBC Driver for SurveyMonkey

Build 20.0.7654

SurveyResponses

Shows the available columns for Survey Responses. Append _Responses to your survey name to query survey responses.

Select

To query the SurveyResponses view, you must use the name of the survey and append '_Responses' to the end.

The driver uses the SurveyMonkey APIs to filter results by the following columns and operators:

  • DateCreated/DateModified and TotalTime: > and <
  • RespondentId: =
  • QuestionId: = and IN
  • ResponseStatus, IpAddress, and TotalTimeUnit: =
The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will not be filtered.

For example, the following queries are processed server side:

SELECT * FROM [Volunteer Feedback Template_Responses]

SELECT * FROM [Benefits Template_Responses]

SELECT * FROM [Benefits Template_Responses] WHERE RespondentId = '1234567890'

SELECT * FROM [Benefits Template_Responses] WHERE RespondentId IN ('1234567890', '0987654321')

SELECT * FROM [Benefits Template_Responses] WHERE DateCreated > '2018-01-01' AND DateCreated < '2018-01-30'

SELECT * FROM [Benefits Template_Responses] WHERE QuestionId = '213965574'

SELECT * FROM [Benefits Template_Responses] WHERE QuestionId IN ('213965574', '213963957')

SELECT * FROM [Benefits Template_Responses] WHERE TotalTime > 5 AND TotalTime < 10 AND TotalTimeUnit='minute'

SELECT * FROM [Benefits Template_Responses] WHERE IpAddress = '192.168.0.1'

SELECT * FROM [Benefits Template_Responses] WHERE ResponseStatus = 'completed'

Note: When selecting a specific respondent, the aggregate column "Metadata" will be populated with a JsonObject and its elements can be accessed using the JSON_EXTRACT function in the SQLQuery.

Columns

Name Type Description
RespondentId String The id of the respondent, the person who answered this question.
SurveyId String The id of the survey.
RecipientId String The id of the recipient.
PageId String The id of the page.
QuestionId String The id of the question.
QuestionText String The text of the question.
ChoiceId String The id of the choice.
ChoiceText String The text of the choice.
ChoiceWeight String The weight of the choice. Used in questions of the subtype rating and ranking. Usually it's an ordinal number in incremenenting order.
ChoiceScore Int This field is dynamic and maps to the corresponding report field.
IsCorrectChoice Boolean This field is dynamic and maps to the corresponding report field.
RowId String The id of the row.
RowText String The text of the row.
ColId String The id of the column.
ColText String The text of the column.
OtherId String The id of the other field.
OtherText String The text of the other field.
AnswerText String The text of the answer (in the case of an open-ended question).
CollectionMode String The mode of collection.
CollectorId String The id of the collector the response was taken for.
TotalTime String Total time spent on this survey.
ResponseStatus String The status of the response. Valid values are `completed`, `partial`, `overquota`, and `disqualified`.
DateCreated Datetime Date and time when survey was created.
DateModified Datetime Date and time when survey was last modified.
CustomValue Integer A custom value for this response.
EditUrl String Survey edit URL.
AnalyzeUrl String Survey analyze URL.
IpAddress String The IP address of the respondent.
QuizCorrectAnswers Int This field is dynamic and maps to the corresponding report field.
QuizIncorrectAnswers Int This field is dynamic and maps to the corresponding report field.
QuizPartiallyCorrectAnswers Int This field is dynamic and maps to the corresponding report field.
QuizTotalScore Int This field is dynamic and maps to the corresponding report field.
QuizTotalQuestions Int This field is dynamic and maps to the corresponding report field.
QuizMaxScore Int This field is dynamic and maps to the corresponding report field.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
TotalTimeUnit String The unit of time you want to filter total time values with. Valids units are `second`, `minute`, and `hour`. If not specified, it will use `second` as a default value. This only affects the filtering on SurveyMonkey's end. The values returned for TotalTime from the API will still be in seconds despite what value is being sent for TotalTimeUnit.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654