We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK 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.