In Part 1 and Part 2 of the tutorial series, we learned how you can sample and connect to multiple endpoints and query the data using SQL, without having to write a line of code. If you are new, we would recommend you to start from Part 1 of the tutorial series.
When you use Autonomous REST connector, it strives to create correct schema information such as table name, column names, data types and assign a primary key, which you shouldn’t have any problem using. But, as you start querying the API using SQL, there can be times where you might want to rename a table or field name to a value that avoids confusion for end users or change the data type for a certain field to a type that you think is appropriate or change the primary key to a different field in the generated table. In this tutorial, we will walk you through how to do this in a way that makes sense to you or your end user.
Feel free to play with the REST config file as per your needs and if you have any questions or issues, please contact us. We will be happy to help you. In the next tutorial, we will look at how you can configure Autonomous REST Connector to page through all the results from the endpoint beyond the first page.