How to Import REST API using ODBC Driver ( JSON / XML / SOAP / CSV)

Introduction

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 

1. First download  ZappySys ODBC Drivers for REST API.
2. Follow this link to create ODBC DSN for JSON Driver
3. Now in your App select ODBC connectivity option and Import data from DSN we created (Click on App link for details)

Example

Here is simple example API request.

Request 

POST https://emo.mews.li/api/connector/v1/configuration/get
Content-Type: application/json

 

Body

{
"ClientToken": "E0D439EE522F44368DC78E1BFB03710C-D24FB11DBE31D4621C4817E028D9E1D",
"AccessToken": "C66EF7B239D24632943D115EDE9CB810-EA00F8FD8294692C940F6B5A8F9453D"
}

 

Open Your DSN Configuration.

Select Add ZappySys JSON Driver and configure like below.

 

 

 

After you Configure REST API request properties, you can click on preview tab

 

REST API Integration for Reporting / ETL Tools / Programming Language

 

BI / Reporting Tools Integration	ETL Tools Integration	Programming Languages Integration
Microsoft Power BI Tableau SSRS (SQL Reporting Services) QlikView /Qlik Sense MicroStrategy Google Sheet Microsoft Excel Microsoft Access Oracle OBIEE Many more (not in this list)…..	Informatica PowerCenter (Windows) Informatica Cloud SSIS (SQL Integration Services) SQL Server Talend Data Studio Pentaho Kettle Oracle OBIEE Many more (not in this list)…..	Visual Studio C# C++ JAVA Python PHP PowerShell T-SQL (Using Linked Server)

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/