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

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

AzureDiary

All about Azure

Mohit Gupta

Written by

Integration Developer works on Azure , DevOps , BizTalk. Contact : mohit.e.gupta@gmail.com

AzureDiary

All about Azure

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade