In the Part 1 of the tutorial series, we have walked you through on how you can connect to a REST API (Yelp) endpoint using Progress DataDirect Autonomous REST Connector and query the Yelp REST API using SQL. If you stumbled on this tutorial first, we would recommend you start with Part 1 of this tutorial series.
But we have only shown you how you can sample and connect to just one endpoint that Yelp REST service offers. Often, each REST API offers multiple endpoints from which you can get the data. In this tutorial, we will look in to how you can sample multiple endpoints and query them using a single database connection.
Let’s look at the 3 different endpoints that we are going to sample in this tutorial.
In the next tutorial, Query any REST API using JDBC quickly – Editing the auto generated schema (Part 3), we will walk you through on advanced configuration options in REST Config file to let you customize the schema as you need. If you have any questions or issues, please feel free to talk to us.