Is it possible to connect to Azure AD using Microsoft Graph

[4ff3a001681946b94681]

Hi

I am trying to see if it is possible to connect to Azure AD to get the list of users and email addresses by using Microsoft Graph API.

Is this possible within Trifacts

[MarniM]

Hello Vahid,

Yes, it is possible to connect to Azure AD using Microsoft Graph.

To connect to Azure AD using Microsoft Graph in Trifacta, you will need to create an Azure AD application and configure it to have the necessary permissions to access the data you need. Then, you can use the Microsoft Graph API to query and retrieve the data from Azure AD.

Regards,

Monika

[jrobiso2]

Be aware, Azure/Graph can only return a limited # of records at a time.  The end result is that you will have to use an Iterative Macro to cycle through to get all the data.

JSON metadata returned will include an 'odata.nextLevel' value which is the url for the next set of data, for use in the Iterative Macro.

[nkuipers]

The only way that I can envision to do this from within AACP Designer Cloud (Trifacta Experience) is to Create a Plan and then Create an HTTP Task that calls the Graph API. The requisite connectivity/authentication for the call to succeed lies outside the scope of Designer Cloud, as Monika mentioned above.