topic Connecting to Akixi API using Power Query in Developer

Connecting to Akixi API using Power Query

Sharkman60 — Mon, 21 Aug 2023 13:09:50 GMT

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.

Re: Connecting to Akixi API using Power Query

lbendlin — Wed, 23 Aug 2023 01:01:07 GMT

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

Re: Connecting to Akixi API using Power Query

Sharkman60 — Wed, 23 Aug 2023 14:29:17 GMT

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.

Re: Connecting to Akixi API using Power Query

JosephTurner — Wed, 10 Jan 2024 14:45:03 GMT

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