Pingback from  Links (1/10/2007) « Steve Pietrek’s SharePoint Stuff

Pingback from  double density design  -   » Bookmarking the web - w02/2008

can we get this to work with blogs?  the out of the box reader does not support authenticated feeds and problem is anon access is not something my client feels comfortable with.   I've tried sp360 reader webpart but it won't accept the blog feed url as even being valid.   so I came across this which seems to be an alternative over rss anyway.  

I look forward to hearing from you

Judy

Judy,

I'd have to say no as even this requires normal Sharepoint Authentication.

What you could probably do is create an "rss.aspx" page somewhere that accepts an anonymous request, then creates a new WebRequest using a NetworkCredential that is recognized by SharePoint, fetches the SharePoint RSS feed, then streams that directly back to the caller.  Not pretty perhaps, but simple and quick to implement.

Good Luck!

I can't get this to work on a List that contains a Lookup field.  I just get a blank page in the browser. Have you encountered this too? Any ideas?

Sarah,

Try doing a View Source on that blank page.  I bet it is chock full-o-xml :)

Thank you!  This is a great tip for developers.

can i filter the data that goes exported to EXCEL? For XML works but not for EXCEL...

Other aproach, importing xml in EXCEL using this builded url and after i add item in list, in excel i do refresh i get error "An xml table cannot be resized to accomodate the data"

Where do you get the listGUID?

David, I think you lost your bet. I am experiencing the same issue as Sarah on lists with lookup fields, and "view source" just shows an empty page...

I actually came across your post because I was doing a search on this issue.

I have used this technique but I am having difficulty with requesting field names that have spaces in them. For example I need a field to come back in the XML called "Work Request Name".  If fields are separated by spaces does anyone know the syntax to specifying this name on the URL?  Assume, I do not have rights to change the name or create views.  One would think it would be something like "Query=Name%20Status%20Work_Request_Name&XMLDATA=True" ...  unfortunately that doesnt work.  Anyone a method?

David, awesome help! Thanks so much! After doing what you recommended I was able to further expand on a technique.  So what I have found worked well is to simply run:

http://[yourserver]/_vti_bin/owssvr.dll?Cmd=Display&List={your list GUID}&Query=*&XMLDATA=TRUE

That will then return you all of the avaialbe fields in the list providing the name="..."  for each one of them.

So for example up in the schema portion of the response you will have the list of all the field attributes, for example:

<s:AttributeType name="ows_Additional_x0020_Detail_x0020_Ne" rs:name="Additional Detail Needed?" rs:number="9">

Now it SEEMS you can simply eliminate the preceding "ows_" and then replace all of the _ with %5f hex values.  Therefore the field in this case would be referenced on the URL as:

Additional%5fx0020%5fDetail%5fx0020%5fNe

in the URL.  Now I also noticed when making the SOAP webService call using the section ViewFields you simply remove the preceding ows_ and did not UrlEncode the _:

<ViewFields>

<FieldRef name="Additional_x0020_Detail_x0020_Ne" />

</ViewFields>

Again thanks for the great help and hopefully others find this useful!

Brett, the "*" option is great for lists with only a few columns but in lists with 75+ columns (like most of the ones I seem to deal with) that brings back way more data than I need.

I'm glad it is working for you, though!

Right, the lists I am dealing with have more than 75+ as well.  That is really why I needed the specific field listing technique.  I was only using the "*" option to quickly get all the internal names of the columns available for potentially listing.

Thanks again!

Is there a way to figure out the link to an attached file using this approach? Because when this generates the XML it shows that there is an attachment but does not show the URL to the attachment.

Thanks! Hope you can help me with this dilemma

Hello David

I have use various format as mentioned by various authos above. I tested each different options and it is working correctly, only problem I notieced that every xml is returning only first 18 columns, and in most of the views I am having 20-22 column, but it is returning only first 18 columns.

Anything I am missing here?

Avi

One more thing I noticed, that I tested with diferent views and everytimes it is returning same columns in xml i.e.  only 18 columns, infact in 1 view there are only 4 column, but when I displat its xml it is returning all 18 columns.

ANy clue

Sarah T-O:

I found that it is not an issue of being a lookup collum but if you allow multiple selections.

Any one know any work arounds for this?

How do you retrieve items in a folder using this method please?

Pingback from  Using the RPC method via the URL Protocol &laquo; Path to SharePoint

Hi David

I've browsing thru the comments on your blog and found them very interesting. I also need some help when it comes to sharepoint.

i am retrieving data from a list in sharepoint as OuterXml. i specified the fields i want and created a dataset and a datatable which i bind to the dataset.

i then loop thru the data in the list and display the fields which i bind to a repeater. what i find though is that one of the fields doesnt keep the format of the data as captured/stored in sharepoint. is there a way i can format the xml to look exactly as on sharepoint itself.  here is a snippet of my code:

listService = new GITS.Lists();

               listService.Credentials = new System.Net.NetworkCredential("username", "password", "domain");

               listService.Url = "mysite/.../Lists.asmx";

               xmlDoc = new System.Xml.XmlDocument();

               viewFields = xmlDoc.CreateElement("ViewFields");

               query = xmlDoc.CreateNode(XmlNodeType.Element, "Query", "");

               queryOptions = xmlDoc.CreateNode(XmlNodeType.Element, "QueryOptions", "");

               query.InnerXml = "<Where><Eq><FieldRef Name='Meeting_x0020_Date' /><Value Type= 'DateTime'>" + sDate + "</Value></Eq></Where>";

               queryOptions.InnerXml = "<IncludeAttachmentUrls>TRUE</IncludeAttachmentUrls>";

               viewFields.InnerXml = "<FieldRef Name='Report_x0020_Subject'/><FieldRef Name='Agenda_x0020_Item_x0020_No_x002e'/><FieldRef Name='Attachments'/><FieldRef Name='Resolution_x0020_Comments'/>";

               nodeListItems = listService.GetListItems(strSubCouncilName, null, query, viewFields, "5000", queryOptions, null);

               DataSet _ds     = new DataSet();

               DataTable dt    = new DataTable();

               string _xml = nodeListItems.OuterXml;

               xmlDocResult        = new XmlDataDocument();

               XmlDocument _doc    = new XmlDocument();

               XmlDataDocument xdd = new XmlDataDocument();

               xdd.LoadXml(nodeListItems.OuterXml);

               _ds.Tables.Add("newTableName");

               dt = _ds.Tables["newTableName"];          

               dt.Columns.Add("ResolutionDetails", typeof(String));

               XmlNodeList rows = xdd.GetElementsByTagName("z:row");

               foreach (XmlNode listItem in rows)

               {

                   DataRow newRow = dt.NewRow();

                   if (listItem.Attributes["ows_Resolution_x0020_Comments"] != null)

                   {

                       newRow["ResolutionDetails"] = listItem.Attributes["ows_Resolution_x0020_Comments"].Value;

                   }

                   dt.Rows.Add(newRow);

               }

               ResultsRepeater.DataSource = dt;

               ResultsRepeater.DataBind();

           }

An example of how the data displays on the web:

Below how it was captured/displayed orginally in sharepoint:

This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph.

This is the SECOND paragraph. This is the SECOND paragraph. This is the SECOND paragraph. This is the SECOND paragraph. This is the SECOND paragraph.

When it displays on the web it displays like this:

This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph. This is the FIRST paragraph. This is the SECOND paragraph. This is the SECOND paragraph. This is the SECOND paragraph. This is the SECOND paragraph. This is the SECOND paragraph.

Using the above approach data of only first page (100 items) are returned, How can I get all the records in one go?

I'm trying to use this in an xml webpart so i can apply an xsl to a list. But when i test the link it works fine but after applying the page says it can't load the xml.

I am wondering how this can be extended to include the structure of subfolders within a list. for example:

<ds:data>

  <z:row 'some file'

  <z:row 'some file'

  <z:row 'some folder'

       <z:row 'some file'

       <z:row 'some file'

  <z:row 'some folder'

       <z:row 'some file'

       <z:row 'some file'

Hi,

I'm getting the following error message when I try to access a SharePoint list via the URL method. But the page exists. The GUID I'm using is the one I see on that page.

Here's the error:

The page you selected contains a list that does not exist.  It may have been deleted by another user.  Click "Home" at the top of the page to return to your Web site.

Pete

I'm looking to use this approach and we've a field in our list which is set to "append to existing data" we've configured the view so that the field is part of the view, though it only shows the last entry in the field and not the entire contents? i.e. if I have an item and enter "some information" in to field, and then edit this item, and change a different field when I use this method (or indeed the export to excel method) nothing is returned where we'd expect "some information" to be shown?

has anyone come accross this before, or have any tips on how to get all of the contents of this field to be included in the export?

Great post, just what I was looking for. Note: the parameters are case sensitive. This may help others like avoid some frustration.

How are folders and sub-folders dealt with using this?

I'm operating in an evironment where I have several different site collections.  I need to be able to pull a filtered version of an All Items view from a list in one site collection to a site in another site collection.  The only way I can figure to pull that information is by building custom views for each of the list views I need to pull over, and then moving the data via an RSS view.  Any suggestions on another cleaner, more flexible way of doing this?

Why am I having issues viewing the data in the "Data Source Details" in Designer.  I have no issues viewing it in my browser.

I am a beginner in Sharepoint. I am wondering whether I can write data into sharepoint list from an XML file or external website. I would appreciate for your comments and suggestions.

Does anyone know what features use XML as their transport layer in SharePoint and/or What APIs are provided by SharePoint for 3rd parties?

I'm having the same issue as Sarah, Christophe, and Scott.  I get nothing but a blank page for lists that have multiselect lookups.  View Source shows nothing.  Has anyone found a way to get this to work?

I've added the RootFolder parameter to the url to get a subfolder so for example to get a folder or subfolder you can use the link

http://<portal>/<sites>/_vti_bin/owssvr.dll?Cmd=Display&List={GUID}&RootFolder=<url path to Folder or SubFolder>&XMLDATA=TRUE

also, if you want to query specific fields just add the Query=*, Query=<Field> parameter to the URL.