Azure Logic App : Call REST API and Save Data in Azure SQL
Nov 7 · 2 min read
Create a logic apps for receiving a json array (Employee records) using Rest end point and save each record in Azure SQL database .

Create a Azure SQL database and database server.

3 resources created in your resource group now

Create Table in your database using Azure Query editor


Design Logic App using a blank logic app

We are using HTTP end point as trigger so that you can trigger or call your logic apps through a URL.

Employess sample JSON Payload
“emailAddress” : “romin.k.irani@gmail.com”
Next choose foreach control


Now add action inside foreach loop (SQL Connection).

Map json with Table Column

It will generate the end point for your logic app .

Test Logic app using postman (must set content type as json ).



