MS Intune connector next page
Anyone know how to get all results using the ms intune connector? Trying to "List Managed Devices" and can't get to the next page after the first 500 results. I've tried the $top and skip with no luck.
Answer (1)
Hi Matt,
Looking at Microsoft's API documentation for this endpoint, I'm not seeing anything specified relating to paging.
I did find another page though that talks about using PowerShell to export a .csv listing of managed devices.
https://www.paddymaddy.com/using-powershell-to-get-a-list-of-devices-from-microsoft-intune/
If this is an option for you, you could then use the Delimited File connector to parse that CSV file, or this is the logic I typically use for parsing CSVs:
- Replace new line characters with carriage return characters (to get the ↲, hold Shift and press Enter)
- Create a list of the rows, splitting on the ↲. This give a list of the individual lines in the CSV.
- Make start/end properties with Start = 2 (to account for the header row) and End = length of the list created in Step 2.
- From Start to End, make another list of each row by splitting on the delimiting character (also replace quotation marks with empty string)
From there, you can reference specific columns in the row by their index values.
In any case, I will forward this to our other iPaaS resources for further input.
- Mike