Share via

Unable to read xml tags in ADF

Krishna Nagesh Kukkadapu 116 Reputation points
2021-09-16T12:32:30.093+00:00

I have a xml file which is in the below format. I was not able to read xml:key2 tag.

The input file is as below

<category id="262">
<category-name key1="cat" xml:key2="ca">parrquia</category-name>
<category-name key1="eng" xml:key2="en">parish</category-name>
<category-name key1="fra" xml:key2="fr">paroisse</category-name>
</category>

and i am able to read category id, category-name.key1 however i am not able to get the column category-key.key2 data using ADF v2. Is there any settings to be done for getting the value of that.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments
Answer accepted by question author
  1. Krishna Nagesh Kukkadapu 116 Reputation points
    2021-10-05T16:47:40.76+00:00

    Sorry for the late response. yes the above information worked out for us.
    Thanks

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
    2021-09-17T18:10:16.593+00:00

    Hi @Krishna Nagesh Kukkadapu ,

    Thanks for using Microsoft Q&A !!

    How are you reading the xml in ADF ? I have tried reading similar xml format using Copy Data activity and I could able to Import schemas correctly and able to save the data to a blob storage as well.

    133119-image.png

    133203-image.png

    Thanks
    Saurabh

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.