Query Azure AD for all users in a User Group

  • 29 July 2020
  • 3 replies
  • 33 views

I have been following this blog post:  https://www.devfacto.com/blog/nintex-workflow-get-users-from-azure-active-directory-group/ .  However, the workflow runs successfully however, when I view the data for the users, there is no user data in it at all.  There are users assigned to the group.  

In the end, what I am trying to accomplish is to be able to collect birthdates and work anniversaries for company employees and be able to post them on our SharePoint frontpage for M365.  

Any ideas or suggestions will greatly be appreciated.


3 replies

Userlevel 5
Badge +19

@Ryan_P often when the workflow runs successfully but you get no data back, there is actually an error that is coming back from the Web Service, it just does not fail the workflow as technically the action did get a response back (just not the response that you were looking for). 


 


In your instance are you able to confirm that you're getting your bearer token back from your OAuth call and you're getting a 200 in the response code from your group call?

I do get a 200 in the response code.  

Badge +4

there are 2 calls to make:


 


One to the token provider and one to "Azure Active directory"


1.  https://login.microsoftonline.com/‍{Variable:varTxtTenantID}‍/oauth2/token


2. https://graph.microsoft.com/v1.0/groups/‍{Variable:varTxtGroupId}‍/members


 


The token from the first call need to be in the headers of the second call



  • Header name (key): Authorization

  • Header value: Bearer ‍{Variable:varTxtAccessToken}


 


Are both calls having a 200 or 201 response code? Also make sure you placed BEARER in front of the result of call 1.


 


 


 

Reply