0

I am trying to load XML Data into Azure Table using ADF V2. There is a connector for XML as a Source but for some reason I am not able to get the data loaded as requirement.

enter image description here enter image description here

So I tried to load the Entire XML into a stage table Column (XML TYPE) so that I can use XQuery to get the desired Result but unable to.

Any Ideas to load and query data by any other means using Azure Stack?

Improve this question

1 Answer 1

Reset to default
0

I am not sure as to what is the error which you were , but i did uploaded the below dummy XML data on to SQL .

XML dummy

<note>
<record>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</record>
<record>
<to>Tove1</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</record>
<record>
<to>Tove2</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</record>
</note>

This is my output .

enter image description here

Please make sure is done correctly , this is the thing which worked for me . enter image description here

Please let me know if you have any questions .

Thanks Himanshu

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Himanshu. Try with the XML that I have shared. The one that you have shared is pretty straightforward to use in ADF.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.