In the Part 1 of the tutorial series, we walked you through 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 into 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.
Feel free to add an as many endpoints as you like to the REST config. Once you have added all the endpoints, you can reconnect, and Autonomous REST Connector will sample, normalize and make the endpoints available as tables for you to query using SQL.
In the next tutorial, we will walk you through on advanced configuration options in REST Config file to let you customize the connectivity as you need. If you have any questions or issues, please feel free to talk to us.