Solved: JSON to XML Converter in HCI

apu_das2 · ‎05-18-2017

Hi,

I am getting JSON data from a REST service using request-Reply pattern in HCI. As REST adapter is not available in HCI like PI, hence I am fetching the JSON data using HTTP adapter get method.

Now, I am trying to convert this JSON data to XML using standard JSON to XML converter pattern available for iFlow design in Eclipse.

This is my incoming JSON format -

[
{
"ID": 3,
"code": "ffee0192",
"price": 300,
"departureDate": "2016-01-20T00:00:00",
"origin": "MUA",
"destination": "LAX",
"emptySeats": 0,
"plane": {
"type": "Boeing 777",
"totalSeats": 300
}
}
]

But, I am getting this error -

Cannot transform JSON document to XML: JSON document does not start with '{'.

JSON format is absolutely fine. Can anyone tell me how should I configure. I had added one groovy script as well to replace [ and ]. But, still no luck.

Any idea, whats going wrong. This is very easy to configure in PI.

Thanks,

Apu

Sriprasadsbhat · ‎05-19-2017

Hello Apu,

Agree on your point.As per SAP documentation JSON texts starting with lists are not supported in Convertor.

Looks like convertor is too much immature to handle your requirement.

Before you pass JSON message to convertor you have to make some changes to it by adding root and element nodes( Just string transformations,not required to import any jars)

Script before JSON to XML Convertor:

import com.sap.gateway.ip.core.customdev.util.Message;
import java.util.HashMap;
import groovy.json.*

def Message processData(Message message) {
    //Body 
    def jsonOP = message.getBody(String.class);
    jsonOP=jsonOP.toString()
    
    def json_to_str=jsonOP.substring(1, jsonOP.length()- 1);
    json_to_str="{\"Root\": [{\"Element\":["+json_to_str+"]}]}"
    
    message.setBody(json_to_str);
    return message;
}

Input JSON:

[{
        "ID": 1,
        "code": "rree0001",
        "price": 541,
        "departureDate": "2016-01-20T00:00:00",
        "origin": "MUA",
        "destination": "LAX",
        "emptySeats": 0,
        "plane": {
            "type": "Boeing 787",
            "totalSeats": 200
        }
    }, {
        "ID": 2,
        "code": "eefd0123",
        "price": 300,
        "departureDate": "2016-01-25T00:00:00",
        "origin": "MUA",
        "destination": "CLE",
        "emptySeats": 7,
        "plane": {
            "type": "Boeing 747",
            "totalSeats": 345
        }
    }
]

Output XML:

<?xml version='1.0' encoding='UTF-8'?>
<Root>
    <Element>
        <ID>1</ID>
        <code>rree0001</code>
        <price>541</price>
        <departureDate>2016-01-20T00:00:00</departureDate>
        <origin>MUA</origin>
        <destination>LAX</destination>
        <emptySeats>0</emptySeats>
        <plane>
            <type>Boeing 787</type>
            <totalSeats>200</totalSeats>
        </plane>
    </Element>
    <Element>
        <ID>2</ID>
        <code>eefd0123</code>
        <price>300</price>
        <departureDate>2016-01-25T00:00:00</departureDate>
        <origin>MUA</origin>
        <destination>CLE</destination>
        <emptySeats>7</emptySeats>
        <plane>
            <type>Boeing 747</type>
            <totalSeats>345</totalSeats>
        </plane>
    </Element>
</Root>

or Else you can build Output XML in Script only by adding all the required logic to avoid convertor step [ Yet to give a try from my end ]

Regards,

Sriprasad Shivaram Bhat

Sriprasadsbhat · ‎05-18-2017

Hello Apu,

Nothing wrong from your end ,it took a long for me to understand the below behavior 🙂

This is the known issue/behavior as per my understanding.

While you are converting JSON to XML ,output from convertor needs to be valid XML.If you pass above JSON the XML which will get created is invalid .i.e without root.If you test above JSON in any online tools there is option to add root node which will resolve the above issue.But when it comes to our convertor its not the case.

Solution:

You have to add root element to above JSON before passing it to Convertor.Below code will do the same

Step1 :

Download json-simple-1.1.jar and add it to package src.main.resources.library [ By default it will not be available you need to create it inside your integration package ].

Step 2:

Add below script just before your convertor.

import com.sap.gateway.ip.core.customdev.util.Message;
import java.util.HashMap;
import org.json.simple.*
import groovy.json.*

def Message processData(Message message) {
    //Get Body 
    def body = message.getBody(String.class);

    //Define JSONSlurper
    def jsonSlurper = new JsonSlurper()
    def list = jsonSlurper.parseText(body)
    
    //Define JSONObject and add a root node
    JSONObject myobj = new JSONObject(); 
    myobj.put("Root",list);

    //Format the JSON output
    def jsonOP = JsonOutput.toJson(myobj)
    
    //Set the modified JSON to body and return
    message.setBody(jsonOP);
    return message;
}

Regards,

Sriprasad Shivaram Bhat

former_member103540 · ‎11-02-2020

Hi. Thank you for the solution. It is 2020 and I ran into the same problem. How do we get items like this looked so that the maturity of the tool can be improved?

former_member114710 · ‎10-11-2018

Hi,

I am having similar problem. How do we add the package src.main.resources.library in webUI? I am not able to find any option.

Florian_Kube · ‎05-30-2018

Thanks. It solved my problem.

former_member327458 · ‎12-18-2017

Thanks a lot Sriprasad. Solved the issue !!!

apu_das2 · ‎05-20-2017

Thanks Sriprasad.Thanks a lot for your quick help.

JSON to XML Converter in HCI

Accepted Solutions (1)

Accepted Solutions (1)

Answers (6)

Answers (6)

Re: reading external (OData) API from cap

Re: SSO using OKTA - launches FLP twice

Re: SSO using OKTA - launches FLP twice

SSO using OKTA - launches FLP twice

Re: SAP API Management and Target Endpoint OAuth2....