Forum Discussion

Ferna's avatar
Ferna
Frequent Visitor
2 years ago

ODBC connector and OAuth flow

Hi all, I'm trying to customize a ODBC connector that require some parameters before starting an authentication flow. The parameters are specifically 3 as IdP endpoint, user, user-secret. These are ...
General Comment
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Ferna ,

 

If you are connecting to data from the API, you can consider using your own editing Web.Content function to write the parameters in the request header, and then do PQ customized data processing after you successfully get the data.

Web.Contents - PowerQuery M | Microsoft Learn

 

For example:

let     url = ...,     headers = [#"Content-Type" = "application/json"],     postData = Json.FromValue([x = 235.7, y = 41.53]),     response = Web.Contents(         url,         [             Headers = headers,             Content = postData         ]     ),     jsonResponse = Json.Document(response) in     jsonResponse

 

This is the related document, you can view this content:

Pass Parameters to Identity Providers (auth0.com)

Microsoft identity platform and OAuth 2.0 authorization code flow - Microsoft identity platform | Microsoft Learn

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Ferna's avatar
    Ferna
    Frequent Visitor
    2 years ago

    Hi Liu,

    I'm querying an OpenSearch database,  and the uses case is many users that has its credentials and IdP endpoint. They should insert the parameter manually if they authenticate with Oauth2, otherwise is required a compiling and build phase of ".mez" file for each of these users.  The IdP mostly is "static" but user and secret can vary significantly.