Building SQL Query for REST API Call using ZappySys ODBC Driver (Part 5 of 6)

This demo shows how to use build SQL queries for REST API calls using ZappySys API drivers. We will configure multiple options such as Data source, Authentication Parameters, Pagination, Error Handling and many more. We will use SQL query to read HubSpot API data as an example. This demo will show you how to read REST API data and load into Excel or other ODBC Compliant Apps (e.g. Power BI, Informatica, SQL Server, Crystal Reports / Business Objects, SSRS, SSIS)

What is ODBC PowerPack?
==========================
ODBC PowerPack is a collection of high-performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favorite Data Engine / Reporting / ETL tools (i.e. SQL Server, Power BI, Tableau, Qlik, SSRS, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. Our drivers can be called from your favorite programming languages such as JAVA, C#, Python etc.

Main Features of ODBC PowerPack
================================
ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files.
Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API)
Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp… )
Support very large JSON / XML files
Support for Caching engine to reduce query time
Support for retry options (To handle intermittent failures)
Support for API pagination options (Many ways to paginate large API response)
Tight integration with SQL Server (Call REST API from T-SQL Code)
Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS)
Support for popular programming languages such as JAVA, C#, Python

Other Useful Videos In this Series
==========================
(Part 1 of 6) ODBC PowerPack Intro - Loading JSON into Excel (Read from REST API URL or Files)

(Part 2 of 6) GET data from REST API / JSON Files using ODBC Driver - Intro

(Part 3 of 6) Calling REST API with OAuth 2.0 Authentication using ZappySys ODBC Driver

(Part 4 of 6) Calling REST API with Pagination (HTTP Request Loop) using ZappySys ODBC Driver

(Part 5 of 6) Building SQL Query for REST API Call using ZappySys ODBC Driver

(Part 6 of 6) POST data to REST API URL in Power BI (Use JSON / XML ODBC Drivers for Web API and Files)

Keywords:
========================
query rest api
excel rest api paginate
excel rest api loop
excel rest api get call