An interactive way of learning that will help you visualize core concepts so that you can be more effective when taking your AWS certification exam. Built for students by a student to help them understand the concepts that they are being taught.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
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
This is about my first experience with programming Arduino.
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month3 days, 21 hours left to enroll
630 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.