Importing Data in SQL Server from an API that uses a token call

820 Views Asked by At

I am trying to import data into a sql server table that comes from a web api utilizing SSIS but open to other methods. I first need to send a token call with my unique ID in the URL and then send a new call with that token ID in the URL for the data. The token is only active for 30 minutes and I am looking to do this hourly. Any direction anyone could provide would be highly appreciated

0

There are 0 best solutions below