xml and json Transformaion

[amit_mohanty88]

I want to achieve below functionality in Workato without Ruby / Java Script / Python Scripting as scripts are not allowed by our customer .Also JSON Transformations by Workato Action not available in my plan .Without these is there a way to acheive below ?

1) Sort a input json alphabetically ascedending

2) Remove any specific fields from a input json and return updated json

3)Convert any given input  json to xml and any given input  xml to json 

4) Compare 2 json elment structure and return any field mismatch between the 2 json which is present in 1 json not the other json

[rajeshjanapati]

HI @amit_mohanty88,

Have you tried using SQL Collections by Workato?? like below

Thanks,

J Rajesh Kumar.