Skip to main content

Having issues connecting PowerBI to Automox API

  • November 16, 2021
  • 7 replies
  • 1991 views

Forum|alt.badge.img

I am trying to get powerBi to pull data from:
https://console.automox.com/api/servers
I have been going over all the api documentation and reviewing powerbi support forums and I cannot get powerbi to pull the JSON
I get the following error: A web API key can only be specified when a web API key name is provided
image

I have tried using the API key as a username, doesn’t appear to work there either.
Has anyone gotten PowerBi to successfully pull data from the Automox web api, and how did you do it?

Forum|alt.badge.img
  • Novice
  • January 25, 2022

I could be totally wrong, but isn’t the endpoint: 
https://console.automox.com/api/servers?o=[orgID]&page=0&limit=500 [o=OrgID]

 


jack.smith
Forum|alt.badge.img+1

This process works

Once you build the initial query you need to add to accommodate for the # of assets in your organization. Using the page # as the different part of each query. Perhaps there is a better way?

 


jack.smith wrote:

This process works

Once you build the initial query you need to add to accommodate for the # of assets in your organization. Using the page # as the different part of each query. Perhaps there is a better way?

 

Hi, is there a space between “Bearer” and the API key generated from Automox?

What is the purpose of putting Bearer?


jack.smith
Forum|alt.badge.img+1
bryan.singh wrote:

Hi, is there a space between “Bearer” and the API key generated from Automox?

What is the purpose of putting Bearer?

 

A space was between “Bearer” and the API key generated from Automox. 

The purpose of adding Bearer is to tell the interpreter, in this case Power BI, to use the HTTP Authorization Scheme “Bearer” when authenticating. https://developer.automox.com/openapi/axconsole/overview/#section/Authentication


Thank you for the quick reply. It does seem to work!


Afonso_Alves_31
Forum|alt.badge.img

I don’t see an authorization field on my powerbi configuration, am I looking the wrong place?

 

 

 


jack.smith
Forum|alt.badge.img+1
Afonso_Alves_31 wrote:

I don’t see an authorization field on my powerbi configuration, am I looking the wrong place?

 

 

The value would need entered manually.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings