Integration of Azure AD with ServiceNow for Retrieving User Records via REST Graph API

Naveen Bagula · ‎07-10-2024

We have successfully integrated Azure Active Directory (Azure AD) with ServiceNow to retrieve user records using the REST Graph API. However, we encountered an issue where the API response is limited to 100 (max 900) records when performing a GET operation with the following endpoint:

Endpoint: https://graph.microsoft.com/v1.0/users

Additionally, when we use the $top parameter in the endpoint, it brings a maximum of 999 records:

Endpoint with $top: https://graph.microsoft.com/v1.0/users?$top=999

Our goal is to retrieve all user records from Azure AD and populate them into the ServiceNow user table. Could you please advise on how to obtain the complete set of records in the API response?

Just to give more clarity, I have created REST Message and GetUsers method, then using them in the scheduled script to run everyday get these records into user table

var r = new sn_ws.RESTMessageV2('Graph API', 'GET AllUsers');

var response = r.execute();

var responseBody = response.getBody();

var httpStatus = response.getStatusCode();

var obj = JSON.parse(responseBody);

for (var i=0; i<= obj.value.length; i++){

var azureUser = new GlideRecord('sys_user');

azureUser.addQuery('email', obj.value[i].mail);

azureUser.query();

if(azureUser.next()){

azureUser.u_nameFromAzure = obj.value[i].userPrincipalName;

azureUser.update();