Error While converting JSON to XML in SAP CPI/CI

[priyanka_ajn1992_90]

Hi Experts,

I'm working on a scenario where I'm receiving JSON input and would like to convert it into XML and push it to S4 HANA system. When I use the standard JSON to XML convertor , I receive the below error as the sender system is not sending the JSON in proper format. Sender is not ready to handle this at their end and needs to be handled in the middleware.

In such a scenario , Could someone guide me how this can be handled please?

Incoming JSON from Sender System: (incorrect format due to missing double quotes for date BEGDA & ENDDA)

{"I_BEGDA":2020-01-01,"I_ENDDA":2020-01-21,"I_TOTAL":"X"}

Error While using Standard convertor:

com.sap.it.rt.adapter.http.api.exception.HttpResponseException: An internal server error occured: Use JsonReader.setLenient(true) to accept malformed JSON at line 1 column 12 path $.I_BEGDA

Can any one guide me how this JSON can be converted to the correct JSON format please?

Correct JSON expected as input to the standard convertor

{"I_BEGDA":"2020-01-01","I_ENDDA":"2020-01-21","I_TOTAL":"X"}

Highly appreciate your responses

Thanks,

Priyanka

[lalit2054_46]

Hi priyanka_ajn1992_90

Below is much cleaner option using Groovy Script and you get directly an xml output -

import com.sap.gateway.ip.core.customdev.util.Message;
import groovy.xml.*

def Message processData(Message message) {
    
    def body = message.getBody(java.lang.String) as String
    def I_BEGDA_VAL = (body =~ /I_BEGDA":(.*?)[,]/)[0][1]
    def I_ENDDA_VAL = (body =~ /I_ENDDA":(.*?)[,]/)[0][1]
    def I_TOTAL_VAL = (body =~ /I_TOTAL":"(.*?)["]/)[0][1]

    
    def writer = new StringWriter()
    def xml = new MarkupBuilder(writer) 
    xml.xml() {
        I_BEGDA(I_BEGDA_VAL)
        I_ENDDA(I_ENDDA_VAL)
        I_TOTAL(I_TOTAL_VAL)
    
    }

    message.setBody(writer.toString())
    return message;
}