CODEWITHSUNDEEP
azure-storageazure-logic-appsazure-table-storageazure-managed-identity
Jorge Rodrigues
Jorge Rodrigues

Reputation: 99

Logic App query Azure Table using HTTP and Managed Identity authentication

I am trying to query Azure Table using the HTTP connector without success.

According to this document managed identity authentication is now possible for Azure Table: https://learn.microsoft.com/en-us/azure/storage/tables/authorize-managed-identity

I have authorized the managed identity of the consumption logic app in the azure table using PowerShell as the documentation sugests. https://learn.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>"

Then in the logic app I've filled the request as documented in: https://learn.microsoft.com/en-us/rest/api/storageservices/query-tables#request-headers

Screenshot of the configs

The run fails with forbidden missing authorization header.

"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"
         }
     }
 }

Any ideas?

Upvotes: 0

Views: 652

Answers (1)

Jorge Rodrigues
Jorge Rodrigues

Reputation: 99

So Basically with the setup bellow I was able to successfully query the Azure Table over HTTP

Headers:

enter image description here

Result:

enter image description here

Upvotes: 2

Related Questions