Forum Discussion
Connecting to URL to Download Within SSIS
Greetings.
I'm working with a solution called Encompass that runs on AWS.
I've been provided URLs that look like this:
https://api.encompass8.com/api?APIToken=61d3e99538e0eb52&APICommand=XYZ_SolverFullAccountString&EncompassID=XYZ
The link has been modified for privacy.
If you enter the actual URL, you are prompted to download a file.
I'd like to be able to connect to this and other URLs to automate downloading the files.
Is that possible in SSIS?
Thank you
1 Reply
Is that possible in SSIS?Should be, but highly depends on what that web API returns. SOAP, XML, Json, or ...; you haven't mentioned that.
See for example Web Service Task - SQL Server Integration Services (SSIS) | Microsoft Learn
Other option is a .NET script task Script Task - SQL Server Integration Services (SSIS) | Microsoft Learn
