逻辑应用程序使用HTTP和托管身份验证查询Azure表

Question

我正在尝试使用HTTP连接器查询Azure表，但未成功。

根据此文档，Azure表现在可以进行托管身份验证：https://docs.microsoft.com/en-us/azure/storage/tables/authorize-managed-identity

我已使用PowerShell作为文档建议，授权azure表中消费逻辑应用程序的托管标识。https://docs.microsoft.com/en-us/azure/storage/tables/assign-azure-role-data-access?tabs=powershell

New-AzRoleAssignment -ObjectID xxxxxxxxxxxxxxxx `
 -RoleDefinitionName "Storage Table Data Contributor" `
 -Scope  "/subscriptions/<subscription>/resourceGroups/<resource-group>/providers/Microsoft.Storage/storageAccounts/<storage-account>/tableServices/default/tables/<table>"

然后在logic应用程序中，我填写了请求，如中所述：https://docs.microsoft.com/en-us/rest/api/storageservices/query-tables#request-标题

运行失败，禁用缺少授权标头。

"body": {
     "odata.error": {
         "code": "AuthenticationFailed",
         "message": {
             "lang": "en-US",
             "value": "Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.\nRequestId:8d5dbe66-d002-0005-26e6-45da23000000\nTime:2022-04-01T16:35:57.2213453Z"
         }
     }
 }

有什么想法吗？

Answer 1

因此，基本上通过下面的设置，我能够通过HTTP成功查询Azure表

标题：

结果：