Question Re: Convert Json to XML with validation using Groovy ? in Technology Q&A

Convert Json to XML with validation using Groovy ?

former_member873987 — Thu, 19 Oct 2023 04:06:19 GMT

Hi Experts,

I want to convert incoming Json payload to XML with validation using groovy. Please find input payloads,

Case 1:If validation is true then send email alert to business team.Below is input payload.

{

"id": "INGAO0",

"order_number": "WorkOrder",

"service": "boarding",

"validationdata": [

{

"reason": "hardware-Windows Laptop 16 Bundle with standard accessorieseeh is invalid",

"type": "Data error"

{

"reason": "supplying_company_agency_name is mandatory",

"type": "Data missing"

{

"reason": "start_date-2023-07-318 is invalid format",

"type": "Technical error"

{

"reason": "end_date is mandatory",

"type": "Data missing"

}

]

}

Case 2: If validation is false then build the xml,For this input payload is below

{

"id": "INGAO0",

"order_number": WorkOrder",

"boardingtickets": "RIGM5020790"

}

Both cases i need to write in single groovy then we can check in router.Please help me.Regards,Raj

Re: Convert Json to XML with validation using Groovy ?

joel_langoyan — Thu, 19 Oct 2023 08:34:11 GMT

Hi Raj

Why don't you just use standard json to xml converter and then on your router have an xpath expression if the <validationdata> exists or not. That is my simplest understanding what you intend to happen. Kindly elaborate more details if that is not the case

Re: Convert Json to XML with validation using Groovy ?

former_member873987 — Thu, 19 Oct 2023 08:50:37 GMT

Hi joel.langoyan

Thank you for reply, you are correct we can use standard json to xml converter but in my case we have 2 incoming payloads, If case 1 data come we need to validate(If validation = True) then send email alert to team OR Case 2 data come (validation = False) then build the XML and post to target system.

Please check input payloads above case 1, case 2.
Regards,
Raj

Re: Convert Json to XML with validation using Groovy ?

joel_langoyan — Thu, 19 Oct 2023 10:17:59 GMT

Hi Raj,

What is validation exactly you are looking for? Is there a specific field or value in the input payload that you need to check? Is it the whole input JSON payload valid or not?

What do you mean exactly by 'IF validation = true or false'? If it is just to check whether the validationdata array exist or not then as already described you can do so as xpath condition in the router after standard converter. The most significant difference in your cases as you describe is just whether validationdata is in the payload

Re: Convert Json to XML with validation using Groovy ?

former_member873987 — Thu, 19 Oct 2023 11:38:38 GMT

Hi joel.langoyan,

We have 2 cases if validation is true then send email with different field(See in case 1 input data) and validation is false post to target system with different fields, For these i was taken 2 times mapping. We don't need 2 mappings, instead of that we prefer Groovy script. Actually i am new to groovy please help me.

Regards,

Raj

Re: Convert Json to XML with validation using Groovy ?

MortenWittrock — Thu, 19 Oct 2023 12:38:01 GMT

As joel.langoyan mentions in his answer, you don't need a Groovy script for this. It can be solved very nicely using the built-in flow steps. And if you are new to Groovy, then you definitely should use the built-in steps instead.

Regards,

Morten