Azure Logic App for creating an API for SQL DB. - CloudFronts

Azure Logic App for creating an API for SQL DB.

How to create Logic App in Azure Portal

Step 1: Create a new resource and Select Logic App services from Integration section.

Step 2: Enter the relevant Details for your Logic App and click on Create.

How to create API for Azure SQL DB using Azure Logic App

Step 1: Go to Logic App Designer and select a Blank Template > Select HTTP request Block and click save to generate GET URL.

Step 2: Select Method as GET.

Step 3: Attach a SQL Get Rows Block to the HTTP Request Block and Select the SQL Server Authentication Mode and enter the required fields. Later, Select the fields as shown below for your Azure SQL DB.

Step 4: Select a Response Block and attach it to Get Rows Block and select the values as shown below.

Note: After Completion the logic App looks like below:

Step 5: Test the GET URL in POSTMAN.

Share Story :