JDBC Driver for SurveyMonkey

Build 20.0.7654

SurveyQuestions

Shows the available columns for Survey Questions. Append _Questions to your survey name to query survey questions.

Select

To query the SurveyQuestions view, you must use the name of the survey and append '_Questions' to the end. With SupportEnhancedSQL set to true (the default), the driver will execute all filters to this table client-side in memory. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

SELECT * FROM [Volunteer Feedback Template_Questions]

SELECT * FROM [Benefits Template_Questions]

Columns

Name Type Description
SurveyId String The id of the survey.
QuestionId String The id of the question.
QuestionPosition Integer The position of that query in the Survey.
QuestionText String The text of the question.
QuestionFamily String The family of the question.
QuestionSubtype String The subtype 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.
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.
PageId String The id of the page.
PageTitle String The title of the page.

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