Friday, November 19, 2010

OWSSVR: How to get data and schema easily from the list

 Sometimes you need to look at the actual schema of the list (even you want to do it fast and on Prod) or you need to get data in XML format and do something else with it.
Easy and fun ! - use WSS RPC - through URL protocol send a HTTP GET request:
 THE LIBRARY -owssvr.dll

ex: to get schema of the list  - http://WebApp/[site]/_vti_bin/owssvr.dll?Cmd=ExportList&List={ListGuid} 
get data from the list -  http://WebApp/[site]/_vti_bin/owssvr.dll?Cmd=Display&List={ListGuid}&Query=*&XMLDATA=TRUE

Details are on: Exploiting the value of OWSSVR.DLL in SharePoint 3.0