Azure Logic Apps

Overview – Azure Logic Apps
Create cross-environment parameters in Azure Logic Apps workflow
Create a Http trigger-based workflow
Creating a Logic App that showcases the use of all variable types
Logic app workflow involves a string or JSON object created from multiple inputs of different data types
Logic App – Insert data into On-Prem SQL Server
Logic App workflow to retrieve data from SQL using a stored procedure
Workflow triggered by recurrence that connects to on-premises file systems in Azure Logic Apps
Logic App workflow for creating a file in SFTP with exception handling
Create or join parallel branches using workflow actions in Azure Logic Apps
Logic App workflow with a “For Each” loop that processes items sequentially
Logic App workflow that retrieves JSON data from an HTTP request and converts it into a CSV format
Create HTML table in Logic App workflow
A Logic App workflow that uses Filter array, Select and Join actions
JavaScript code inline in Azure Logic Apps workflow
Batching (aggregating) messages using batch receive and batch sender in a Logic App
Manage large messages in workflows by using chunking in Azure Logic Apps
Azure Logic Apps workflow- Handle throttling problems (429 – “Too many requests” errors)
Identify and resolve workflow failures in Azure Logic Apps
Monitoring the health and performance of Azure Logic Apps workflows
An overview of automating the deployment of Azure Logic Apps using Azure Resource Manager templates
Ensuring secure access and data protection for workflows in Azure Logic Apps
Effective Planning and Management of Costs for Azure Logic Apps
Encoding and decoding flat files in Azure Logic Apps workflows using Text and XML formats
Testing workflows with mock outputs in Azure Logic Apps
Delay and Delay until action in Azure Logic Apps
Invoke REST API endpoints within workflows using Azure Logic Apps
Use Liquid templates as maps in workflows to transform JSON to JSON/TEXT and XML to JSON/TEXT in Azure Logic Apps
Manage Azure resources and monitor expenses by creating automated tasks
Previous Lesson
Next Lesson

Logic App – Insert data into On-Prem SQL Server

Azure Logic Apps Logic App – Insert data into On-Prem SQL Server
To create a Consumption Logic App in Azure named ‘la-test-sql-02’ that uses an HTTP trigger with a POST method to insert data into an on-premises Microsoft SQL Server table.

Step-by-Step Guide

  1. Create the Logic App:
    • In the Azure Portal, navigate to Logic Apps and click Add.
    • Fill in the details, name the app la-test-sql-02, and choose the Consumption plan.
    • Click Create.
  2. Add HTTP Trigger:
    • Open your Logic App in the Logic App Designer.
    • In the Logic App Designer, search for HTTP and select the When_a_HTTP_request_is_received trigger.
    • Set the Method to POST.
  3. Set up On-premises Data Gateway:
  4. Add SQL Action:
    • After setting up On-Prem Data Gateway, click on New step and search for SQL Server.
    • Choose Insert row (V2).
    • Connect to your on-premises SQL Server using the Data Gateway.
  5. Save and Test:
    • Save your Logic App.
    • Use a tool like Postman to send a POST request to the HTTP trigger URL with the JSON payload.
Here's how your Logic App should look:
estudy247-la-test-sql-02

HTTP Request Payload

{
  "id": "123",
  "name": "Estudy247",
  "email": "estudy24by7@gmail.com"
}

You can download the logic app template from the estudy247 GitHub repository– la-test-http-02

Previous Lesson
Back to Course
Next Lesson
Post a comment

Leave a Comment

Scroll to Top