• 0

PHP talking to SharePoint


Question

I'm looking at getting PHP talking to SharePoint... Initially just posting an item to a SharePoint list from PHP.

SharePoint exposes a number of web services (http://niklouch.activesharepoint.com/phpint/_vti_bin/Lists.asmx?WSDL).

I am trying to talk to these using SOAP (via the nuSoap PHP library).

I believe I am using it correctly but possibly not. The response I am getting from the server is debugged here (http://www.niklouch.com/sites/work/php_sp/test2.php) - basically:

  Quote
"Server was unable to process request. --> The root element is missing."

Has anyone worked on something like this before?

For reference:

SharePoint SOAP WSDL: http://niklouch.activesharepoint.com/phpin...Lists.asmx?WSDL

SharePoint WebService: http://niklouch.activesharepoint.com/work/...UpdateListItems

My debugged output: http://www.niklouch.com/sites/work/php_sp/test2.php

Code:

<?PHP

/* Requires the NuSOAP library */
require_once('nusoaplib/nusoap.php');

/* Username and password, separated by a colon. Domain may be optional, depending on setup */
$auth = "webtest:webtest";

/* Location of the Lists.asmx file */
$wsdl = "http://niklouch.activesharepoint.com/phpint/_vti_bin/Lists.asmx?WSDL";

/* GUID of the list */
$guid = "{48A2B76C-2E23-4ED0-9C12-DC98897C228A}";

/* Setup NuSOAP. Sharepoint requires NTLM Authorization. Recent version of CURL needed for this */
$client = new nusoap_client($wsdl, true);
$client->setCredentials("","","ntlm");
$client->setCurlOption(CURLOPT_USERPWD, $auth);

$err = $client->getError();
if ($err) {
	echo '<h2>Constructor error</h2><pre>' . $err . '</pre>';
	echo '<h2>Debug</h2><pre>' . htmlspecialchars($client->getDebug(), ENT_QUOTES) . '</pre>';
	exit();
}

/* XML for the request */
$xml = '
<UpdateListItems xmlns="http://schemas.microsoft.com/sharepoint/soap/">t;listName>'.$guid.'</listName>
	<updates>
		<Batch>
			<Method ID="1" Cmd="New">
				<Field Name="ID" />
				<Field Name="Title">My Title</Field>
			</Method>
		</Batch>
	</updates>
</UpdateListItems>
';

/* Invoke the Web Service */
$result = $client->call('UpdateListItems', $xml);

/* Check for Errors */
if(isset($fault)) {
	echo("<h2>Error</h2>". $fault);
}

/* Debugging Info */
echo("<h2>Request</h2><pre>" . htmlspecialchars($client->request, ENT_QUOTES) . "</pre>");
echo("<h2>Response</h2><pre>" . htmlspecialchars($client->response, ENT_QUOTES) . "</pre>");
echo("<h2>Debug</h2><pre>" . htmlspecialchars($client->debug_str, ENT_QUOTES) . "</pre>");

unset($client);
?>

Link to comment
https://www.neowin.net/forum/topic/773860-php-talking-to-sharepoint/
Share on other sites

8 answers to this question

Recommended Posts

  • 0

Oh I'm posting 1 item with just a title, nothing more. Never really got into the whole web services over PHP thing. May need to try another webservice (simpler) first and then move on to this...

But it's been set as my "Get this working for your 1st day of work" task for my new job! :s

  • 0

Yeah, I'm not the best person to ask either, however the above worked once for me doing something similar.

Maybe the problem is that you are only posting a title? I'm assuming theres a content section this title is applied to (unless its a name of a directory or something?) That could possibly be what its relating to when returning 'The root element is missing'.

EDIT: Btw, what the new job? Your confused smiley makes it seem your not sure why they asked you do this.. are you being asked to do this by those who think that because your in the I.T department somewhere you should know all everything computer related ever?

  • 0

LOL - no I made a sharepoint list that just contains a title, nothing more. And the confused smiley is sorta because this was not advertised as part of the role, but I mentioned I was also a SharePoint developer, and so they sprung into "Wow - we want a SharePoint connector for our product"... Makes sense totally, but PHP and SharePoint are two languages never destined to play well together, and "SharePoint development" to me has always been within either the SharePoint environment or at least with .net based languages - so I can use the .net libraries...

It would be a VERY cool piece of engineering, and I know how I wanna make it - but it just isn't seeming to work.

  • 0

I'm really not sure.. Never tried using PHP with any other language yet, just starting to really get to grips with PHP itself only recently.

This is probably wrong, but when I go to activesharepoint.com it asks me to login to web2003.activeisp.com, is it possible your wsdl variable is set to the wrong target?

  • 0

Is it necessary for NuSoap library that the sharepoint site must allow anonymous access? Well, I want to do the same but I am not able to do. I searched alot and alot but didn't find any solution which worked for me :(

Can you please help.

Thanks

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • I mean at this point, why even have a desktop? Just open a browser window full screen and send her to her homepage. Access to anything she needs right there. Could be on Linux, could be on Android, heck could also be on Windows 11. No one would know!
    • Will be replacing my last 2 Windows 10 PC's in household ASAP, if they could upgrade now i've done it already. Main Desktop runs Windows 11 already, that ones all set. Now just to get the other 2 all set asap
    • I think you answered why it gets so much attention in your comment. It's designed to make Windows accessible to everyone! It's a core component of the Windows UI, and 30 years of its existence is why it remains such a key component and receives so much attention to this day!
    • I agree with your points, particularly around workflows. But I think this is a symptom of the way Microsoft plans, builds, and releases its OS's, not about its UI ideals itself. It has historically been large jumps in UI changes between releases, XP > Vista > 7 > 8 were ALL significant changes in how we performed tasks. Then Win10 was released and updated twice a year with minor changes. This was somewhat nice as the changes were often minimal, however as it looked like the same OS for the most part, when something did change (like the start menu), it was a bit confusing for people who didn't understand that they had actually been upgraded, and why just this one key part of their workflow had changed. But I believe that was too slow, and didn't allow their future designs to be played out in that release structure. So the "last Windows version ever" was superseded with a new UI and overhauled once more. It too has changed quite a bit in its 4 years, but I think there needs to be an understanding of that change, which I guess we have in the "24H2" version numbering, but not in the marketing that most users know. The most consistent and clear communication of changes I think is done with MacOS. While I'm not a fan of Apples software, their clear and consistent release schedule, and progressively planned changes to the OS is easy to understand, leading towards a well thought out goal. Their users understand the branding of the big updates, and that changes will occur when they update, yet these are more subtle than changes we see in Windows 7 > 8 > 10 > 11 releases. On that, Windows 10/11 version updates just get lost in the vast collection of update types in Windows Update, and as such most users wouldn't know if the were on 22H2, 23H2 or 24H2, or even know what those meant. My thoughts are that Microsoft will drop the Win11/Win12 branding once Windows 10 has finally died. And hopefully, make it a bit more consistent with feature/UI updates sticking to an improved branded version/year release rather than "moments" or just randomly enabled elements in a random monthly update. Until then, even us tech users rarely know what features are in what release and if we will see it on our own computers. Get with it MS!
  • Recent Achievements

    • Reacting Well
      pelaird earned a badge
      Reacting Well
    • Mentor
      The Werewolf went up a rank
      Mentor
    • First Post
      Myriachan earned a badge
      First Post
    • Week One Done
      DrRonSr earned a badge
      Week One Done
    • Week One Done
      Sharon dixon earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      601
    2. 2
      ATLien_0
      214
    3. 3
      +FloatingFatMan
      169
    4. 4
      Michael Scrip
      151
    5. 5
      Som
      151
  • Tell a friend

    Love Neowin? Tell a friend!