question

RajanaDevassykutty-3635 avatar image
0 Votes"
RajanaDevassykutty-3635 asked RajanaDevassykutty-3635 answered

XML File copy in azure data factory with different namespace prefix

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

azure-data-factory
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @rajanadevassykutty-3635,

Thanks for using Microsoft Q&A!!
I am checking on this internally and get back to if this is possible with different namespaces. I believe you are using Copy Data activity.

Thanks
Saurabh

0 Votes 0 ·
SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered

Hi @RajanaDevassykutty-3635,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RajanaDevassykutty-3635 avatar image
0 Votes"
RajanaDevassykutty-3635 answered

Thanks Saurabh

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.