Need information regarding azure AD Account import Filter

[mollasiraj]

Hi All,

I need some information regarding Azure AD account import filter.I am using the below query-startswith(givenName,'Siraj').We are having a usecase to import the account based on the specific country and employee type. Anyone help me what query I can use for achieve the above use case.We are using the azure ad connector type.

[RakeshMG]

Please try :

startswith(extension_ourGUID#_employeeType,'Staff') AND country eq xxxx

[mollasiraj]

Hi Rakesh,

If I use the above mention format for account filter then instead of extension_ourGUID what value  I need to put.

startswith(extension_ourGUID#_employeeType,'Employee') AND country.equals("USA")

Is the above format is correct which I mentioned.Please let me know

With Regards,

Siraj Molla

[SB]

You can try with the below format. The only change is country eq

startswith(extension_ourGUID#_employeeType,'Employee') AND country eq("USA")

[mollasiraj]

I tried using the above query but it is importing all the account that's present in Azure.

With Regards,

Siraj Molla

[SB]

Can you try with the below one

startswith(extension_ourGUID#_employeeType,'Employee')& country eq('USA')

[mollasiraj]

Hi Sahil,

If I am using the above filter then I am getting below error in account import job-

Account threshold (accountThresholdValue) exceeded. Current threshold limit 100 and missing accounts during import 1636. No action was taken on missing accounts due to the threshold breach.

With Regards,

Siraj Molla

[SB]

Based on the above screenshot, it appears the filter condition did not work. Let me check this once and will update you.

[khalidakhter]

Instead of ampersand (&), please use 'and' conditional operator for adding another condition in the filter parameter supported by Microsoft graph API.
Example: startswith(extension_ourGUID#_employeeType,'Staff') and country eq 'USA'

For more info on filter visit: https://learn.microsoft.com/en-us/graph/filter-query-parameter?tabs=http