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 connector 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 connector processes other filters client-side within the connector.

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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.