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 本製品 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: =
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. |