Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a Sharepoint list with 9000 records. If I use any value between 1 and 5000 with RowLimit=n then the list pulls through successfully. But if I leave it at 0 or any value above 5000 then it does not work.
Are there limitations? how can this be overcome?
LOAD
fields,
FROM [https://.sharepoint.com/_vti_bin/owssvr.dll?XMLDATA=0&RowLimit=0&List={XXXXXXXX-7C41-XXXX-XXXX-XXXXXXXXXXXX}] (XmlSimple, Table is [xml/data/row]);
A cursory Google search suggests this is a Microsoft limitation.