How to handle different XML file with different namespace for same element in Fabric pipeline

Sethulakshmi Sambasivan 45 Reputation points
2023-09-01T16:36:06.4266667+00:00

I have multiple XML files with same data with different name space, so while performing the copy activity using pipeline its skipping records or not all copying anything. pipeline is not throwing any error, running successfully populating the table with blanks.

ample file1:

<ns7:Items>

  <ns6:itemdetails>

           <ns6:ID>123</ns6:ID>

           <ns6:item>apple</ns6:item>

  </ns6:itemdetails>

  <ns6:itemdetails>

...................................

</ns6:itemdetails>

   </ns7:Items>

sample file2:

<ns7:Items>

    <ns3:itemdetails>

             <ns3:ID>124</ns6:ID>

              <ns3:item>orange</ns6:item>

   </ns3:itemdetails>

 </ns7:Items>
How to handle when there are different namespace for same elements inside pipeline or is there any other method to handle these kind a files?
Azure Service Fabric
Azure Service Fabric
An Azure service that is used to develop microservices and orchestrate containers on Windows and Linux.
253 questions
{count} votes