How Can I Find Multiple Choice Answers in My Destination?

Question

My survey contains a Multiple Choice question with the multiple selection option enabled. How can I locate the answers to the question in the destination?

Environment

Connector: Typeform

Resolution

Typeform's API stores the answers to Multiple Choice questions in the label field of each response. To retrieve the labels (answers) for a particular form response, you must join the RESPONSE_ANSWER, FORM_FIELD_CHOICE_HISTORY, and RESPONSE_ANSWER_CHOICE tables.

Use the following query to find the answers to a particular Multiple Choice question:

SELECT
ffch.form_id,
rac.response_id,
rac.field_id,
ffch.label from
<schema_name>.form_field_choice_history ffch
JOIN <schema_name>.response_answer_choice rac
ON rac.field_id = ffch.field_id and rac.choice_id = ffch.id;