I am trying to create a basic data model that is ingested into Snowflake for a table that has a list of questions by survey id - which I am able to transform the data from this https://yul1.qualtrics.com/API/v3/survey-definitions/{surveyId}/questions

But the QID from the this output is not how you do the the QID in GET Response Details.   

How can I get a simple extract to create this type of file.   It’s such a mess to get a things to match as indentifiers in this jumbled response APIs.

surveyId, responseId, QID, value
abc, R_1234,QID1,<feedback input from customer>

BTW - I use Workato to do the transformation and upsert into Snowflake.