topic Re: Graph API queries for managed Devices in Developer

Graph API queries for managed Devices

Anonymous — Wed, 14 Apr 2021 07:29:21 GMT

Hi Community!

to get information about managed devices we are using Graph API Queries like:

https://graph.microsoft.com/v1.0/deviceManagement/managedDevices?$select=id,deviceCompliancePolicyStates

In Power Bi one can then expand "deviceCompliancePolicyStates" colmn and process the data.

Now we have an request to store this data permanently in the database with the bunch of other data.

I`ve noticed that exactly the same query didn`t return "deviceCompliancePolicyStates" data if i use it via web request ( for example in PowerShell or Graph Explorer - Microsoft Graph). I know its possible to retrieve the same data for every single device using:

https://graph.microsoft.com/v1.0/deviceManagement/managedDevices/{deviceId}/deviceCompliancePolicyStates

but it takes quite a while to process all data. $expand don`t work as well

So the question is:

is it possible to retrieve exactly the same data from the query via web request, as they are displayed in Power BI?

Re: Graph API queries for managed Devices

lbendlin — Tue, 13 Apr 2021 17:55:13 GMT

Are you using the Graph Security third party connector, or standard Web.Contents calls? Have you tried ODATA instead?

Re: Graph API queries for managed Devices

Anonymous — Wed, 14 Apr 2021 07:38:37 GMT

Hello @lbendlin ,

In Power BI we are using OData.Feed and we get all data we want. The problem is, that using exactly the same query not in Power BI, but in Powershell ( via Invoke-WebrRequest) we get less attributes. So how is that possible, that the same query retrievs different data, depending on method we are using for calls?

Re: Graph API queries for managed Devices

lbendlin — Wed, 14 Apr 2021 11:25:07 GMT

Most likely Power Query is automatically expanding the lookup fields. In Powershell you have to do that manually.