在Azure Logic App API连接上使用Azure密钥库

Question

Answer 1

一旦创建，连接API将不会输出任何敏感信息
使用ARM模板，您可以创建API连接，但当您旋转凭据时，它不会更新连接详细信息，您必须重新部署模板。

{
  "$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "sqlConnectionAPIName": {
      "type": "string",
      "metadata": {
        "description": "The name of the connection api to access the service bus namepsace."
      }
    },
    "sqlserverName": {
      "type": "string",
      "metadata": {
        "description": "The Name of the SQL Server instance."
      }
    },
    "databaseName": {
      "type": "string",
      "metadata": {
        "description": "The name of the database."
      }
    }
  },
  "variables": {},
  "resources": [
    {
      "type": "Microsoft.Web/connections",
      "name": "[parameters('sqlConnectionAPIName')]",
      "apiVersion": "2018-07-01-preview",
      "location": "[resourceGroup().location]",
      "scale": null,
      "properties": {
        "displayName": "[parameters('sqlConnectionAPIName')]",
        "parameterValues": {
          "server": "[reference(resourceId('Microsoft.Sql/servers', parameters('sqlserverName')), '2015-05-01-preview').fullyQualifiedDomainName]",
          "database": "[parameters('databaseName')]",
          "username": "[reference(resourceId('Microsoft.Sql/servers', parameters('sqlserverName')), '2015-05-01-preview').administratorLogin]",
          "password": "[reference(resourceId('Microsoft.Sql/servers', parameters('sqlserverName')), '2015-05-01-preview').administratorLoginPassword]"
        },
        "api": {
          "id": "[concat('subscriptions/', subscription().subscriptionId, '/providers/Microsoft.Web/locations/', resourceGroup().location, '/managedApis/sql')]"
        }
      },
      "dependsOn": []
    }
  ]
}

Answer 2

据我所知，Azure逻辑应用程序无法访问门户中api连接中的密钥保管库。如果你想访问密钥保管库，你可以使用rest api来访问它。您需要在逻辑应用程序中启用msi（下面的链接显示我们可以在“工作流设置”中进行msi修改，但目前它已经更改，我们需要在逻辑应用程序的“身份”边栏选项卡中启用它），并使用超文本传输协议操作访问您的金库钥匙。

有关更多信息，请参阅此链接：https://devkimchi.com/2018/10/24/accessing-key-vault-from-logic-apps-with-managed-identity/