1
votes

I've looked at a lot of the previous questions asked about sharepoint and accessing objects via web-services, and I am pretty convinced that tasks can be accessed through the Lists interface.

Can anybody please verify this for me?

Also, if anyone has any examples of this I would be very grateful. I'm not a Sharepoint guy but I need to connect to an instance just to retrieve task objects.

2

2 Answers

4
votes

Assuming you want a code solution using Visual Studio and C#

Add a web reference to your SharePoint List Web Service [http://[server-url]/_vti_bin/lists.asmx]

Create a new class similar to the one below:

using System;
using System.Text;
using System.Xml;
using System.Text.RegularExpressions;
using System.Net;            

public class SharePointList
{

   public void ReadSharePointList()
   {
    SPList.Lists listService = new SPList.Lists();

            try
            {
                // Retreive the URL to the list web service from the application cache
                listService.Url = "http://[server-url]/_vti_bin/Lists.asmx";
                // Retreive the GUID for the sharepoint list
      // To find the GUID for your list, navigate to your SharePoint list and select Settings > List Settings.
      // The browser url will display http://[server-url]/_layouts/listedit.aspx?List=%7B7A4C9C52%2DE7E7%2D4582%2D926E%2DC70D048F9071%7D
      // The %7B7A4C9C52%2DE7E7%2D4582%2D926E%2DC70D048F9071%7D is your GUID that you need to transform 
      // %7B = {
      // %2D = -
      // %7D = }
      // e.g. %7B7A4C9C52%2DE7E7%2D4582%2D926E%2DC70D048F9071%7D = {7A4C9C52-E7E7-4582-926E-C70D048F9071}

                string listName = {YOUR LIST GUID HERE};

                // SharePoint Web Serices require authentication
                string serviceAccountID = [USERID];
                string serviceAccountPW = [PASSWORD];
                listService.Credentials = new NetworkCredential(serviceAccountID, serviceAccountPW);

                XmlDocument xmlDoc = new System.Xml.XmlDocument();

                XmlNode ndQuery = xmlDoc.CreateNode(XmlNodeType.Element,"Query","");
                XmlNode ndViewFields = xmlDoc.CreateNode(XmlNodeType.Element,"ViewFields","");
                XmlNode ndQueryOptions = xmlDoc.CreateNode(XmlNodeType.Element,"QueryOptions","");

                ndQueryOptions.InnerXml = "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>" + 
                                          "<DateInUtc>TRUE</DateInUtc>";

                ndViewFields.InnerXml = "<FieldRef Name=\"Title\" />" +
                                        "<FieldRef Name=\"Search_x0020_Value\" />";

                // Form a query for the list items where Start Date is null or <= today's date
                ndQuery.InnerXml = "<Where>" +
                                    "<Or>" +
                                    "<IsNull><FieldRef Name=\"Start_x0020_Date\"/></IsNull>" +
                                    "<Leq><FieldRef Name=\"Start_x0020_Date\"/><Value Type=\"DateTime\"><Today/></Value></Leq>" +
                                    "</Or>" +
                                    "</Where>" +
                                    "<OrderBy><FieldRef Name=\"Sort_x0020_Order\" Ascending=\"TRUE\" /></OrderBy>";

                XmlNode ndListItems = listService.GetListItems(listName, null, ndQuery, ndViewFields, null, ndQueryOptions, null);

                foreach (XmlNode node in ndListItems)
                {
                    if (node.Name == "rs:data")
                    {
                        for (int f = 0; f < node.ChildNodes.Count; f++)
                        {
                            if (node.ChildNodes[f].Name == "z:row")
                            {
                                   //DO SOMETHING WITH YOUR RESULTS
                                string test = node.ChildNodes[f].Attributes["ows_Title"].Value, node.ChildNodes[f].Attributes["ows_Search_x0020_Value"].Value;
                            }
                        }
                    }
                }
            }
            catch (System.Web.Services.Protocols.SoapException ex)
            {
           //HANDLE ERRORS
            }
   }
}
2
votes

Yes, tasks are just another (albeit specialized) list. Where you may have a documents list at http://sharepoint/companydocs , the tasks exist (by default) at http://sharepoint/WorkflowTasks .