Windows 10: Problem facing in reading xml files from one adls folder but able to read that file from...

While I am reading files from adls one folder in databricks I am unable to read.xml files, I am getting error that Failure to initialize configuration for storage account sdfgh.dfs.core.windows.net: Invalid configuration value detected for fs.azure.account.keyInvalid configuration value detected for fs.azure.account.key.But if I am reading that same file in df = spark.read.format"csv" or df = spark.read.format"text" I amable to read that file .Also I have installed the library of Maven which is "com.databricks.spark.xml" .From another folder of adls I can read this .xml file with this synt

:)

 

How can I read xml files without the coding

What you need is a "viewer" program (as opposed to an editor) that can read and display XML files. Here are a couple of articles the review or list multiple viewer programs. Find the one that works best for you:

8 Best XML Viewer / XML File Reader [2024 Guide]

Comparison of XML editors - Wikipedia

3 Ways to View XML Files - wikiHow

 

how to read value from xml file

Hi heenamaniyar,



I go through the post carefully, if you would like to open and read a XML file, you may open it from Text editor like Notepad on Windows or Office apps like Word and Excel(For more information: Open XML Formats and file name extensions (microsoft.com)).

If you would like to extract specific elements from the XML file, you may try JavaScript in the link that may help: Read XML file using javascript - Stack Overflow



However, as the category here is on Office related usage, if you would like to start a web activity from a XML file, I would suggest you post in Newest 'xml' Questions - Stack Overflow with XML tags where you may get more professional help. Thanks for your understanding!

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​





Best Regards,

Clark

 

how to read value from xml file

Hi Clark ,

I am trying to read in data from an API with Azure Data Factory. First I need to call a log in method, which provides an XML response. I need to take an element from that XML and put it into my next API call to get the data that I need.

Currently I am using the Copy data tool to call the log in method and save the XML to adls storage. How do I now read an element of that XML into a variable?

If there is a better way of doing this then please advise, but I would still like to know how to read an XML element into a variable.

Edit: here is the XML being returned. I need to capture the SessionID.

below is my xml file