473,405 Members | 2,272 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Create XML Doc from XML returned by URL

BLH
Hi,

I am using a 3rd party product that returns XML when
calling its exe through a URL. For instance, the
following URL calls this exe in Internet Explorer and
returns valid, well formed XML and displays it in the
browser:

http://server/app/livelink.exe?
func=search&where1=report&outputformat=xml

My goal: I want to send this http request in VB.NET code,
in ASP.NET and store the XML that is returned in an XML
document.

So, my general question is: How can I store the XML
returned by an http request, in an XML Document?

Thanks in Advance,
BLH
Nov 11 '05 #1
3 7189
You can store it in an xml document if that is what you will need to do with
it.

if you are just going to store it in a database or drive, just use a string.

you can just use the response.GetResponseStream() of the HttpWebResponse

and pass it into the Load method of the XmlDocument.

XmlDocument doc = new XmlDocument();
doc.Load(response.GetResponseStream())

be careful, if it is not valid xml, it can throw an error.

--
Joe Feser [Xml MVP]
http://www.fesersoft.com/
..Net, XML, XSLT, SQL
Free Code, Articles and Information.
"BLH" <bl*@rtp.com> wrote in message
news:0a****************************@phx.gbl...
Hi,

I am using a 3rd party product that returns XML when
calling its exe through a URL. For instance, the
following URL calls this exe in Internet Explorer and
returns valid, well formed XML and displays it in the
browser:

http://server/app/livelink.exe?
func=search&where1=report&outputformat=xml

My goal: I want to send this http request in VB.NET code,
in ASP.NET and store the XML that is returned in an XML
document.

So, my general question is: How can I store the XML
returned by an http request, in an XML Document?

Thanks in Advance,
BLH

Nov 11 '05 #2
BLH
Thanks for the reply Joe. Unfortunately, the exe that is
returning the XML must be doing things a bit strangely.

When I actually stream the contents of GetResponseStream()
to a file, instead of the actual XML, I get the following:

<HTML>
<!-- File: redirectmeta.html -->
<HEAD>
<TITLE>Livelink - Redirection</TITLE>
<META HTTP-EQUIV="Refresh" CONTENT="0;
URL=/us_ll9103tst/livelink.exe?
func=search&amp;lookfor1=allwords&amp;where1=repor t&amp;out
putformat=xml">
</HEAD>
</HTML>
<!-- End File: redirectmeta.html -->

It seems as if the livelink.exe is going through a two
step process where it:

1) accepts the request and sends a redirection response.
2) whatever it redirects the request to processes the
request and sends the XML as the response.

I am getting the response for #1 above, which is the
redirection... I think.

Anyway, thanks for the reply.
BLH
-----Original Message-----
You can store it in an xml document if that is what you will need to do withit.

if you are just going to store it in a database or drive, just use a string.
you can just use the response.GetResponseStream() of the HttpWebResponse
and pass it into the Load method of the XmlDocument.

XmlDocument doc = new XmlDocument();
doc.Load(response.GetResponseStream())

be careful, if it is not valid xml, it can throw an error.

--
Joe Feser [Xml MVP]
http://www.fesersoft.com/
..Net, XML, XSLT, SQL
Free Code, Articles and Information.
"BLH" <bl*@rtp.com> wrote in message
news:0a****************************@phx.gbl...
Hi,

I am using a 3rd party product that returns XML when
calling its exe through a URL. For instance, the
following URL calls this exe in Internet Explorer and
returns valid, well formed XML and displays it in the
browser:

http://server/app/livelink.exe?
func=search&where1=report&outputformat=xml

My goal: I want to send this http request in VB.NET code, in ASP.NET and store the XML that is returned in an XML
document.

So, my general question is: How can I store the XML
returned by an http request, in an XML Document?

Thanks in Advance,
BLH

.

Nov 11 '05 #3
yes it is. For some reason they set up the site for a web browser, not a
service.

Is the status returned a 302?

--
Joe Feser [Xml MVP]
http://www.fesersoft.com/
..Net, XML, XSLT, SQL
Free Code, Articles and Information.
"BLH" <bl*@rtp.com> wrote in message
news:08****************************@phx.gbl...
Thanks for the reply Joe. Unfortunately, the exe that is
returning the XML must be doing things a bit strangely.

When I actually stream the contents of GetResponseStream()
to a file, instead of the actual XML, I get the following:

<HTML>
<!-- File: redirectmeta.html -->
<HEAD>
<TITLE>Livelink - Redirection</TITLE>
<META HTTP-EQUIV="Refresh" CONTENT="0;
URL=/us_ll9103tst/livelink.exe?
func=search&amp;lookfor1=allwords&amp;where1=repor t&amp;out
putformat=xml">
</HEAD>
</HTML>
<!-- End File: redirectmeta.html -->

It seems as if the livelink.exe is going through a two
step process where it:

1) accepts the request and sends a redirection response.
2) whatever it redirects the request to processes the
request and sends the XML as the response.

I am getting the response for #1 above, which is the
redirection... I think.

Anyway, thanks for the reply.
BLH
-----Original Message-----
You can store it in an xml document if that is what you

will need to do with
it.

if you are just going to store it in a database or drive,

just use a string.

you can just use the response.GetResponseStream() of the

HttpWebResponse

and pass it into the Load method of the XmlDocument.

XmlDocument doc = new XmlDocument();
doc.Load(response.GetResponseStream())

be careful, if it is not valid xml, it can throw an error.

--
Joe Feser [Xml MVP]
http://www.fesersoft.com/
..Net, XML, XSLT, SQL
Free Code, Articles and Information.
"BLH" <bl*@rtp.com> wrote in message
news:0a****************************@phx.gbl...
Hi,

I am using a 3rd party product that returns XML when
calling its exe through a URL. For instance, the
following URL calls this exe in Internet Explorer and
returns valid, well formed XML and displays it in the
browser:

http://server/app/livelink.exe?
func=search&where1=report&outputformat=xml

My goal: I want to send this http request in VB.NET code, in ASP.NET and store the XML that is returned in an XML
document.

So, my general question is: How can I store the XML
returned by an http request, in an XML Document?

Thanks in Advance,
BLH

.

Nov 11 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: MD | last post by:
I am trying to create a dynamic SQL statement to create a view. I have a stored procedure, which based on the parameters passed calls different stored procedures. Each of this sub stored procedure...
9
by: jab | last post by:
Je veux lier (join) une table qui se trouve dans une database avec une qui se trouve dans une autre database. Les 2 databases sont sur le même serveur en l'occurence DB2/NT 7.2.9. J'ai créé un...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
8
by: ASP Yaboh | last post by:
I have an ArrayList of data gathered from a database. I want to create a web page from this data by creating a <table>, each cell in each row displays the appropriate data. One of those cells in...
1
by: mohins | last post by:
I am getting the error while I am trying to connect to Oracle with my code in ASP.NET, this code is working in another machine, but it fails in my laptop, giving the below error. Could not create...
3
by: Rahul B | last post by:
Hi, I have a user UCLDEV1 which is a part of staff and a group(db2schemagrp1) to which i have not given any permissions. The authorizations of that user are shown as db2 =get authorizations...
13
by: =?Utf-8?B?UGV0ZXI=?= | last post by:
I want to create a new column in a datatable from two existing columns. I have no problem to create the new column using the datatable.columns.add method. The problem is the value of the new...
1
by: Paul Childs | last post by:
Hi folks, I'll start off with the code I wrote... (ActivePython 2.4 on Windows XP SP2) ------------------------------- class FlightCondition(object): lsf = vto =
6
by: Alvin SIU | last post by:
Hi all, I have a table in Db2 v8 like this: Team Name Role ------ -------- --------------------- A Superman Leader A Batman Member A WonderWoman Member B ...
37
by: sarega | last post by:
Hi, Here I have an array returned that is returned in responseText from the server. Based on the output that is returned by the server I have to dynamically create a checkbox. function...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.