rtay
asked on
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.
https://api.apisite.com:8111/api/fleets/young/platforms/311305/data?descriptions=true&values=true¶meterId=10245&startTime=2015-09-08&endTime=2015-09-09&maxCount=1000&startPort=-1&resolution=all
What I am looking for is how to pass a variable from SSIS to the Parameters startTime and endTime so I can automate the download of the needed data.
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.
https://api.apisite.com:8111/api/fleets/young/platforms/311305/data?descriptions=true&values=true¶meterId=10245&startTime=2015-09-08&endTime=2015-09-09&maxCount=1000&startPort=-1&resolution=all
What I am looking for is how to pass a variable from SSIS to the Parameters startTime and endTime so I can automate the download of the needed data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.