AutomoxAutomox

Having issues connecting PowerBI to Automox API

Ivan
August 27, 2022 at 1:20 pm UTC

I am trying to get powerBi to pull data from:
https://api.wifisensorcloud.com/


I have been going over all the api documentation and reviewing powerbi support forums and I cannot get powerbi to pull the JSON

The supplier have given me the API Key, but I get the following error: “A web API key can only be specified when a web API key name is provided”

BELOW ARE THE INFORMATION FROM SUPPLIER

Connecting to the API The 5 services are hosted at:

https://api.wifisensorcloud.com/Users.svc

https://api.wifisensorcloud.com/Locations.svc

https://api.wifisensorcloud.com/Devices.svc

https://api.wifisensorcloud.com/Sessions.svc

https://api.wifisensorcloud.com/Lookups.svc

Connections using any protocol other than https (such as http) will be rejected. Requests for data should use the GET method with parameters supplied in a query string whereas data submissions/updates should use the POST method with parameters supplied in a JSON object. Examples of each of these methods are on the next pages.

 

 

This discussion is archived and closed to replies. Continue it in the Automox Community Slack.

Discuss on Slack

Replies (1)

BrandonG-AutomoxAugust 30, 2022
#1

Hi @Ivan ,
Have you had the opportunity to check out this post where another user encountered similar issues?
 

https://community.automox.com/api-integrations-130/having-issues-connecting-powerbi-to-automox-api-275

 

Please also note that we can only advise you on how to connect the Automox API to PowerBI and would not be much help for other tools or software such as wifisensorcloud.

Cheers,
Brandon