Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Connecting to Akixi API using Power Query

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.


Any help will be greatly appreciated.


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.  

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.