So we built better training tools.
-Hands-on Labs
-Instructor Mentoring
-Scenario-Based Tests
-Dedicated Cloud Servers
All at your fingertips. What are you waiting for?
Course Of The Month
3 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Using XMLHTTP to retrieve XML document and parsing the result
Posted on 2004-04-17
I am trying to remotely retrieve an XML document using XMLHTTP (in ASP), and then parse out a particular tag. The problem I am running into is that Internet Explorer seems to want to parse the XML document on its own.
For example, the following code:
Set HttpReq = Server.CreateObject("Micro
url = "http://eutils.ncbi.nlm.nih.gov/entrez/eutils/efetch.fcgi?db=PubMed&report=medline&mode=xml&id=15088295"
HttpReq.Open "GET", url, False, username, password
HttpReq.Send
buffer = HttpReq.responseText
Set HttpReq = Nothing
I then simply want to print out what is in the buffer:
Response.Write buffer
However, internet explorer is interpreting it as an XML document and processing it on it's own. Is there anyway to have the browser just treat is as a regular HTML document?
The reason I want to do it this way, is I get an error message back from Internet Explorer "An invalid character was found in text content. Error processing resource "
This is interesting because by typing the URL above directly into your browser, it displays fine. But using the code above, it generates this error message. (It is being tripped specifically on the Affiliation tag, when it comes the the letter 'e' with the accent over it).
Any idea what is going on? Or how to instruct Internet Explorer to handle the data as pure text, not XML??
Thanks very much.
For example, the following code:
Set HttpReq = Server.CreateObject("Micro
url = "http://eutils.ncbi.nlm.nih.gov/entrez/eutils/efetch.fcgi?db=PubMed&report=medline&mode=xml&id=15088295"
HttpReq.Open "GET", url, False, username, password
HttpReq.Send
buffer = HttpReq.responseText
Set HttpReq = Nothing
I then simply want to print out what is in the buffer:
Response.Write buffer
However, internet explorer is interpreting it as an XML document and processing it on it's own. Is there anyway to have the browser just treat is as a regular HTML document?
The reason I want to do it this way, is I get an error message back from Internet Explorer "An invalid character was found in text content. Error processing resource "
This is interesting because by typing the URL above directly into your browser, it displays fine. But using the code above, it generates this error message. (It is being tripped specifically on the Affiliation tag, when it comes the the letter 'e' with the accent over it).
Any idea what is going on? Or how to instruct Internet Explorer to handle the data as pure text, not XML??
Thanks very much.
[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
2
6 Comments
I think I have found out what to do...
When doing the parse with XMLDOM, I set the validateOnParse parameter to false, and then it doesn't complain about invalid characters.
This seems to be a work-around for my original problem, so I would still appreciate any suggestions on a better way to do this.
When doing the parse with XMLDOM, I set the validateOnParse parameter to false, and then it doesn't complain about invalid characters.
This seems to be a work-around for my original problem, so I would still appreciate any suggestions on a better way to do this.
The question that still stands is how to get Internet Explorer, or any other browser, to treat the data I print out as an HTML document and not an XML document. I tried setting the ContentType but that did not seem to work.
Don't use:
Set HttpReq = Server.CreateObject("Micro
This uses MSXML 2.0, and its *not* server-safe. Use MSXML 3 or 4:
Set HttpReq = Server.CreateObject("Msxml
Set HttpReq = Server.CreateObject("Msxml
Then to fix your other problem, you're probably having problems with invalid characters because of the encoding switch when you use responseText to a string. Do it this way:
HttpReq.Send
Response.ContentType = "text/xml"
HttpReq.responseXML.save Response
If you want it sent as plain text, use:
Response.ContentType = "text/plain"
But I prefer to see the XML, so that I know it's getting parsed correctly. Using
HttpReq.responseXML.save Response
should get the encoding problem fixed. Unfortunately, the NIH site doesn't specify the encoding in their XML. Shame on them! It appears that the encoding is actually UTF-16, but using responseText probably strips the Byte Order Mark from the text, so that IE can't figure out what the encoding is. Use the responseXML property, and call the save method on it to save it to the Response object.
Regards,
Mike Sharp
Set HttpReq = Server.CreateObject("Micro
This uses MSXML 2.0, and its *not* server-safe. Use MSXML 3 or 4:
Set HttpReq = Server.CreateObject("Msxml
Set HttpReq = Server.CreateObject("Msxml
Then to fix your other problem, you're probably having problems with invalid characters because of the encoding switch when you use responseText to a string. Do it this way:
HttpReq.Send
Response.ContentType = "text/xml"
HttpReq.responseXML.save Response
If you want it sent as plain text, use:
Response.ContentType = "text/plain"
But I prefer to see the XML, so that I know it's getting parsed correctly. Using
HttpReq.responseXML.save Response
should get the encoding problem fixed. Unfortunately, the NIH site doesn't specify the encoding in their XML. Shame on them! It appears that the encoding is actually UTF-16, but using responseText probably strips the Byte Order Mark from the text, so that IE can't figure out what the encoding is. Use the responseXML property, and call the save method on it to save it to the Response object.
Regards,
Mike Sharp
Thanks Mike.
Some followup questions:
After I issue the command "HttpReq.responseXML.save Response" then what happens to the XML data I retrieved? Because the next step in the code that I did not show was:
'Microsoft XML parser
dim objXML
Set objXML = Server.CreateObject("Micro
objXML.async = False
objXML.validateOnParse = False
objXML.LoadXML(****what goes here now??****)
And from there I am going to parse out just the fields I want using the command "objXML.documentElement.se
I also tried using the command "Response.ContentType = "text/xml" but that seems to mess up the HTML document that is printed out. Internet Explorer is thinking that I want to output an XML document, when in fact, I am outputing an HTML document from the ASP (with the data stored in the selected XML tags as part of the HTML).
I hope this makes sense.
Some followup questions:
After I issue the command "HttpReq.responseXML.save Response" then what happens to the XML data I retrieved? Because the next step in the code that I did not show was:
'Microsoft XML parser
dim objXML
Set objXML = Server.CreateObject("Micro
objXML.async = False
objXML.validateOnParse = False
objXML.LoadXML(****what goes here now??****)
And from there I am going to parse out just the fields I want using the command "objXML.documentElement.se
I also tried using the command "Response.ContentType = "text/xml" but that seems to mess up the HTML document that is printed out. Internet Explorer is thinking that I want to output an XML document, when in fact, I am outputing an HTML document from the ASP (with the data stored in the selected XML tags as part of the HTML).
I hope this makes sense.
Once again I posted too hastily. Turns out the problem I was running into was the MSXML component did not work on my localhost, but worked once uploaded to my host provider.
Featured Post
You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.
With xMatters, you'll never miss a beat.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
The Problem
How to write an Xquery that works like a SQL outer join, providing placeholders for absent data on the outer side? I give a bit more background at the end.
The situation expressed as relational data
Let’s work through this. I’ve …
Introduction
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Suggested Courses
Course of the Month3 days, 14 hours left to enroll
690 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.