These Power Queries will perform requests against the ConnectWise ecosystem REST APIs.
- Handles authentication to the ConnectWise Manage, Automate, RMM REST APIs
- Handles retrieving access token from ConnectWise Automate
- Automatically manages API request paging on applicable APIs, no action needed to retrieve over 1000 records
- Option to automatically expand all return columns that contain records from applicable APIs
- Support for any condition, filtering, sorting that is applicable to the API
- Handles query responses with null value fields
- Able to be pushed to Power BI online and have the dataset automatically refresh
Please refer to USAGE.md.
ConnectWise-PowerBI is licensed under the MIT license.
The basis of this function is based on the work that Quinntin Comer did for this article.