Power BI Connector for SurveyMonkey

Build 24.0.9062

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: =
The 本製品 processes other filters client-side within the 本製品.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062