Router expressions - Need help!

[kiranm]

I need to apply the routing conditions, and based on the matching criteria I have to call SOAP update, create methods:

Criteria 1: ($employee *.empId exists in $employees) && ($employee *.empId == $excelEmp *.empId)
then take $excelEmp and call Update SOAP

Criteria 2: ($excelEmp *.empId exists in $employees) && ($excelEmp *.empId != $excelEmp *.empId)
then take $excelEmp and call Create SOAP

Please help in writing the Router expressions for the above criteria

The below is the json:
[
{
“employee”: {
“empId”: “999”,
“age”: “45”,
“salHike”: “15”,
“depId”: “285898”,
“guid”: “ABC”
}
},
{
“employee”: {
“empId”: “1000”,
“age”: “45”,
“salHike”: “15”,
“depId”: “285898”,
“guid”: “PQR”
}
},
{
“employee”: {
“empId”: “1001”,
“age”: “45”,
“salHike”: “10”,
“depId”: “285898”,
“guid”: “XYZ”
}
},
{
“employees”: [
“1000”,
“1001”,
“1002”,
“1003”,
“1004”,
“1005”,
“1006”
]
},
{
“excelEmp”: {
“empId”: “1001”,
“currency”: “INR”,
“newHike”: “8”,
“varPay”: “90”
}
},
{
“excelEmp”: {
“empId”: “1002”,
“currency”: “INR”,
“newHike”: “5”,
“varPay”: “60”
}
},
{
“excelEmp”: {
“empId”: “1005”,
“currency”: “INR”,
“newHike”: “6”,
“varPay”: “90”
}
},
{
“excelEmp”: {
“empId”: “1006”,
“currency”: “INR”,
“newHike”: “6”,
“varPay”: “90”
}
}
]

[anubhav_nautiya]

could you please attach the slp file having Json Generator, tried to copy the JSON but it fails while validating.

[kiranm]

Hi Anubhav,
Please find the slp file attached
Router-conditions_2020_05_11.slp (15.0 KB)