I need to create a table in Snowflake for survey questions so that I can map those to responses - is there a way in the APIs to get this information.
Is there a java script or something that someone else has figured out?
I want a table that would be an attribute table:
SurveyID QuestionID Type Description
SVfhalfas QID 3 Text Text What makes them a trusted advisor to you?
Then I create a table with response details
SurveyID Contact ID QuestionID Answer
SVfhalfas 325048350 QID 3 Text blah blah blah
Page 1 / 1
You can use the export API call which will give you the export of all responses which you can then use in Snowflake to upload/ push data.
https://api.qualtrics.com/65d940abeba1b-new-survey-response-export-guide
I don’t want to export, I want to write directly to snowflake with Workato integrations.
you can set a workflow in that case where using a web service call from Snowflake we can push responses on real real-time basis
https://www.qualtrics.com/support/survey-platform/actions-module/web-service-task/
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.