Calling REST API with Pagination (HTTP Request Loop) using ZappySys ODBC Driver (Part 4 of 6)
In this part you will learn how to paginate REST API requests using ZappySys ODBC Drivers. For more information check this link https://zappysys.com/products/odbc-po...
This demo shows how use ZappySys API drivers to read data from REST API which requires multiple requests using pagination techniques. We will use HubSpot API as an example and read data from REST API 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)
• ODBC PowerPack Intro - Loading JSON i...
(Part 2 of 6) GET data from REST API / JSON Files using ODBC Driver - Intro
• GET data from REST API / JSON Files u...
(Part 3 of 6) Calling REST API with OAuth 2.0 Authentication using ZappySys ODBC Driver
• Calling REST API with OAuth 2.0 Authe...
(Part 4 of 6) Calling REST API with Pagination (HTTP Request Loop) using ZappySys ODBC Driver
• Calling REST API with Pagination (HTT...
(Part 5 of 6) Building SQL Query for REST API Call using ZappySys ODBC Driver
• Building SQL Query for REST API Call ...
(Part 6 of 6) POST data to REST API URL in Power BI (Use JSON / XML ODBC Drivers for Web API and Files)
• POST data to REST API URL in Power BI...
Keywords:
========================
rest api pagination
excel rest api paginate
excel rest api loop
excel rest api get call