azure function activity in adf

Vinodh247 13,801

I am trying to read the file metadata from external storage SFTP by calling the credentials from secrets. I am receiving the following error can anyone say what should be issue here? az function or the storage credentials of sftp? I have checked the credentials and their SAS tokens they are active and not expired.

Operation on target Get_Metadata Files_ADLS failed: Call to provided Azure function 'Get_File_Details' failed with status-'BadRequest' while invoking 'POST' on 'https://xxxxxxx.azurewebsites.net' and message - 'ERROR in Operation returned an invalid status 'Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.'
ErrorCode:AuthenticationFailed'.

ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee

2022-10-20T16:55:02.973+00:00

Hi @Vinodh247 ,

Thank you for posting query in Microsoft Q&A Platform.

Where exactly you are facing issue? Are you using Azure function activity here? Is that azure function is HTTP trigger type? From error message it seems request is not correct. Kindly share more details on implementation to understand it better.
Vinodh247 13,801 Reputation points

2022-10-23T05:34:08.447+00:00

@ShaikMaheer-MSFT :

In one of my adf pipeline, we have an azure function called 'Get_Metadata Files', this will fetch the file details and pass on to the next (COPY) activity. When tried to run the pipeline, we are facing error on AZURE FUNCTION part. While the error may seem straight forward 'AUTHENTICATIONFAILED' but we have checked multiple times where the credentials are not wrong and not expired and the linked server test connection doesn't fail when hardcoding the username and password but only fails only when reading them from key vault. Also note that we are passing the credentials, linked servername and port as parameters.

Operation on target Get_Metadata Files_ADLS failed: Call to provided Azure function 'Get_File_Details' failed with status-'BadRequest' while invoking 'POST' on 'https://xxxxxxx.azurewebsites.net' and message - 'ERROR in Operation returned an invalid status 'Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.' ErrorCode:AuthenticationFailed'.

Share via

azure function activity in adf