A Source Rest API that Loops a Parameter

[dkoziupa-ifc]

I'm trying to look for all PCs that have whichever software I choose.  As an example, if I select a particular app, I want to see which machine has that app installed.

Here is the rest API for finding the machine: List machines API - Microsoft Defender for Endpoint | Microsoft Learn

Here is the rest API for finding the software: List software - Microsoft Defender for Endpoint | Microsoft Learn

Here is the rest API for finding the software per machine: List devices by software - Microsoft Defender for Endpoint | Microsoft Learn

       GET /api/Software/{Id}/machineReferences

I don't want to manually create the source hardcoding the ID.  I want the ID to loop through the list of software from the other sofware rest API above.  How do I loop so I don't have to hard code the IDs?

[lbendlin]

You would do all this in Powershell?

[dkoziupa-ifc]

No, I would like to do this in Power Query.

[lbendlin]

It will be agonizingly slow. But go ahead.

[dkoziupa-ifc]

Slow or not, I am looking to see if someone knows how to do this.  Do you know how to do this in Power Query?  If you know how to do this in both Power Query and PowerShell, please share.

[lbendlin]

It's a standard Web.Contents call. 

I know how to do this in both but I am not a domain admin and have no access to these endpoints.

[dkoziupa-ifc]

Do you have a URL or even better, a YouTube video that shows an example then?

[lbendlin · Accepted solution]

Please follow the documentation.  https://learn.microsoft.com/en-us/powerquery-m/web-contents