XML File copy in azure data factory with different namespace prefix

Question

question

RajanaDevassykutty-3635 asked Mar 30, '22 RajanaDevassykutty-3635 answered May 24, '22

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

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

SaurabhSharma-msft · Apr 02 at 12:30 AM

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 ·

Answer 1 · 2022-04-06T20:08:31.823Z

SaurabhSharma-msft answered Apr 6, '22

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

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

Answer 2 · 2022-05-24T19:25:22.103Z

RajanaDevassykutty-3635 answered May 24, '22

Thanks Saurabh

5 |1600 characters needed characters left characters exceeded

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

question