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}/questionsBut 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, valueabc, R_1234,QID1,<feedback input from customer>BTW - I use Workato to do the transformation and upsert into Snowflake.

Get responses to align with the QIDs from List of Questions to Response Details

Get responses to align with the QIDs from List of Questions to Response Details | Experience Community