Power Query Custom Connector

[AakashMarasini]

Hello Developers,
I am trying to develop the custom connector using M Language with the implementation of oAuth2.0 authentication.
Previously, clientId and clientSecret was accessed from the respective file as:

client_id = Text.FromBinary(Extension.Contents("Client_ID.txt"));
client_secret = Text.FromBinary(Extension.Contents("Client_Secret.txt"));

Now, I am facing trouble to implement the new scenario where user must need to enter the clientId and clientSecret in the parameter to have authentication rather than reading from the respective files.

I have developed the simple parameter UI.

Testing_Type=type function(

   client_id as (type text meta[
   DataSource.Path=false,
  Documentation.FieldCaption ="Client_id"

]),
   client_secret as (type text meta[
   DataSource.Path=false,
   Documentation.FieldCaption ="Client_Secret"
])

) as table meta[
        Documentation.Name = Extension.LoadString("DataSourceLabel")
];

How to read those values entered by user?

Thank You!
 #powerQuery #CustomConnector #powerbi

[lbendlin]

Your requirement is outside the design envelope for custom connectors.

Custom Data Connectors and You | Ben Gribaudo

Handling authentication for Power Query connectors - Power Query | Microsoft Learn