CODEWITHSUNDEEP
azureauthorizationazure-data-factoryazure-table-storage
VivekAnandChakravarthy
VivekAnandChakravarthy

Reputation: 719

Listing the Tables in the Storage Account using ADF Web Activity is failed with an authorization error

i have added the parameter source storage account sas token as shown below:

enter image description here

Then I added web activity to list the tables of the storage account where this account has only 500 tables but i'm getting authentication failed error:

enter image description here

Web Activity - ListTables

URL: @concat('https://srcstoreacc131.table.core.windows.net/Tables', pipeline().parameters.sourceSAS)
Headers: Accept-application/json # Add as dynamic content value
Method: GET

Error:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
  <code>AuthenticationFailed</code>
  <message xml:lang="en-US">Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.
Time:2024-04-23T12:32:02.1385780Z</message>
</error>

Upvotes: 0

Views: 59

Answers (1)

Bhavani
Bhavani

Reputation: 5317

Make sure you have provided correct SAS. While generating SAS give following permission as shown below:

enter image description here

Provide web activity URL as mentioned below:

@concat('https://<storageAccountName>.table.core.windows.net/Tables',pipeline().parameters.SAS)

Configure web activity as shown below:

enter image description here

You will be able to list the tables successfully as shown below:

enter image description here

For more information you can refer to the MS document.

Upvotes: 1

Related Questions