I have a simple manual task that I need to automate in a sensible way.
I need to export the users and AD Object ID's of a specific group out of Azure Active Directory and drop a file off in Azure Data Lake or integrate directly in Azure SQL DB.
Powershell is not an option. I am curious if there is anyone out there who has dealt this. It sounds like Flow or Power Automate might allow for something like this but I am not sure where to start. I am using Data Factory as well and was wondering if there was a quick way to leverage that.
Any input would be much appreciated.
Graph API call, get AD info needed, copy into a SQL Table and map to other security focused data used downstream.