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 :

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close