Was able to solve this issue. It appears that i messed up API whitelisting after disabling it, it now works.
Connecting an API with basic authentication to Azure Data factory fails.
I need to extract data to Azure data factory using an API. I have been able to extract data from this API by using Insomnia so i know that the API does work and respond. But this doesn't work in Azure data factory. When i get to the I get to the screen where i can assign the data into columns i get errors saying that my API credentials are wrong.
I have tried both anonymous and basic to verify my API but both don't work.
When i connect to insomnia is use the following auhtorization:
The authentication is as following:
Basic username:password
note that this username:password is encoded in 64.
How do i use these credentials in Azure data factory without getting this error message:
The HttpStatusCode 401 indicates failure. Request URL: <MYURL> Response payload:{"ErrorCode":"0x1006","Description":"API Authentication Failed."} Activity ID: c9cfdb5e-4d1c-4852-a9c3-94a3877ef129
1 additional answer
Sort by: Most helpful
-
Fatih 191 Reputation points
2021-11-19T22:19:11.16+00:00 Dear @HimanshuSinha-msft
Thank you for answering, i am unable to connect to postman i don't know why. When i use the same credentials as i use in Insomnia i get this error :
Would you know what i am doing wrong ? Could that mistake be the reason why my Azure Data factory is not connecting ? Could you please help me out ?
Thank you for your time.
Kind Regards
Fatih