Is there a way in SQL to contact a website, or API?
I'm creating a sql based procedure which can 
1.Accept a table
2. load the values one at a time 
3. send the variables to an API
4. Record the response of the API
5. Write the response to a table for viewing later

I have successfully implemented 1,2, and 5. I am hoping there may be some way of choosing an address to contact and for SQL to listen too for a response. Please let me know if you have any suggestions!

Thanks!
Is there a way in SQL to contact a website, or API?
===

I'm creating a sql based procedure which can 
1.Accept a table
2. load the values one at a time 
3. send the variables to an API
4. Record the response of the API
5. Write the response to a table for viewing later

I have successfully implemented 1,2, and 5. I am hoping there may be some way of choosing an address to contact and for SQL to listen too for a response. Please let me know if you have any suggestions!

Thanks!