Custom Connector hard-code values for basic Auth

[ljaos67]

Hello everyone,

I made a custom connector in M. I want to hard-code the credentials for the basic authorization I set up but It still prompts me to set them up. Is there a way to do this?

Here is the code at present state:

CustomConnector = [
TestConnection = (dataSourcePath as text) => { "CustomConnector.Contents", dataSourcePath},
Authentication = [
UsernamePassword =
[Username = "username1",
Password = "password1"],
],
Label = "CustomConnector"
];

[bhelou]

To hard-code the credentials for the basic authorization, you can use the CredentialConnectionString property in the custom connector M code. Here is an example of how you can modify your existing code to include the credentials:

CustomConnector = [
TestConnection = (dataSourcePath as text) => { "CustomConnector.Contents", dataSourcePath},
Authentication = [
UsernamePassword =
[
CredentialConnectionString = "Basic " & Text.ToBinary("username1:password1"),
AuthenticationType = "Basic"
]
],
Label = "CustomConnector"
];

By using the CredentialConnectionString property, you can provide the credentials in the format of "Basic " & Text.ToBinary("username:password"). The AuthenticationType is set to "Basic" to indicate that the credentials are for basic authorization.

Note that you should replace the hardcoded credentials with a secure way of storing credentials, such as using an environment variable or key vault.

[ljaos67]

Thank you for your answer, however I am still prompted to input credentials when I run the connector. I want to have the credentials pre-set.