CODEWITHSUNDEEP
azureazure-data-factory
Gopi Arumugam
Gopi Arumugam

Reputation: 27

HttpRequestFailedWithClientError Azure Datafactory

ErrorCode=HttpRequestFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with client error, status code 404 NotFound, please check your activity settings. If you configured a baseUrl that includes path, please make sure it ends with '/'. Request URL: https://gyter.sharepoint.com/sites/czxzd/SecAB/_api/web/GetFileByServerRelativeUrl('/sites/casc/ytu/dasasda/BMCSL/htsdL.xlsx')/$value.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (404) Not Found.,Source=System,'

I have tested the conenction in the source and sink, both are success.

Also, I am using GetBearer token, which is also successfull.enter image description here

Upvotes: 1

Views: 138

Answers (1)

Bhavani
Bhavani

Reputation: 5317

enter image description here

Make sure you have added additional header which will retrieve token from web activity. Even if source and sink test successful, you may get above error, If you don't add additional header.

Add additional header using below in source dataset which is having http linked service:

Additional headers: @{concat('Authorization: Bearer ', activity('<Web-activity-name>').output.access_token)}

enter image description here

After adding Additional headers, debug the pipeline, it will execute successfully.

enter image description here

For more clarification you can refer below links:

Upvotes: 0

Related Questions