Azure Logic App : Call REST API and Save Data in Azure SQL

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 ).