Introduction There might be a case when you have many CSV, JSON or XML files in Azure Blob and you want them to be imported straight into a SQL Server table. Here come ZappySys ODBC PowerPack and ZappySys Data Gateway (part of ODBC PowerPack) which will enable you to accomplish that. ZappySys ODBC PowerPack includes powerful Azure […]
Introduction In our previous blog post we saw how to import rest API in SQL Server. Using same concepts lets look at how to import Amazon MWS Data into SQL Server. We will explore many techniques to call Amazon MWS API and learn how to automate Amazon MWS data extraction without doing any ETL. We […]
Introduction In this article, you will see few Examples to import REST API in SQL Server Table (Call JSON / XML SOAP API). You will also learn how to load JSON Files into SQL Server Table using T-SQL Stored procedure code. So let’s get ready for fun 🙂 JSON File format and REST API (i.e. RESTful […]