Connecting an API with basic authentication to Azure Data factory fails.

asked 2021-11-16T12:34:52.287+00:00 by
Fatih 191 Reputation points

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:
149824-image.png

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,135 questions
{count} votes

Accepted answer
  1. answered 2021-11-24T08:24:43.053+00:00 by
    Fatih 191 Reputation points

    Was able to solve this issue. It appears that i messed up API whitelisting after disabling it, it now works.

    No comments

1 additional answer

Sort by: Most helpful
  1. answered 2021-11-19T22:19:11.16+00:00 by
    Fatih 191 Reputation points

    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 :
    150930-image.png

    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

    No comments