Provisioning Completed Workflow Trigger Filtering

[dominick-miller]

Hi,

I am unable to trigger a provisioning completed workflow using the following filter logic:
$.accountRequests[?(@.source.name==“Test Active Directory” && @.provisioningResult==“committed” && @.accountOperation"Create")]

I have also tried the following variations with no luck:
$.input.accountRequests[…]
…@.accountOperation(“CREATE”)…
…@.provisioningResult==“SUCCESS”…

The workflow, with no json filter query, executed fine and the above path should work based on the csv results I was able to pull from the successful run. The only thing I can think of is if the json path filter does not support logical operators like == and &&.

Does anyone have any ideas?

[GOKUL_ANANTH_M]

Hi @dominick-miller ,

Welcome to Sailpoint Developer Community.

Try this,

1. As provisioning got completed, provisioning completed trigger will be executed right. Hence, in filter use:

$[?($.sources == "Test Active Directory")]

2. Use compare strings operator to verify the operation:

In value1, provide “$.trigger.accountRequests[*].accountOperation”
In value2, provide “Create”
Operator “Equals”

Thanks!

[RAKGDS (Rakesh Bhati)]

Hi Dominick,
Please use the following. It should work

$.accountRequests[?(@.provisioningResult == ‘committed’ && @.provisioningTarget == ‘Test Active Directory’ && @.accountOperation==‘Create’)]

Thanks
Rakesh Bhati

[dominick-miller]

This worked perfectly, thank you. I think the core of my issue was 1) sometimes forgetting equal signs and 2) capitalization.