I am trying to use Azure HTTP Linked services to connect an API which uses just a username and no password for basic auth. The password input is mandatory in Azure. Anything i can do?

Hi TeriTech03 , Welcome to Microsoft Q&A platform and thanks for posting your question here. I understand that you are trying to use HTTP linked service within ADF pipeline with basic authentication and the API is asking for the password. Please let me know if that is not the correct understanding. Kindly try using a dummy password in the password field to connect to the HTTP Linked services and see if it works. The API you are trying to connect to uses basic authentication with just a username, so the password field is not used. You can use any value for the password field in Azure HTTP Linked services, as long as it is not empty. For more details on HTTP connector , kindly check the documentation: Copy data from an HTTP endpoint by using Azure Data Factory or Azure Synapse Analytics Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou

Azure HTTP Linked service ADF Username only no password

Accepted answer

AnnuKumari-MSFT 30,676 Reputation points Microsoft Employee

2023-05-23T10:39:31.6233333+00:00

Hi TeriTech03 ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

I understand that you are trying to use HTTP linked service within ADF pipeline with basic authentication and the API is asking for the password. Please let me know if that is not the correct understanding.

Kindly try using a dummy password in the password field to connect to the HTTP Linked services and see if it works. The API you are trying to connect to uses basic authentication with just a username, so the password field is not used. You can use any value for the password field in Azure HTTP Linked services, as long as it is not empty.

For more details on HTTP connector , kindly check the documentation:

Copy data from an HTTP endpoint by using Azure Data Factory or Azure Synapse Analytics

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou
Please sign in to rate this answer.

1 person found this answer helpful.
TeriTech03 21 Reputation points

2023-05-23T11:55:27.8866667+00:00

Thank you for your assistance but im getting 401 error unauthorized when i use a dummy password and try to preview the data. The same username working perfectly in Postman

AnnuKumari-MSFT 30,676 Reputation points Microsoft Employee

2023-05-24T07:53:13.3333333+00:00

Hi TeriTech03 ,

Thanks for the updates. I am checking internally on this.

AnnuKumari-MSFT 30,676 Reputation points Microsoft Employee

2023-06-03T01:14:58.69+00:00

Hi TeriTech03 ,

This is the response I got from the internal team:

"Unfortunately, it looks like we assume that nobody would ever set up a username/password situation that did NOT require a password. We do not support being able to send an empty password field - which is presumably what this API requires.

Can you ask the source team to configure the API to have a different username that actually has a password?

I would have suggested using AzureKeyVault to provide an empty password, but there seems to be no way to store an empty string as a secret."

Kindly accept the answer by clicking on Accept answer button. Thankyou

AnnuKumari-MSFT 30,676 Reputation points Microsoft Employee

2023-06-07T09:32:29.7466667+00:00

Hi TeriTech03 ,

Just checking in to see if the above answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'
Sign in to comment

Azure HTTP Linked service ADF Username only no password

0 additional answers