Skip to Content
0
Jul 28, 2020 at 04:38 AM

SAP PI mapping : numbers don't have quotation mark in the XML request

149 Views Last edit Jul 28, 2020 at 09:38 AM 8 rev

Hi,

I have a mapping structure for 2 fields with type string.

The value in these fields are:

field1: hello

field2: 2

But when I execute the PI, and saw the log file, I noticed that the XML data turned out to be like this

"field1":"hello",

"field2":2 (the quotation marks disapeared)

Somehow there's a logic inside the soap adapter to strip the QuotationMarks from any field containing numbers.

The thing is that I need this quotation mark to stay intact, so I'm expecting the result to be:

"field1":"hello",

"field2":"2"

Here is what I have done.

Create an UDF to add quotation marks

var1 = "\""+var1+"\""; return var1.toString();

But the result in the XML Request became:

"field1":"hello",

"field2":\"2\""

Which triggered the invalid json format error.

Please help me how to fix this.

Thanks,