<div>
<div class="content wysiwyg-content">
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. <br />
<br />
Does SQL Server have a capability to insert and update a table from a URL link? <br />
<br />
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.<br />
<br />
Any suggestions or resources I can go to learn how to do this?
</div>
</div>


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?

Insert, Update SQL Server table data from a API Url

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.

SSIS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.