Webservice Account filtering using filterString

Hello Sailors!

I’m working on a Webservice Connector where I need to aggregate accounts only which has Country == “US“. Country is there in response mapping and schema as well. However, aggregation with filterString "account.filterString": "( Country != \"US\" )” brings in zero accounts to ISC while "account.filterString": "( Country == \"US\" )" brings in all accounts despite the filter. Please advise.

Hi @jainanimesh

Please below
"account.filterString": "(COUNTRY == \"US\")"

Please check the country attribute values (us or united sates). refer this post as well Account Filter String - Identity Security Cloud (ISC) / ISC Discussion and Questions - SailPoint Developer Community

Hello @gogubapu - I tried the same, didn’t work.

I tried using onboarding it as delimited connector and test the filterString – there it works fine. I tried the same with Identity Attribute of Web Service and the filter works (though in the opposite way). However, it doesn’t seems to be working for non-Identity or Display attribute of Schema of Web Service Connector.

Expert Sailors – please advise.

Hello @jainanimesh ,

Please note that Account Filter String which you are trying to use is an “Account Exclusion Filter“ which means as per your case.

"( Country != \"US\" )” –> This string will exclude all the records whose Country is not equals to “US“

"account.filterString": \"US\" --> This string will exclude all the records whose Country is equals to “US“.

Hence, kindly check the account attribute data for Country Account Attribute in Account Schema and check whether you are getting value as expected or not for this attribute.

From your output, it seems that there are no users coming in from Authz Source whose Country value is equals to “US“

Refer the below documentations for the same.

Regards,

Rohit Wekhande.

Hello Rohit - Thanks. I agree with what you said about exclusion, however, I have validated the response from Postman, and it has users from Country US. Using the filterString given, either no accounts are filtering or all accounts are getting filtered while reversing the filter.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.