Passing parameter values in RESTful web services API using SSIS
I am consuming RESTful API web services from a software service vendor. I am using a script task and an HTTP Connector in SSIS to download the information into a file and save it on a local machine. This works fine if no parameters are needed.
What I have as yet figured out how to do is to pass the parameter to the API URL. Below is an example of the URL that is needed to connect to the RESTful Web services site.