REST API as Data Source in Query Builder

You are viewing archived documentation for Data Trust v2024.06 (previous version).
Go to the latest v7.6 documentation →

REST API as Data Source in Query Builder:

This document explains a new profile “REST API” that was added to Query builder. Now, you can request and extract the data using a REST API through GET method. Please go through the following steps below:

1. Please go through the Query Builder as shown below:

1. Now, please add a sample “Request URL” (https://jsonplaceholder.typicode.com/posts) through GET method and kindly make sure to toggle “OFF” the SSL Certification from settings tab to get the JSON Data as shown below:

1. Please click on the “Get JSON Data” button to extract the data from the above requested sample REST API URL and you will get the extracted data as shown below:

1. Click on select button and save the API output data as shown below:

1. You can also preview the extracted data by clicking the “Preview Data” button as shown below:

1. Now please click on the save button and finally save the extracted output API data (assume “Rest API Sample Test” here) as shown below:

1. You can now use this extracted REST API in any Query Chain. Please open a new Query Chain as shown below:

1. As a next step, click on the “Queries” from data source as shown below:

1. Now Double Click the “Queries” widget, add the previously extracted REST API (Rest API Sample Test) data and click on “Select” button as shown below:

1. You can also preview the data by clicking on the “Preview Data” button as shown below:

1. Please add an RD output widget from the “output” tab as shown below:

1. As soon as you add an RD output, you can now execute and you will get the result as shown below:

“Note: You can also use REST API and run it in existing queries using different FDR and Validation scenarios”

REST API in an FDR Scenario

REST API in Scenario Validation