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

[rajeshjanapati]

Hi @shivakumara ,

Thank you for your valuable suggestion and the additional step.

Here’s my thought process:

1. As per @amit_mohanty88's question, the goal was to verify whether each scenario is possible or not. Hence, I designed the flow in such a way to demonstrate all the possibilities.

2. Agreed with your point regarding optimization.

Thanks again for your inputs!

Thanks & Regards,

J Rajesh Kumar.

[amit_mohanty88]

Hi @rajeshjanapati 

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