Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Solved
Access data in XML file using MSXML2.DOMDocument
Posted on 2015-01-26
I have a document formatted like this:
<TestResult xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<TestName>1234</TestName>
<TestID>P1</TestID>
<Score>70</Score>
<Learner>
<ID>5846</ID>
<Name>Fred Smith</Name>
</Learner>
</TestResult>
I'm loading it as follows:
Set objXMLHttp = CreateObject("MSXML2.Serve
objXMLHttp.Open "GET", strURL, False
objXMLHttp.send
' This works but strReturn is formatted using { and : characters not as xml/soap
strReturn = objXMLHttp.responseText
Set xmlDoc = CreateObject("MSXML2.DOMDo
xmlDoc.async = False
xmlDoc.LoadXML strReturn
xmldoc as a Parse error, invalid at top level of document
How do I access the score and learner id ?
<TestResult xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<TestName>1234</TestName>
<TestID>P1</TestID>
<Score>70</Score>
<Learner>
<ID>5846</ID>
<Name>Fred Smith</Name>
</Learner>
</TestResult>
I'm loading it as follows:
Set objXMLHttp = CreateObject("MSXML2.Serve
objXMLHttp.Open "GET", strURL, False
objXMLHttp.send
' This works but strReturn is formatted using { and : characters not as xml/soap
strReturn = objXMLHttp.responseText
Set xmlDoc = CreateObject("MSXML2.DOMDo
xmlDoc.async = False
xmlDoc.LoadXML strReturn
xmldoc as a Parse error, invalid at top level of document
How do I access the score and learner id ?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
5 Comments
I solved the parse error by setting the content type to XML, it was defaulting to JSON. The doc now looks loaded ok so I just need to know the syntax to access specif elements in the test and candidate. The example is a single record but I like to know how to access using a loop as well in case we make files with more records. Thanks
Thanks
I had a look at that yesterday , its generic code for traversing a structure rather than specific access to known elements.
I figured it eventually by trial an error though :)
- For top level test data
xmlDoc.getElementsByTagNam
- for data in the Learner record
xmlDoc.getElementsByTagNam
I had a look at that yesterday , its generic code for traversing a structure rather than specific access to known elements.
I figured it eventually by trial an error though :)
- For top level test data
xmlDoc.getElementsByTagNam
- for data in the Learner record
xmlDoc.getElementsByTagNam
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Make the most of your online learning experience.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
- Networking Hardware-Other
- MultiMedia Applications
- Switches / Hubs
- Displays / Monitors
- ATEN Technology
- Hardware, Network Architecture, *Kernel-based Virtual Machine (KVM)
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Suggested Courses
Course of the Month5 days, 6 hours left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.