Converting a Sharepoint List into XML

By peter.stilgoe

Hello there! If you are new here, you might want to subscribe to the RSS feed for updates on this topic.

This easiest way is to use the URL below & insert your list GUID

http://servername/site/_vti_bin/owssvr.dll?Cmd=Display&List=*YOURUNIQUELISTID*&XMLDATA=TRUE

To get the GUID of the list you need to go into the list & click ‘Settings’ -> ‘List Settings’. Now if you look at your URL you will see something like:

/_layouts/listedit.aspx?List=%7B7B476F98%2D1075%2D4A6D%2D8F63%2D4C754B3F41FC%7D

The URL is encoded so you will need to replace “%7B” with “{” and “%7D” with “}” and “%2D” with “-” so the end result would look something like: {7B476F98-1075-4A6D-8F63-4C754B3F41FC}

More From pstilgoe

Sharepoint / MOSS / WSS, Sharepoint Lists, xml commento

3 Comments data

November 16th, 2009

About... peter.stilgoe

This author published 482 posts in this site.
Sharepoint, InfoPath, K2, Nintex, Business Process Mapping, Business Intelligence, Automation, ECM, Document Management, Document Imaging, Internet Marketing & Online Business Consultant Email / MSN: pstilgoe@hotmail.com LinkedIn: Pete Stilgoe - Sharepoint Consultant

3 Comments

At 2010.04.21 07:41, How to autopopulate Infopath fields using Sharepoint list data | Sharepoint Consultant, Automation & Stuff said:

[...] By peter.stilgoe 1) Get your Sharepoint list into XML format [...]

[Reply]
At 2010.07.06 14:23, Populating an Infopath dropdown using a specific Sharepoint list view | Sharepoint Consultant, Automation & Stuff said:

[...] The way round this is to create you data connection using an XML source, use this link to find out how to view your list data as XML and get the source URL – http://www.petestilgoe.com/2009/11/converting-a-sharepoint-list-into-xml/ [...]

[Reply]
At 2011.03.30 17:13, Michael said:

Once I have defined the InfoPath data source using the XML from the SharePoint List and View, I’m having a hard time using the XML data source to populate the drop-down list box. In the Select a Field or Group dialog, the rs:data, z:row is rejected because it says that I must select a repeating group or field…. Any further details are much appreciated. Thanks.

[Reply]

[Reply]

Previous post - Next post

PeteStilgoe.com

"Be fearful when others are greedy, be greedy when others are fearful.”

Converting a Sharepoint List into XML

By peter.stilgoe

More From pstilgoe

About... peter.stilgoe

Share

3 Comments

About Me

Tag Cloud

Recent Posts

Recent Comments

Categories

Archive

Sharepoint / MOSS / WSS