cancel
Showing results for 
Search instead for 
Did you mean: 

Transform and Filter Json data

bala-s
Deputy Chef I
Deputy Chef I

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.


10 REPLIES 10

bala-s
Deputy Chef I
Deputy Chef I

Solution with RubyScript:

https://app.workato.com/recipes/1521392?st=5d5a86