Back to Blog
1 min read

Azure Logic Apps for Enterprise Integration

Logic Apps excels at enterprise integration patterns - connecting systems that weren’t designed to talk to each other.

Common Integration Patterns

1. File Processing

{
  "definition": {
    "triggers": {
      "When_a_blob_is_added": {
        "type": "ApiConnection",
        "inputs": {
          "host": {"connection": {"name": "@parameters('$connections')['azureblob']['connectionId']"}},
          "method": "get",
          "path": "/datasets/default/triggers/batch/onupdatedfile",
          "queries": {"folderId": "/incoming"}
        }
      }
    },
    "actions": {
      "Parse_CSV": {"type": "Compose", "inputs": "@split(body('Get_blob_content'), '\\n')"},
      "For_each_row": {
        "type": "Foreach",
        "foreach": "@body('Parse_CSV')",
        "actions": {
          "Insert_to_SQL": {
            "type": "ApiConnection",
            "inputs": {"body": "@items('For_each_row')"}
          }
        }
      }
    }
  }
}

2. API Orchestration

HTTP Request → Get Customer → Get Orders → Get Shipments → Compose Response → HTTP Response

3. EDI/B2B Integration

With Integration Accounts:

  • X12 and EDIFACT message processing
  • Partner agreements
  • Schema validation
  • Map transformations

Retry Policies

{
  "type": "Http",
  "inputs": {"method": "POST", "uri": "https://api.example.com"},
  "retryPolicy": {
    "type": "exponential",
    "count": 4,
    "interval": "PT7S",
    "minimumInterval": "PT5S",
    "maximumInterval": "PT1H"
  }
}

Best Practices

  1. Use Standard tier for VNet integration
  2. Enable diagnostic logging
  3. Use managed identities for authentication
  4. Parameterize connection strings
  5. Implement idempotent actions

Logic Apps handles the complex plumbing of enterprise integration so you can focus on business logic.

Michael John Peña

Michael John Peña

Senior Data Engineer based in Sydney. Writing about data, cloud, and technology.