Hi Team,
We are looking to filter the incoming accounts from a source(Direct Connector) based on the role attribute. We want to filter out and not aggregate those accounts if it does not contain any one of the 3 admin roles as shown below. If the account has any one of the admin role, they need to be aggregated.
This is the filter that we are using:
[
{
"op": "add",
"path": "/connectorAttributes/account.filterString",
"value": "(!role.contains({\"Admin Role1\"}) || !role.contains({\"Admin Role2\"}) || !role.contains({\"Admin Role3\"}))"
}
]
However this returns 0 accounts though there are accounts without the above admin roles.
We have also tried the below filter after which we are getting all the accounts aggregated and the accounts are not filtered as expected.
[
{
"op": "add",
"path": "/connectorAttributes/account.filterString",
"value": "(!role.contains({\"Admin Role1\", \"Admin Role2\", \"Admin Role3\"}))"
}
]
Can anyone let me know if there is anything missing in the filter or is there a way we can achieve this usecase using account filterString?
Thanks in Advance!
Regards,
Karthik