How to access AKENEO REST API WITH OAuth 2.0 ACCESS TOKEN with power Query

[Sylvain_C]

Hello everyone,

I am trying to access AKENEO REST API WITH OAuth 2.0 ACCESS TOKEN with power Query and after a long day of looking for the solution myself reading a lot of articles about the subject I have to say I’m dry on this one 😊

Here is the documentation I am using from https://api.akeneo.com/documentation, my PIM version is V5 :

here is my M code :

As far as I understood:

• I encoded the “client_id:secret” in B64 to fill the Authorization header
• I try to do a POST so I use Content in the url
• I specify the header “Content-Type” as “application.json” and I send Json format value in the postData
• I use anonymous authentication with Power BI considering that the authentication informations are imbembed into the url

I suppose that there is something wrong here but I can’t figure it out …

If you can help me on this one I would be grateful, also I am very interested in understanding what’s wrong here so don’t hesitate to explain !

Regards

Sylvain CHARLETY

[v-cgao-msft · Accepted solution]

Hi @Sylvain_C ,

Please follow the body of the document example. 

excel - Power Query, make http POST request with form data

POST Requests in Power Query

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum