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.
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.
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“
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.