使用 ARM 模板/powershell 部署逻辑应用 [英] Deploying a logic app using ARM templates/powershell

问题描述

如何部署调用 SQL DB 存储过程的逻辑应用程序?我已经尝试了以下操作.

How can I Deploy a logic app that calls a SQL DB stored procedure? I've tried the following action.

    "actions": {
            "Execute_stored_procedure": {
              "conditions": [ ],
              "inputs": {
                "body": null,
                "host": {
                  "api": {
                    "runtimeUrl": "https://logic-apis-northcentralus.azure-apim.net/apim/sql"
                  },
                  "connection": {
                    "name": "<sql connection string>"
                  }
                },
                "method": "post",
                "path": "/datasets/default/procedures/@{encodeURIComponent(encodeURIComponent(string('<stored-procedure-name>')))}"
              },
              "type": "apiconnection"
            }
          }

当我部署此模板时，逻辑应用程序已创建，但它抛出错误或 SQL 连接操作未显示在设计视图中.我在这里做错了什么?arm目前支持调用SQL Stored Proc的Logic App吗?

When I deploy this template, the logic app get's created but it's throwing errors or the SQL Connection action is not showing up on the design view. What am I doing wrong here? Is Logic App for calling SQL Stored Proc supported by arm currently?

推荐答案

这里是 LogicApp ARM 模板 + 'connections' 资源的示例模板
https://blogs.msdn.microsoft.com/logicapps/2016/02/23/deploying-in-the-logic-apps-preview-refresh/
https://github.com/jeffhollan/logicapps-deployments/blob/master/ftp_to_blob.json

Here is a sample template for LogicApp ARM template + 'connections' resource
https://blogs.msdn.microsoft.com/logicapps/2016/02/23/deploying-in-the-logic-apps-preview-refresh/
https://github.com/jeffhollan/logicapps-deployments/blob/master/ftp_to_blob.json

这篇关于使用 ARM 模板/powershell 部署逻辑应用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！