Forum Discussion

Sylvain_C's avatar
Sylvain_C
Regular Visitor
3 years ago
Solved

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

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

1 Reply