Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Sharkman60
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.

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

 

Any help will be greatly appreciated.

3 REPLIES 3
JosephTurner
New Member

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

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

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.