Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

Is it possible to connect to Azure AD using Microsoft Graph

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

3 REPLIES 3
MarniM
Alteryx
Alteryx

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
8 - Asteroid

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
Alteryx
Alteryx

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.