XML File copy in azure data factory with different namespace prefix

Question

Hi,

I have 2 different xml files like below which has the same namespace for elements but with different prefix.

When I gave ns1:Bill in the mapping it copied only 1 file.
When I tried with *:Bill it was not copying the data

Can you please let me know how should I give the mapping in this case?

File 1:

<?xml version="1.0" encoding="utf-8"?>
<ns1:Bill xmlns:ns1="http://schemas.company.com/bill/v1.0">
<Transaction>
.....
</Transaction>
</ns1:Bill>

File 2:

<?xml version="1.0" encoding="utf-8"?>
<ns12:Bill xmlns:ns2="http://schemas.company.com/bill/v1.0">
<Transaction>
.....
</Transaction>
</ns1:Bill>

Thanks in advance
Rajana D

Answer 1

Hi @Rajana Devassykutty ,

I have got the confirmation from the products team that the XML connector doesn't handle this scenario today and this seems like an improvement for the XML connector. Please provide your feedback to Azure Feedback website so that community can upvote and products team can plan to include this in future releases.

Please let me know if you have any other questions.

Thanks
Saurabh

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Answer 2

Thanks Saurabh