Skip to Content
0
Former Member
Jun 07, 2013 at 02:44 PM

xsi:nil="true" in the response message

1235 Views

All,

I have a SOAP to SOAP scenario. It involves one to one field graphical mapping. Simple fields with no attributes. The problem now is that the response I am getting back for the some of the empty fields from the target system is:

- < GetDpmSubProjectPhotonViewResponse xmlns = http://ABC xmlns:soap =" http://schemas.xmlsoap.org/soap/envelope/ " xmlns:xsd =" http://www.w3.org/2001/XMLSchema " xmlns:xsi =" http://www.w3.org/2001/XMLSchema-instance " >

- < GetDpmSubProjectPhotonViewResult >

< StatusCode > 0 </ StatusCode >

< StatusMessage > Sub Project information retrieved successfully </ StatusMessage >

< SubProjectKey > dsdd </ SubProjectKey >

< Name > Safeway Horton Hears a Who Floorstand x48 (DVD Version) </ Name >

< ShipDate > 2008-11-10T00:00:00 </ ShipDate >

< DisplayQuantity > 1279 </ DisplayQuantity >

< CreativeCost xsi:nil =" true " />

< DisplayCost xsi:nil =" true " />

< CorrugateCost xsi:nil =" true " />

< PopCost xsi:nil =" true " />

< GroupYear > 2008 </ GroupYear >

< CompanyKey > 1 </ CompanyKey >

- < RetailAccountPhotonViews >

- < RetailAccountPhotonView >

< Name > SAFEWAY </ Name >

</RetailAccountPhotonView>

</RetailAccountPhotonViews>

</GetDpmSubProjectPhotonViewResult>

</GetDpmSubProjectPhotonViewResponse>

This after one to one mapping in PI becomes:

<?xml version="1.0" encoding="UTF-8" ?>

- < ns1:MT_DPMSubProjectServiceResponse xmlns:ns1 = http://xyzzz >

< Status_Code > 0 </ Status_Code >

< Status_Message > Sub Project information retrieved successfully </ Status_Message >

< Sub_Project_Key >asdds </ Sub_Project_Key >

< Sub_Project_Name > Safeway Horton Hears a Who Floorstand x48 (DVD Version) </ Sub_Project_Name >

< Sub_Project_Cycle_Ship_Date > 2008-11-10T00:00:00 </ Sub_Project_Cycle_Ship_Date >

< Sub_Project_Display_Qty > 1279 </ Sub_Project_Display_Qty >

< Sub_Project_Creative_Cost xsi:nil =" true " xmlns:xsi =" http://www.w3.org/2001/XMLSchema-instance " />

< Sub_Project_Display_Cost xsi:nil =" true " xmlns:xsi =" http://www.w3.org/2001/XMLSchema-instance " />

< Sub_Project_Corrugate_Cost xsi:nil =" true " xmlns:xsi =" http://www.w3.org/2001/XMLSchema-instance " />

< Sub_Project_POP_Cost xsi:nil =" true " xmlns:xsi =" http://www.w3.org/2001/XMLSchema-instance " />

< Group_YR > 2008 </ Group_YR >

< Company_Key > 1 </ Company_Key >

- < RetailAccountPhotonViews >

- < RetailAccountPhotonView >

< Name > SAFEWAY </ Name >

</RetailAccountPhotonView>

</RetailAccountPhotonViews>

</ns1:MT_DPMSubProjectServiceResponse>

How do we ensure that the target system does not send xsi:nil="true" in the response message and or how do I remove it in Pi with XSLT mapping.