Sophos Central and Power BI query via API

Hi, do you have expierence with Power BI queries to Sophos Central API? I  would like to have a query which client hostnames are protected, inactive, online ...

I've created token in Sophos Central and also have the clientID and the secretID but I don't know how to start. Maybe somebody of can share the query for PowerBI. Slight smile

Regards
Patrik