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.

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. [image] IdentityNow Account Filtering during Account Aggregation Overview Often there is a need to filter accounts on a source during an account aggregation process. While some source connectors offer an ability to filter accounts natively, other source connectors may not, usually due to technical limitations -... 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.

Webservice Account filtering using filterString

SailPoint Human Fabric (SHF) SHF Discussion and Questions

gogubapu (bapu gogu) August 25, 2025, 9:24am 2

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

Topic		Replies	Views
Account Filter String SHF Discussion and Questions sailpoint-identity-security	4	537	August 22, 2025
How to add filtering conditions while aggregating SHF Discussion and Questions sailpoint-identity-security	8	720	January 27, 2025
Aggregation Account Filter Issue SHF Discussion and Questions	4	1422	August 20, 2022
Web Service Accounts Filter in aggregation SHF Discussion and Questions apis , aggregation , sailpoint-identity-security , connectors	3	147	February 23, 2026
Account Aggregation - Filter to get only enabled accounts SHF Discussion and Questions apis , sailpoint-identity-security	5	658	February 25, 2024

Webservice Account filtering using filterString

Related topics