Home » reporting

Download AdWords report using Google Ads API, ODBC, and XML Driver

Posted on October 24, 2019November 25, 2019 by ZappySys

Introduction In the previous article, we learned how to get data from AdWords in SSIS and basically control your AdWords account programmatically, outside the dashboard. In this one, we will continue on how to download AdWords report by using Google Ads API, ODBC, and ZappySys XML Driver. Let’s not waste our time and cut to […]

How to read REST API in SSRS Reports (JSON / XML / Call SOAP Web Service)

Posted on April 19, 2018June 14, 2023 by ZappySys Team

Introduction (Read REST / SOAP API in SSRS) In this tutorial, you will learn how to read REST API in SSRS (SQL Server Reporting Services). Traditionally to read data from XML / JSON Files or RESTful web service in SSRS, some sort of ETL approach was needed (i.e Load data from JSON / XML to SQL […]