# Workday SaaS connector filter **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** saas-connector, identity-security-cloud\ **Created:** [July 23, 2024, 12:23pm UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763 "2024-07-23T12:23:13Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![vasanthrajsp29](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/vasanthrajsp29/32/20713_2.png) [@vasanthrajsp29](https://developer.sailpoint.com/discuss/u/vasanthrajsp29)\ **Post date:** [July 23, 2024, 12:23pm UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/1 "2024-07-23T12:23:13Z")
Hi All, We need to filter workday saas accounts who has FIRST\_NAME as “Test” I tried to use PATCH source but still its aggregating all the sources accounts to SailPoint. Can anyone guide us a better approach to achieve this ask? ```auto { "op": "add", "path": "/connectorAttributes/account.filterString", "value": "account.containsIgnoreCase(\"Test\")" } ``` Regards, Vasanth ---
**Author:** ![zachm117](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/zachm117/32/3883_2.png) [@zachm117](https://developer.sailpoint.com/discuss/u/zachm117)\ **Post date:** [July 23, 2024, 2:05pm UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/2 "2024-07-23T14:05:30Z")
Hey Vasanth! [Here](https://community.sailpoint.com/t5/IdentityNow-Wiki/IdentityNow-Account-Filtering-during-Account-Aggregation/ta-p/142873) is the documentation on using filterString. Your body should look something like this. Note the “path” value difference. ```auto [ { "op": "add", "path": "/connectorAttributes/filterString", "value": "( type != \"Employee\" )" } ] ``` Can you please try this and see if it resolves your issue? Thank you, - Zach ---
**Author:** ![vasanthrajsp29](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/vasanthrajsp29/32/20713_2.png) [@vasanthrajsp29](https://developer.sailpoint.com/discuss/u/vasanthrajsp29)\ **Post date:** [July 23, 2024, 4:03pm UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/3 "2024-07-23T16:03:57Z")
Hi @Zach, Tried the same no luck, Any other suggestions? Thanks! ---
**Author:** ![zachm117](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/zachm117/32/3883_2.png) [@zachm117](https://developer.sailpoint.com/discuss/u/zachm117)\ **Post date:** [July 23, 2024, 4:15pm UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/4 "2024-07-23T16:15:33Z")
For “value”, can you confirm you are using the correct attribute name? In your initial post, “account.containsIgnoreCase("Test")” is being added to filterString. This is assuming ‘account’ is the attribute on the Workday record you are looking to filter out if that attribute contains “Test”. Here is the example in the documentation on how to format this value. Like, Anywhere (Ignoring Case) – `{property}.containsIgnoreCase( {value} )` –`email.containsIgnoreCase( "sail" )` Thank you, - Zach ---
**Author:** ![vasanthrajsp29](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/vasanthrajsp29/32/20713_2.png) [@vasanthrajsp29](https://developer.sailpoint.com/discuss/u/vasanthrajsp29)\ **Post date:** [July 24, 2024, 4:21pm UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/5 "2024-07-24T16:21:11Z")
Hi @Zach, Thanks for response I tried multiple filters its aggregating all accounts, Attached JSON body which used for email filtering. [ { “op”: “add”, “path”: “/connectorAttributes/filterString”, “value”: “EMAIL\_ADDRESS\_WORK.containsIgnoreCase("ABCD@xyz.com")” } ] ---
**Author:** ![zachm117](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/zachm117/32/3883_2.png) [@zachm117](https://developer.sailpoint.com/discuss/u/zachm117)\ **Post date:** [July 26, 2024, 12:11am UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/6 "2024-07-26T00:11:10Z")
Hey @vasanthrajsp29, Can you try this for your value? ```auto "EMAIL_ADDRESS_WORK.containsIgnoreCase(\"ABCD@xyz.com\")" ``` Thank you, - Zach ---
**Author:** ![vasanthrajsp29](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/vasanthrajsp29/32/20713_2.png) [@vasanthrajsp29](https://developer.sailpoint.com/discuss/u/vasanthrajsp29)\ **Post date:** [July 26, 2024, 2:25am UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/7 "2024-07-26T02:25:58Z")
Hi @zachm117, No luck, Still aggregating all accounts from Workday. Thanks! ---
**Author:** ![vasanthrajsp29](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/vasanthrajsp29/32/20713_2.png) [@vasanthrajsp29](https://developer.sailpoint.com/discuss/u/vasanthrajsp29)\ **Post date:** [July 29, 2024, 9:48am UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/8 "2024-07-29T09:48:10Z")
Hi @Zach, Got solution from SailPoint professional services this workday saas connector doesn’t have filter setting to filter the accounts while aggregation. Thanks! ---
**Author:** ![Shivaraj\_Chattannavar](https://avatars.discourse-cdn.com/v4/letter/s/edb3f5/32.png) [@Shivaraj\_Chattannavar](https://developer.sailpoint.com/discuss/u/Shivaraj_Chattannavar)\ **Post date:** [August 27, 2024, 11:52am UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/9 "2024-08-27T11:52:38Z")
Hi @vasanthrajsp29 @zachm117 There’s something called as “Account Filters” configuration in the aggregation settings. Can we filter out based on that? If yes, any example? ---
**Author:** ![vasanthrajsp29](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/vasanthrajsp29/32/20713_2.png) [@vasanthrajsp29](https://developer.sailpoint.com/discuss/u/vasanthrajsp29)\ **Post date:** [September 9, 2024, 4:50pm UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/10 "2024-09-09T16:50:29Z")
Hi @Shivaraj_Chattannavar, I’ve tried that account Filter unfortunately; it’s not working even when we’re able to patch it from Postman. Regards, Vasanth ---
**Author:** ![nikhlesh21](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/nikhlesh21/32/11800_2.png) [@nikhlesh21](https://developer.sailpoint.com/discuss/u/nikhlesh21)\ **Post date:** [September 13, 2024, 6:49am UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/11 "2024-09-13T06:49:39Z")
HI @vasanthrajsp29, Were you able to filter users using any other possible way? Thanks. ---
**Author:** ![vasanthrajsp29](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/vasanthrajsp29/32/20713_2.png) [@vasanthrajsp29](https://developer.sailpoint.com/discuss/u/vasanthrajsp29)\ **Post date:** [September 13, 2024, 12:22pm UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/12 "2024-09-13T12:22:29Z")
Hi Nikhlesh, We tried all filter possibilities no luck, Tried SailPoint vendor case they replied saying we can’t filter users. Regards, Vasanth ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [November 12, 2024, 12:22pm UTC](https://developer.sailpoint.com/discuss/t/workday-saas-connector-filter/73763/13 "2024-11-12T12:22:50Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.