Hi Team,
I am having below payload as input and in the output im expecting only the Sales data of (Target >= 20)
Input Payload:
===========
{
"EmployeeDetails": [{
"EmpID": 123,
"Records": [{
"id": "S1",
"Department": "Sales",
"Target": "20"
},
{
"id": "S3",
"Department": "Sales",
"Target": "20"
},
{
"id": "S4",
"Department": "Sales",
"Target": "10"
},
{
"id": "L1",
"Department": "Leaves",
"Targets": "1"
}
]
},
{
"EmpID": 124,
"Records": [{
"id": "S2",
"Department": "Sales",
"Target": "25"
},
{
"id": "L1",
"Department": "Leaves",
"Targets": "3"
}
]
}
]
}
Expected Output: ("Records.Department == Sales" && "Records.Target >= 20")
==============
{
"EmployeeDetails": [{
"EmpID": 123,
"Records": [{
"id": "S1",
"Department": "Sales",
"Target": "20"
},
{
"id": "S3",
"Department": "Sales",
"Target": "20"
},
{
"id": "S4",
"Department": "Sales",
"Target": "10"
}
]
},
{
"EmpID": 124,
"Records": [{
"id": "S2",
"Department": "Sales",
"Target": "25"
}
]
}
]
}
Recipe: https://app.workato.com/recipes/1521392?st=5d5a86
Is anyone gone through similar kind of use case. please provide your solutions on this.
