I've been trying to use a list's RSS feed as a datasource to read its data, treating the rss url like you would a normaly xml file. The URL of the list is http://server/_layouts/listfeed.aspx?List={E85B8062-3A4D-40C6-8D75-4D9FD5265D50}. I was expecting this url to return xml representing all the records in the list but it links to a subscription page. I know I can browse to many RSS feeds and view the xml in my browser. I was expecting to do this with a lists RSS feed. Am I misunderstanding how this works?
When I subscribe to the feed with Outlook, Outlook is somehow able to retrieve the individual record and fields. Can anyone tell me how I can use this URL to get at all the records and columns?
I'm trying to find a quick way to import list data into a data warehousing project.