skotian
(sandhya Kotian)
November 14, 2024, 6:46pm
1
Hello,
I am unable to trigger a provisioning completed workflow using the following filter logic
$.accountRequests[?(@.provisioningResult == ‘committed’ && @.provisioningTarget == ‘Target Name’ && @.accountOperation == ‘Modify’)].attributeRequests[?(@.operation == ‘Add’ && @.attributeValue =~ /^TEST_/)]
Filter works without below attributeRequests, but we need role attribute value filter starts with ‘TEST’
attributeRequests[?(@.operation == ‘Add’ && @.attributeValue =~ /^TEST_/)]
Santhakumar
(Shantha Kumar)
November 15, 2024, 5:32am
2
@skotian Can you eloborate the requirements or what are you trying to achieve?
Thanks.
skotian
(sandhya Kotian)
November 15, 2024, 7:28am
3
we have a requirement where we need to send a email to particular group of team when someone request any role starting with ‘Test’ which got assigned for particular provisioning Target.
Hey Sandhya,
Try this filter logic instead, I have updated the logic for attributeRequests to give you the all the attribute values starting from ‘TEST’.
$.accountRequests[?(@.provisioningResult == 'SUCCESS' && @.provisioningTarget == 'Corp AD' && @.accountOperation == 'Modify')].attributeRequests[?(@.operation == 'Add' && @.attributeValue.toLowerCase().startsWith("test") )]
You can modify the values as per your requirement.
Testing:
Hey Sandhya,
My bad, it seems like startsWith
and toLowerCase
methods are not supported by SailPoint filtering.
I modified it, now comparing using Regex. Validated this filter string as well.
$.accountRequests[?(@.provisioningResult == 'SUCCESS' && @.provisioningTarget == 'Corp AD' && @.accountOperation == 'Modify')].attributeRequests[?(@.operation == 'Add' && @.attributeValue =~ /test.*/i )]
skotian
(sandhya Kotian)
November 15, 2024, 10:05am
7
same issue. WF didn’t triggered for role that start with Test.
Can you check if you are comparing with correct values, like
provisioningResult == ‘SUCCESS’
provisioningTarget == ‘Corp AD’
accountOperation == ‘Modify’
operation == ‘Add’
If you all these are correct, could you share the Provisioning Completed Trigger input you are getting in the workflow?
Santhakumar
(Shantha Kumar)
November 15, 2024, 10:45am
9
If you drop the json file it could be more efficient way to identify the issue and help to resolve it.
skotian
(sandhya Kotian)
November 15, 2024, 11:03am
10
Here is the file
sailpoint.json (3.1 KB)