Forum Discussion
How to generate Access Token
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.
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.
7 Replies
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.
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.
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.
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.
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.
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.
