topic Re: Connecting OAUTH2 Authorization API in Developer

Connecting OAUTH2 Authorization API

Rookie_2022 — Fri, 20 Dec 2024 09:08:13 GMT

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?

Re: Connecting OAUTH2 Authorization API

lbendlin — Fri, 20 Dec 2024 15:08:50 GMT

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.

Re: Connecting OAUTH2 Authorization API

Rookie_2022 — Sun, 22 Dec 2024 14:47:52 GMT

Hi @lbendlin

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

Thanks.

Re: Connecting OAUTH2 Authorization API

lbendlin — Sun, 22 Dec 2024 16:07:41 GMT

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