How to generate Access Token

[Rookie_2022]

Hello all,

I am a rookie to access API using Power bi. Here I have:

Cilent Key: ABC

Cilent Secret: XYZ

API address: https://api.maersk.com/customer-identity/oauth/v2/access_token

How could I generate the "Access Token" using power query?

Thanks.

[v-venuppu]

Hi @Rookie_2022 ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @Rookie_2022 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-venuppu]

Hi @Rookie_2022 ,

Thank you @lbendlin for the Prompt Response.

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[lbendlin · Accepted solution]

Please do not publish your credentials on the interwebs.

As you can probably appreciate it is nearly impossible to help with API queries without access to said API  (which you should not provide for understandable reasons)

Consult the documentation of your API. In your case the API requires an API Key.  There is an example for that in  https://learn.microsoft.com/en-us/powerquery-m/web-contents

Use tools like Postman to figure out the mechanics of your call and then implement that in Power Query.

[Rookie_2022]

Hi @lbendlin 

Have used Postman and get the access token successfully. But when it comes to power query, it always ask to provide credentials. Don't know what the problem is.

[Rookie_2022]

Hello all,

I am a rookie to access API using Power bi. Here I have:

Cilent Key: c0Hx1TnuvdA5OQrT

Cilent Secret: c0Hx1TnuvdA5OQrT

API address: https://api.maersk.com/customer-identity/oauth/v2/access_token

How could I generate the "Access Token" using power query?

Thanks.

[lbendlin]

You may need to provide an API Key.  Please follow the example in the documentation.