Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Azure AD User Import using filter

JPMac
Regular Contributor
Regular Contributor
The ImportUserJson below is used to test import in users from Azure AD.
However, Filter does not work.
We only want to import users whose CompanyName is Tomato.
Can you give me some advice on how to write?
===
{
  "connection": "userAuth",
  "httpMethod": "GET",
  "httpHeaders": {
    "Authorization": "${access_token}",
    "Accept": "application/json"
  },
  "statusConfig": {
    "active": "true",
    "inactive": "false"
  },
  "colsToPropsMap": {
    "username": "userPrincipalName~#~char",
    "displayname": "displayName~#~char",
    "firstname": "givenName~#~char",
    "lastname": "surname~#~char",
    "country": "country~#~char",
    "companyName": "companyName~#~char",
    "phonenumber": "mobilePhone~#~char",
    "statuskey": "accountEnabled~#~char",
    "email": "mail~#~char",
    "employeeType": "userType~#~char",
    "customproperty1": "preferredLanguage~#~char",
    "customproperty2": "businessPhones~#~char",
    "customproperty3": "mailNickname~#~char",
    "customproperty4": "Id~#~char",
    "customproperty5": "userPrincipalName~#~char",
    "customproperty6": "createdDateTime~#~char"
  },
  "userResponsePath": "value",
  "pagination": {
    "nextUrl": {
      "nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}"
    }
  }
}
===
3 REPLIES 3

rushikeshvartak
All-Star
All-Star

https://graph.microsoft.com/v1.0/users/?$select=Id,userPrincipalName,companyName,accountEnabled,mail... eq 'tomato'

rushikeshvartak_0-1701658338608.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

JPMac
Regular Contributor
Regular Contributor

@rushikeshvartak 

I understand it's invalid using Postman, but my question is how to filter it like this.

https://graph.microsoft.com/v1.0/users?$count=true&$filter=companyName+eq+null&$select=id,displaynam...

rushikeshvartak_0-1701668691386.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.