Hi I would need to consume data from REST API using SSIS package so that later on we can set up a job using that package to import results/data on daily basis.
Please guide me on how to get started? I have never created SSIS package before and requirement is to create a package and deploy it
I have never used SSIS but probably the best place to start would be the SurveyGizmo API docs:
The docs will give you info on authentication options and have a reference of all the API endpoints that you have access to. I know this isn’t much but hopefully, it helps.