Skip to Content

Java Mapping remove xsi:nil='true' from payload

Hello all,

I am a new in PI, there need to remove character xsi:nil='true'.

I tried to use Graphic mapping and XSLT mapping for this. However, these two methods need to verify the validity of the XML file first.

Below are xml structure, could someone help this?

Many thanks in advance,

Br,

Nero.

<ns1:ConnectException
xmlns:ns1='http://test.com/connect/_2007_08/'>


    <ns2:errorCode
xmlns:ns2='http://test.com/services/exception/_2006_12_15/exception'>POL33F2060</ns2:errorCode>


    <ns3:errorDescription
xmlns:ns3='http://test.com/services/exception/_2006_12_15/exception'>User
ID ZZJ12FJ81 is not authorised for policy 31444</ns3:errorDescription>


   
<ns4:serverErrorReferenceToken
xmlns:ns4='http://test.com/services/exception/_2006_12_15/exception' xsi:nil='true'/>


   
<ns5:values
xmlns:ns5='http://test.com/services/exception/_2006_12_15/exception'>


        <ns5:value>ZZJFJ814</ns5:value>


       
<ns5:value>314635</ns5:value>


   
</ns5:values>


</ns1:ConnectException>

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 5 days ago

    Hi Nero!

    Read input payload as text with java mapping and replace "xsi:nil" with empty string.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • Hi Nero,

    Why do you want to remove that? you can request the source system owner to provide the XSD and handle the xsi:nil .

    If you want to remove xsi:nil from the element, you can use boolean function "isNil" and an "if" statement to pass an empty constant-

    Thanks

    Sugata

    Add comment
    10|10000 characters needed characters exceeded