In this post you will learn how to import JSON / XML Files or REST API / SOAP Web Service using ZappySys ODBC Drivers for REST API.
In this post we will show you how to read data from REST API service (example like this) and then consume / load into your BI / Reporting Tool.
Steps to Import REST API using ODBC Driver
Here are high level steps to import any REST API
- First download ZappySys ODBC Drivers for REST API.
- Follow this link to create ODBC DSN for JSON Driver
- Now in your App select ODBC connectivity option and Import data from DSN we created (Click on App link for details)
Here is simple example API request.
REST API Integration for Reporting / ETL Tools / Programming Language
BI / Reporting Tools