Test and explore API endpoints

Overview

Use the Etlworks Explorer to test the Connection to a web service and explore API endpoints.

Step 1. Create an HTTP Connection to the web service.

Step 2. Create a Format for the response. The most commonly used Formats are JSON, XML, and CSV.

Step 3. Open the Etlworks Explorer, select the Connection created in Step 1, and link it to the Format created in Step 2.

Step 4. Explore the metadata (endpoints and fields), view data in a grid, query data, and discover dependencies using SQL.