accessing owssvr.dll in sharepoint 2010

Question

I am creating a task scheduler for Windows Server 2008 to send mails for events whose date has passed and I am trying to access the task list using owssvr.dll with the following code in sharepoint 2010 to get the event date. I am unable to execute this task even if it is set to run with admin privileges.

I get the 401 unauthorized exception.

string reqUrl = url + @"/_vti_bin/owssvr.dll?Cmd=Display&List=" + ListId + "View=" + ViewId + "&XMLDATA=TRUE&noredirect=true&Query=*&FilterField1=Event_x0020_Date&FilterValue1=" + String.Format("{0:u}", DateTime.Today);
            HttpWebRequest httpwebRequest = (HttpWebRequest)HttpWebRequest.Create(reqUrl);

            HttpWebResponse httpwebResponse = (HttpWebResponse)httpwebRequest.GetResponse();
            XmlDocument doc = new XmlDocument();
            //Store Response to Stream
            Stream streamResponse = httpwebResponse.GetResponseStream();

            StreamReader streamResponseReader = new StreamReader(streamResponse);

            //Store ResponseStram As String.

            string strResponseBody = streamResponseReader.ReadToEnd();
            doc.LoadXml(strResponseBody);

I tried setting System.Net.CredentialCache.DefaultNetworkCredential and it worked in my development server. But when i changed the url property and deployed it in stage environment it gave me a 404 error. I am able to access this url in browser without any issue.

System.Net.WebException: The remote server returned an error: (404) Not Found.

Answer 1

I made something similar recently.

Ensure that you pass valid credentials, the url is valid and your user has the "use remote interfaces" permission (you don't need anything more except, obviously at least read access to the targeted list)

    WebRequest request = WebRequest.Create("http://{relevant SPWeb url}/_vti_bin/owssvr.dll?Cmd=Display&List=b82d7210-4730-412d-91f7-54f5ed46c699&XMLDATA=TRUE");
    listService.Credentials = new NetworkCredential("admlbar", "Epsilon$123", "domain");
    WebResponse response = request.GetResponse();
    StreamReader sr = new StreamReader(response.GetResponseStream());
    String responseAsString = sr.ReadToEnd().Trim(); // do whatever you need with the response through Linq2xml, etc.

Answer 2

Try :

XmlDocument  myXMLDocument = new XmlDocument();

myXMLDocument.Load(reqUrl);