Getting XML Data from a web site

• Ron Schioldager

  SSC Enthusiast

  Points: 105

  More actions

  July 19, 2005 at 12:49 pm

  #363236

  We currently have an internal web site we use to get information about our customers.  For example, I got to the site, enter in a customer SSN and the page returns info about the customer in XML, such as name, address etc....  I think I have fugured out how to take the XML: doc and get it into the database.   however I can't figure out how to programtically send the http request to the page a retrieve the XML.  

   

  Any thoughts?

• DanKennedy

  Hall of Fame

  Points: 3736

  More actions

  July 20, 2005 at 1:59 am

  #575732

  This is a very simple example of a vbscript that periodically requests an xml file at a url and saves the contents. Obviously if you are using .net you should rather be looking at HttpWebRequest class. I've included a code sample for that also but it will obviously have to be taken out of context.

  Hope one of these helps point you in the right direction.

  --------------------------------------------------------------------------

  vbscript

  --------------------------------------------------------------------------

  option explicit

  on error resume next

  dim f

  dim fs

  dim fso

  dim filedat

  dim url

  url = "http://www.qmissxmlservice.org.uk/XMLFiles/XmlServiceCMGD/content.xml"

  filedat = "D:\XML\TestFileName_CMGD.XML"

  set fs=createobject("Scripting.FileSystemObject")

  set f=fs.opentextfile(filedat,8,true)

  Set theHTML = CreateObject("MICROSOFT.XMLHTTP")

  theHTML.open "GET", url, False

  theHTML.send

  f.write theHTML.responseText

  f.close

  --------------------------------------------------------------------------

  --------------------------------------------------------------------------

  C# .net

  --------------------------------------------------------------------------

  public XmlDocument LoadFeed(bool forceReload)

  {

  XmlDocument rssDoc = null;

  if(forceReload || cacheObj==null || (cacheObj!=null && cacheObj.IsInCache()==false))

  {

  WebProxy proxyObject = System.Net.WebProxy.GetDefaultProxy();

  GlobalProxySelection.Select = proxyObject;

  proxyObject.Credentials = CredentialCache.DefaultCredentials;

  HttpWebRequest request = (HttpWebRequest)WebRequest.Create(_url);

  HttpWebResponse response = (HttpWebResponse)request.GetResponse();

  XmlTextReader reader = new XmlTextReader(response.GetResponseStream());

  reader.XmlResolver = null;

  rssDoc = new XmlDocument();

  rssDoc.Load(reader);

  }

  if(cacheObj!=null && rssDoc==null)

  rssDoc = cacheObj.GetFromCache();

  else

  {

  if(cacheObj!=null)

  {

  cacheObj.CacheKey = cacheObj.MakeNewCacheKey(this.Url);

  cacheObj.SaveToCache(rssDoc);

  }

  }

  return rssDoc;

  }

  }

  --------------------------------------------------------------------------

  ---

  Dan
  www.firstcs.co.uk