I'm not sure if SQL Server or ASP.net can do this since I'm not an expert. I'm using an API from a e-commerce site. They have a way of using a url to download an xml file of any parameters i choose from a particular table.
Does SQL Server have a capability to insert and update a table from a URL link?
I guess my other alternative would be to use a VBscript to auto download the xml file to my hard drive but not sure how to auto trigger the xml file to the database table. Would like to auto trigger vbscript to get data and insert- update SQL tables every 15 minutes.
Any suggestions or resources I can go to learn how to do this?