[R] Getting XML Data From Sharepoint

[David Wagle]

I'm trying, and so far failing, to extract data from a very large
SharePoint list.

I have a URL for getting XML from sharepoint:

http://
<site>/_vti_bin/owssvr.dll?Cmd=Display&List={GUID}&Query=*&XMLDATA=TRUE

When I do something like the following:

require(XML)
require(RCurl)

URL <- "http://
<site>/_vti_bin/owssvr.dll?Cmd=Display&List={GUID}&Query=*&XMLDATA=TRUE"
data = xmlParse(readLines(URL)


I get an authorization error back:

Error in file(con, "r") : cannot open the connection
In file(con, "r") : cannot open: HTTP status was '401 Unauthorized'

No problem I modifty things to this:

URL <- "http://
<site>/_vti_bin/owssvr.dll?Cmd=Display&List={GUID}&XMLDATA=TRUE"
w <- getURL(URL, userpwd="uname:password")
myDataFrame <- xmlParse(w)
.
.
.

it returns with:

internal error: Huge input lookup
internal error: Huge input lookup
Extra content at the end of the document
....

Help!

Thanks in advance

-- 
David A. Wagle
cell: 952-607-71741
linkedin: http://www.linkedin.com/in/davidwagle/

	[[alternative HTML version deleted]]