Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
];
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.
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.