Hi All, Hoping you can help. We are trying to extract data from Microsoft Dataverse and want to use Azure Auths to authenticate against the API using the Singer-Tap for Dataverse. To do this we need to setup an Azure App Registration, but having looked through all the Meltano documentation we have not been successful in findings a way to do this. Any advice appreciated. 🙂 #C06A1LKFAAC #C069CPBCVPV

To create an app registration (which confusingly is the same as a service principal) you probably want to follow something like this: https://learn.microsoft.com/en-us/cli/azure/azure-cli-sp-tutorial-1?tabs=bash#create-a-service-principal-with-role-and-scope I use Azure Managed Identity when authenticating, if you run on Azure machines I’d recommend that as well. In Python, you can authenticate easily with defaultAzureCredential and obtain an API token from there. https://github.com/storebrand/tap-sharepointsites/blob/main/tap_sharepointsites/client.py#L41-L42 If you do use service principals, you can still use DefaultAzureCredential to authenticate as long at some set of environment variables are populated with the Service Principal credentials.

Thanks Henning, I'll provide this to our Engineers and see if it helps :)