Connecting to Akixi API using Power Query

[Sharkman60]

Hi All

I'm new to exploring API's and I'm trying to import data from the Akixi API to pull in telephony data. However I'm having a problem trying to get it to connect as I first need to create a service session and then authenticate the session using basic authentication (username / password). Once the session is authenticated, it must be used as JSESSIONID cookies authentication with all requests. The HTTP method is POST.

Can anyone help point me in the right direction so I can at least start trying to pull in data. Below is a link to the Dev portal explaining about the authentication process.

https://akixi.dev/api/external/rest/v1/endpoints/auth/auth.html#create-session

Any help will be greatly appreciated.

[JosephTurner]

Hi Sharkman, did you find out how to link Akixi and Power Bi in the end?

[lbendlin]

Handling authentication for Power Query connectors - Power Query | Microsoft Learn

[Sharkman60]

Thank you for this. I've been readin through the link but I can't see anything about where you have to create a session first. For this API I need to create the sessionID and then pass this through as a JSESSION cookie to the login step where I can use the appropriate authentication method. Are you able to give an example code of how I would create the session and obtain the session ID token to then pass into the login step.