How Can I Get Data for Matrix Questions?

Question

How can I get data for SurveyMonkey Matrix questions?

Environment

Connector: SurveyMonkey

Answer

We use the SurveyMonkey API's Survey Pages and Questions endpoints to get data for the row items and column choices associated with Matrix questions.

We sync row items to the text column of the SUB_QUESTION_HISTORY table and column choices to the text column of the QUESTION_OPTION_HISTORY table.

To view the answer options for a Matrix question, join these tables to the QUESTION_HISTORY table using the question_id column. To see the results of a specific response, join these tables to the RESPONSE_ANSWER table using the following conditions:

• RESPONSE_ANSWER.CHOICE_ID = QUESTION_OPTION_HISTORY.ID
  

• RESPONSE_ANSWER.ROW_ID = SUB_QUESTION_HISTORY.ID