Forum Discussion
Connecting Power BI to a Web Service
The documentation for generating an API key for IT Glue can be found here:
https://kb.itglue.com/hc/en-us/articles/236404927-Getting-started-with-the-IT-Glue-API
The endpoints for the service can be found here:
https://api.itglue.com/developer/
To connect:
- In Power BI select Get Data > Other > Web
- Click Advanced. In URL parts enter https://api.itglue.com/<endpoint> where <endpoint> is the name of one of the items from the list. For example https://api.itglue.com/operating_systems
- For HTTP Request header parameters enter x-api-key in the left box and your generated API key value in the right box. Hit OK. Use Anonymous connection.
- Right click on the file in the query editor. Select JSON. Click List. Right Click List and convert to a table. Expand table as needed.
Thank you for the guidance to connect, that was helpful. Any suggestions on how to pull more than 50 rows at a time?
That 50 row limit is a bummer, any solution for this?
Limit is on the API side for IT Glue. I was able to overcome the limit by adding "page[size]=1000" to my URL string as shown in this article, but they limit it to 1000 per query. Use the filters document to set filters on the query so you get the correct data that you need.
https://support.itglue.com/hc/en-us/articles/360004934057-Pagination-in-the-IT-Glue-API