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&APIComman...
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