This project is read-only.

SharePointAccessClient

This class provides the functions around Sharepoint lists.
JET or ACE required.

Properties
Name Summary
Engine JET or ACE.
ListGUID a string of Sharepoint list GUID.
URL a string of Sharepoint site URL.
ViewGUID a string of Sharepoint list view GUID.


Methods
SharePointAccessClient.ChangeEngine($enginestr)
SharePointAccessClient.ExecuteSelectQuery($sql)
SharePointAccessClient.GenerateConnectionString($write)
SharePointAccessClient.SetListGUID($listguid)
SharePointAccessClient.SetURL($url)
SharePointAccessClient.SetViewGUID($viewguid)

ex)
$myurl = "http://myserver/";
$mylistname = "mylist";
$viewname = "myview";

# get list guid
$listretriever = (new SharePointGetListCollection).Initialize($myurl).SetCredential();
$listguid = $listretriever.GetListGUIDFromListName($mylistname);

# get view guid
$viewretriever = (new SharePointGetViewCollection).Initialize($myurl, $mylistname).SetCredential();
$viewguid = $viewretriever.GetViewGUIDFromViewName($viewname);

# create an instance and set engine
$sacc = (new SharePointAccessClient).ChangeEngine("ACE");
# set url, list GUID and view GUID
$sacc = $sacc.SetURL($myurl).SetListGUID($listguid).SetViewGUID($viewguid);
# execute query
$ret = $sacc.ExecuteSelectQuery("select * from list");
# check the result out
$ret;

See also SharePointGetListCollection, SharePointGetViewCollection.

Last edited Mar 2, 2013 at 1:32 PM by Tom__S, version 3

Comments

No comments yet.