API for Questions and their Qualtrics code | Experience Community
Skip to main content

API for Questions and their Qualtrics code

  • September 6, 2023
  • 3 replies
  • 151 views
R
Forum|alt.badge.img+1

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

    3 replies

    Aanurag_QC
    QPN Level 5 ●●●●●
    Forum|alt.badge.img+31
    • Aanurag_QC
    • September 6, 2023

    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

    R
    Forum|alt.badge.img+1
    • ritaworkato
    • Author
    • September 6, 2023

    I don’t want to export,  I want to write directly to snowflake with Workato integrations.   

      Aanurag_QC
      QPN Level 5 ●●●●●
      Forum|alt.badge.img+31
      • Aanurag_QC
      • September 6, 2023

      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/

      Terms & ConditionsAccessibility statement