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.

[shivakumara]

Hi @rajeshjanapati 

1. We can combine steps 4 and 5, as the sorting part is not being used in any subsequent steps.
2. For XML ↔ JSON conversion, we can directly feed the data into Parse XML and Parse JSON action/ step as needed.

This approach will help optimize the overall solution. Please free to add your thoughts.

Thanks and Regards,
Shivakumara K A

[amit_mohanty88]

Hi @rajeshjanapati 

Let me try and get back . Thank you for your suggestion

[amit_mohanty88]

Hi @rajeshjanapati  @shivakumara ,

Thank you for your suggestion. 1 query i got like in step 2 and step 9 parse json doument for that we need to give sample json . But this recipe should be able to process any json not only any specific json so what can we give sample json in parse json  doument  in step 2 and step 9 ?

Regards,

Amit Mohanty