Consume yahoo webservice from .net code

Question

I have the following code where I am trying to make a request for a yahoo api request to return whoid. But I can not generate XML for the request, the error is not displayed.

private string getWOEID()
{
 string woeID = "";

  String reqUrl = "http://query.yahooapis.com/v1/public/yql?q=select%20woeid%20from%20geo.places%20where%20text%3D%22farnborough%2Champshire%2Cuk%22&format=xml";
  HttpWebRequest wr = (HttpWebRequest)WebRequest.Create(reqUrl);
  //load the response into a response object
  WebResponse resp = wr.GetResponse();
  // create a new stream that can be placed into an XmlTextReader
  Stream str = resp.GetResponseStream();
  XmlTextReader reader = new XmlTextReader(str);
  reader.XmlResolver = null;
  // create a new Xml document and loading feed data in to it
  XmlDocument xmldoc = new XmlDocument();
  xmldoc.Load(reader);

  //query the woeid with using linq 
  XDocument doc = XDocument.Parse(xmldoc.ToString());
  woeID = doc.Descendants()
                .Where(element => element.Name == "woeid")
                .FirstOrDefault().Value;
  return woeID;

    }

Is there a better / easier way to generate an XML document from the response?

Many thanks,

Answer 1

Much easier than I thought, see http://developer.yahoo.com/dotnet/howto-xml_cs.html

    String reqUrl = "http://query.yahooapis.com/v1/public/yql?q=select%20woeid%20from%20geo.places%20where%20text%3D%22farnborough%2Champshire%2Cuk%22&format=xml";

XmlDocument doc = new XmlDocument();
 doc.Load(reqUrl);

Answer 2

You can omit the step of creating an XmlDocument by passing an XmlTextReader instance to the XDocument.Load () method.