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]]