Question Re: JSON to XML error Rest in Technology Q&A

JSON to XML error Rest

former_member190536 — Thu, 28 Jul 2016 10:13:50 GMT

Hello,

I am using REST Adapter to receive JSON format message in PO.

the normal XML work for me, but when we have ATTRIBUTES in our strucutre then the json to xml conversion error is coming due to this in mapping the message gets failed.

My target xml strucutre like this.

in my source JSON it is coming like this..

"CalculationBaseQuantity": {

"-unitCode": "KG",

"#text": "1"

After Seder adapter the message come in mapping as ...

due to this mapping getting failed as xml formatting issues.

error in mapping - The content of elements must consist of well-formed character data or markup., BaseRuntimeException: The content of elements must consist of well-formed character data or markup., BaseRuntimeException: The content of elements must consist of well-formed character data or markup.,

does standard REST adapter wont support this functionality? does i need to go for Custom adapter only?

Re: JSON to XML error Rest

Former Member — Thu, 28 Jul 2016 10:43:03 GMT

Hello Khaja,

I guess the source JSON is not well formatted.

Tats why getting the error while converting to XML.

https://www.freeformatter.com/json-to-xml-converter.html

Re: JSON to XML error Rest

former_member190536 — Thu, 28 Jul 2016 10:55:44 GMT

Ya i am doing from those tools only.

Re: JSON to XML error Rest

Former Member — Thu, 28 Jul 2016 11:00:30 GMT

Source Has the same JSON?it seems to be wrong.

Might you require a module to convert it in SAP PI.

Re: JSON to XML error Rest

former_member190536 — Thu, 28 Jul 2016 11:07:48 GMT

so for this <CalculationBaseQuantity unitCode="KG">1</CalculationBaseQuantity>

how JSON to be expected? then I will correct this JSON and I will send test to PO.

Re: JSON to XML error Rest

Former Member — Thu, 28 Jul 2016 11:09:59 GMT

Check the below example

JSON Example

Re: JSON to XML error Rest

apu_das2 — Thu, 28 Jul 2016 11:33:10 GMT

Hi Khaja,

Did you try with the escape character check box in sender REST CC. Try with that. If that solve your issue then its fine otherwise you need to write one custom module to handle this as the error is coming in the CC conversion ... # will not be treated as a valid xml attribute character.

If you need to write custom module exactly follow this and use module parameters in your CC accordingly -

Thanks,

Apu

Re: JSON to XML error Rest

anupam_ghosh2 — Thu, 28 Jul 2016 14:37:41 GMT

Hi Khaja,

Can you pls provide the complete json input and complete xml as required by mapping.

Regards

Anupam

Re: JSON to XML error Rest

former_member190536 — Sun, 31 Jul 2016 06:00:43 GMT

My source JSON

"CalculationBaseQuantity": {

"-unitCode": "KG",

"#text": "1"

I want to convert into XML.

REST Adapter is converting into XML as follows..

Expected XML in mapping required as follows..

Due to this I am getting error in mapping as follows.

So how should my JSON format required to form this correct xml?

Re: JSON to XML error Rest

apu_das2 — Sun, 31 Jul 2016 06:23:18 GMT

Hi Khaja,

Define this field as attribute in sender CC Custom XML/JSON conversion table and look how this behave.

Thanks,

Apu

Re: JSON to XML error Rest

anupam_ghosh2 — Sun, 31 Jul 2016 16:17:11 GMT

Hi Khaja,

Can you please confirm if your source json is exactly shown below

{

"CalculationBaseQuantity": {

"-unitCode": "KG",

"#text": "1"

}

Can you please confirm version of PI and service pack you are using.

Regards

Anupam

Re: JSON to XML error Rest

former_member190536 — Mon, 01 Aug 2016 06:14:16 GMT

yes Anupam, it is same as you mentioned above.

{

"CalculationBaseQuantity": {

"-unitCode": "KG",

"#text": "1"

}

tried with multiple cases like with "@unitCode":"KG", "$":"1"

"_unitCode":"KG", "$":"1" . etc...

in all cases xml is not forming attribute field unitCode and in mapping getting failed.

I am using PO 4.0.

Re: JSON to XML error Rest

praveen_vanga3 — Thu, 04 Aug 2016 20:38:25 GMT

Hi Khaja,

We configured REST adapter as a receiver .It may useful below screen shot for the reference.

Java mapping required but before that get response in CDATA and do modification as per your message type .you may required few lines of code.

Once you see the response in CDATA , you build the logic accordingly.

Thanks

Praveen

Re: JSON to XML error Rest

anupam_ghosh2 — Fri, 05 Aug 2016 03:54:49 GMT

Hi Praveen,

Issue is with REST sender adapter as per first post by Khaja.

Regards

Anupam

Re: JSON to XML error Rest

Former Member — Fri, 05 Aug 2016 06:04:50 GMT

Hi Khaja,

Have you tried using this option in REST adapter:

Remove mangling of invalid name characters

Remove escaped name start character

Cheers,

Sanjeev

Re: JSON to XML error Rest

former_member190536 — Fri, 05 Aug 2016 07:12:35 GMT

hello Sanjeev,

I checked it,

What I have to provide there?

Re: JSON to XML error Rest

Former Member — Fri, 05 Aug 2016 07:16:09 GMT

Try with the special characters that you are getting in field name, such as "-".

Regards,

Sanjeev

Re: JSON to XML error Rest

anupam_ghosh2 — Fri, 05 Aug 2016 10:33:16 GMT

Hi Khaja,

Please let us know in case the solution provided by Sanjeev was able to resolve the issue.

here is the updated java mapping to resolve the issue.

This needs to be applied in same OM before message mappings


import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.StringReader;


import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;


import org.w3c.dom.Document;


import org.xml.sax.InputSource;


import com.sap.aii.mapping.api.AbstractTransformation;


import com.sap.aii.mapping.api.StreamTransformationException;
import com.sap.aii.mapping.api.TransformationInput;
import com.sap.aii.mapping.api.TransformationOutput;




public class JsonToxml  extends AbstractTransformation{


  /**
  * @param args
  * @throws FileNotFoundException 
  * @throws StreamTransformationException 
  */

  StringBuilder s=new StringBuilder("");
  BufferedReader reader;
  
   
  @Override
  public void transform(TransformationInput arg0, TransformationOutput arg1)
  throws StreamTransformationException {
  // TODO Auto-generated method stub
  execute(arg0.getInputPayload().getInputStream(),arg1.getOutputPayload().getOutputStream());
  }

  public void adjustAttribute(char c) throws StreamTransformationException
  {
  /******
  * this function removes all text nodes and attribute nodes from payload
  */
  try
  {
  String t="><"+c;
  String attributeName="",attributeValue="";
  int p=s.indexOf(t);
  if(p>=0)
  {
  //attribute present
  int y=s.indexOf(">",p+1);
  attributeName=s.substring(p+3,y);
  int x=s.indexOf("<",y+1);
  attributeValue=s.substring(y+1,x);
  int z=s.indexOf(">", x+1);
  if(c=='-')
  {
  s=new StringBuilder(s.substring(0,p)+" "+attributeName+"=\""+attributeValue+"\">"+s.substring(z+1,s.length()));
  }
  else if(c=='#')
  {
  if(attributeName.equalsIgnoreCase("text"))
  {
  s=new StringBuilder(s.substring(0,p+1)+attributeValue+s.substring(z+1,s.length()));
  }
  }
  }

  }
  catch(Exception e)
  {
  e.printStackTrace();
    throw new StreamTransformationException(e.getMessage());
  }
  return;
  }
    public void execute(InputStream in, OutputStream out) throws StreamTransformationException
    {
    try
    {
   
    boolean status=false;
    BufferedReader reader = new BufferedReader(new InputStreamReader(in));
    int c;
    while((c=reader.read())!=-1)
    {
    s.append((char)c);
    }
    reader.close();
    System.out.println(s);
    String symbol[]={"-","#"};
    for(int i=0;i<symbol.length;++i)
    {
    while(s.indexOf("<"+symbol[i])>=0)
    {
    adjustAttribute(symbol[i].charAt(0));
    }
    }
    System.out.println(s);
    //check if the xml is well formed
    DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();  
            DocumentBuilder builder;  
            builder = factory.newDocumentBuilder();  
            Document doc = builder.parse( new InputSource( new StringReader( s.toString() ) ) ); 
            System.out.println("xml well formed");
            out.write(s.toString().getBytes("UTF-8"));
    }
    catch(Exception e)
    {
    e.printStackTrace();
    throw new StreamTransformationException(e.getMessage());
    }
    }

}

Input

Output

Regards

Anupam

Re: JSON to XML error Rest

former_member190536 — Sun, 07 Aug 2016 13:34:52 GMT

Hi Anupam,

This JAVA code working fine for me.

1. But I don't have external JAR files with me to create JAVA Mapping, so I did directly used this code in Graphical mapping in "Funcitons" tab. It is working fine. But in design time test using "Test" tab then it is hanging and not responding. Do you have information abt tht?

2. How to create Java mapping directly in NWDS directly? (means with out import archives option)

@Sanveev: Thanks for your response, I used those 2 fields in Sender REST Adapter, but it is not working.

I checked Escape invalid name set character and Mangle invalid character set and used Escape sequence "-"

then it is creating "--" characters in mapping.

Re: JSON to XML error Rest

Former Member — Mon, 08 Aug 2016 00:39:40 GMT

Hi Khaja,

Apologies, my bad. I read the documentation the other way round.

Regards,

Sanjeev