XML reader adds xsi:nil="true" elements as filed names with .nil how to resolve this and have the value populated to be null

Hi @adi,

It would be useful if you can share the XML input so that we can assist you.

Hello @itay

Thankyou for taking time to look into this ,

here is a sample xml ,its ticket information that Im trying to write into SQL ,or Esri gdb

<?xml version="1.0" encoding="utf-8"?>
<test:testReferral xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:test="http://www.example.com/test"

="https://www.example.com/test/bydp.xsd">
  <test:Details>
    <test:MessageVersionNumber>1.0.10</test:MessageVersionNumber>
    <test:From>Before You Dig Partners</test:From>
    <test:RequestMedium>Phone</test:RequestMedium>
    <test:UtilityID>10038</test:UtilityID>
    <test:StationCode>value1            </test:StationCode>
    <test:TicketNumber>20184200087</test:TicketNumber>
    <test:PreviousTicketNumber xsi:nil="true" />
    <test:SequenceNumber>41199</test:SequenceNumber>
    <test:RequestDateTime>2018-10-19T12:02:21.295959-05:00</test:RequestDateTime>
    <test:WorkToBeginDate>2018-10-23T03:00:00-05:00</test:WorkToBeginDate>
    <test:WorkCompletionDate xsi:nil="true" />
    <test:IsEmergency>False</test:IsEmergency>
    <test:UserReference xsi:nil="true" />
    <test:StationList>
      <StationCode xmlns="test">value1             </StationCode>
      <StationCode xmlns="test">value2            </StationCode>
      <StationCode xmlns="test">value3            </StationCode>
      <StationCode xmlns="test">value4           </StationCode>
    </test:StationList>
  </test:Details>

I have tried using Feature paths for the configuratio Type and Elements to match to the node to Details .There is two entries with Previous Ticket Number and Previous Ticket Number.nil how would i handle this . which one should I keep

<?xml version="1.0" encoding="utf-8"?>
<test:testReferral xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:test="http://www.example.com/test"

="https://www.example.com/test/bydp.xsd">
  <test:Details>
    <test:MessageVersionNumber>1.0.10</test:MessageVersionNumber>
    <test:From>Before You Dig Partners</test:From>
    <test:RequestMedium>Phone</test:RequestMedium>
    <test:UtilityID>10038</test:UtilityID>
    <test:StationCode>value1            </test:StationCode>
    <test:TicketNumber>20184200087</test:TicketNumber>
    <test:PreviousTicketNumber xsi:nil="true" />
    <test:SequenceNumber>41199</test:SequenceNumber>
    <test:RequestDateTime>2018-10-19T12:02:21.295959-05:00</test:RequestDateTime>
    <test:WorkToBeginDate>2018-10-23T03:00:00-05:00</test:WorkToBeginDate>
    <test:WorkCompletionDate xsi:nil="true" />
    <test:IsEmergency>False</test:IsEmergency>
    <test:UserReference xsi:nil="true" />
    <test:StationList>
      <StationCode xmlns="test">value1             </StationCode>
      <StationCode xmlns="test">value2            </StationCode>
      <StationCode xmlns="test">value3            </StationCode>
      <StationCode xmlns="test">value4           </StationCode>
    </test:StationList>
  </test:Details>

Hello @adi, the 

<test:PreviousTicketNumber xsi:nil="true" />

Just tells you that the PreviousTicketNumber attribute doesn't necessarily need to have a value (true), if you are only interested in the PreviousTicketNumber value you can ignore the PreviousTicketNumber.nil tag

<test:PreviousTicketNumber xsi:nil="true" />

Hello @itay,Thank you for your suggestion on this ,I removed the nil attributes from the user attribute list,but I still need to figure out xlmns tag ,I have a used a list exploder and that resulted in additional records where as opposed to only one.

<test:PreviousTicketNumber xsi:nil="true" />

Hello @itay,I have removed the xlmns tags from the attributes and I got the expected output.Thank you