Connecting OAUTH2 Authorization API

[Rookie_2022]

Dear,

I am having difficulty in using desktop power query to connect to OAUTH2 API. I am asked to request the access token to below server:

curl --request POST \
--url https://api.maersk.com/customer-identity/oauth/v2/access_token \
--header 'Cache-Control: no-cache' \
--header 'Consumer-Key: {appConsumerKey}' \
--header 'Content-Type: application/x-www-form-urlencoded' \
--data grant_type=client_credentials \
--data client_id={appConsumerKey} \
--data client_secret={appClientSecret}

Then using the "Access Token" to Request API.

Anyone knows how to make the connection?

[lbendlin · Accepted solution]

Please follow the documentation. Use Header and Content parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-2

Note that most likely you will need to create a custom connector if you want to refresh in the service.

[Rookie_2022]

Hi @lbendlin 

Is there any customs connector example for reference? I need to refresh the data everyday. 

Thanks.

[lbendlin]

Creating your first connector - Hello World - Power Query | Microsoft Learn