Connect to web-service/API in MySQL?
mysql, sql, web-services
Solution
The only way MySQL can call a webservice is through a custom UDF.
See the below link, but basically what you would need to do is build a C program that would call the remote webservice API with the variables as parameters, return the reponse via the UDF to your actual SQL which could insert the results to a table. This is quite a lot of work though, especially if you are not at all familiar with C.
http://www.codeguru.com/cpp/data/mfc_database/misc/article.php/c12615/MySQL-UDFs.htm
Problem
I'm creating a sql based procedure which can - Accept a table - load the values one at a time - send the variables to a remote API - Record the response of the API - 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!