Forum Discussion
A Source Rest API that Loops a Parameter
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?
Please follow the documentation. https://learn.microsoft.com/en-us/powerquery-m/web-contents
7 Replies
- lbendlinSuper User
You would do all this in Powershell?
- dkoziupa-ifcFrequent Visitor
No, I would like to do this in Power Query.
- lbendlinSuper User
It will be agonizingly slow. But go ahead.