API for Questions and their Qualtrics code

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