Can you call a sharepoint webservice with CF 7.1? I made the change you suggested but I can't get past an initial error "Could not generate stub objects for web service invocation" which I believe means it is not event getting to the wsdl. I have spent two days trying to find a working snippet of code on the internet for doing ANYTHING with sharepoint from CF. I got nothing. Here is the code that gives me the aforementioned error:


<Cfset ws=createobject("webservice","http://websitename/sites/sitename/_vti_bin/lists.a...;)>
<Cfdump var="#ws#">

Yes, I restarted CF. Typing into my browser works fine too except:

From my desktop I do not have to authenticate in the browser. When I do it from the server (local admin logged in, CF running under with another domain users credentials), I do have to autheticate with my domain credentials.

I don't know how to make this authentication happen in my code. The examples I have seen set the username password AFTER creating the webservice. I can't get that far.

There will be a detailed article in the next edition of FAQU. Make sure you subscribe.

Jenn:

Check your email.

Todd

Steve,
I don't know if you're still following this post or not, but I bet your problem is one that I was having earlier. If the WSDL is actually using NTLM then you can't authenticate against it and you can't get the stubs to generate. To solve the problem access the WSDL from your browser and save it into a folder on your webserver. Then point your CFObject call to the file you've saved on your server. This will let the stubs generate but since the WSDL came off the sharepoint server originally all the method calls will still go to sharepoint. (I can't remember whose blog I found this tidbit on but it sure does work).

PS...not sure this makes a difference for your particular problem, but as a general rule I'd suggest using the TCP monitor when working with any web service. It will totally save your sanity sometimes...

http://livedocs.adobe.com/coldfusion/7/htmldocs/ww...

Thanks to some idiots who are comment spamming this post non stop I have closed it for comments. If you would like to discuss this post please use my contact page.

Hey Todd, thanks for another great blog entry. Quick question about this (seems the comments are open again).

You mention getting success with the approach Tom offered, but it seems you had to (as he said) pass the username/password. What if we don't want to prompt the user for that (or retrieve it from somewhere we stored it for them)? Is there any way to pass it along on their behalf?

I've also asked on Tom's blog entry you point to, but I don't know if he'll respond.

Also, did you ever do a part 2? I couldn't find it.

I noticed the new FAQU is out, but I don't see this subject in any of the headlines. (Or any articles by Todd). Do you know if it's in there? I want to make sure before I subscribe.

Thanks for the info todd, I've been trying to link these things together for a while now without success. As jenn mentioned, I stored the WSDL on the CF server to get around the authentication but i cant seem to pull any webservice functions.

Could you or jenn post (or email) some more tips on how you guys got this working? It would be a life saver!

Hello,

There is so little info on the internet about this, I will try and ask you my question right here.

I have a little colfusion page that I view through a Page Viewer Webpart in Sharepoint. The only thing I want from sharepoint is the logged in user. I found bits of code to get that, but it's always from .NET, I don't know how to do the same thing with Coldfusion. Any ideas?
Thanks,

Hello,

I've started working on a project that will interact with Sharepoint, but unfortunately my company is stuck with ColdFusion 7. So, no cfsharepoint tag for me... When did the FAQU article come out?

Thanks,

Hi Jen, did you figure out how to invoke the UpdateListItems method?

Hi Jen,

Thank you for taking the time to reply. We are trying to use UpdateListItems to do two things: add an item to a list and upload a document to a document library. However, we haven’t been able to figure out how to format the second parameter of the method. As you mentioned earlier, according to the documentation, it looks pretty simple: a piece of XML.

<Batch>
<Method ID='1' Cmd='New'>
<Field Name='Title'>First item of list</Field>
</Method>
</Batch>

However, no matter how we set the xml argument, we get the error message “Web service operation UpdateListItems with parameters {parameters_here} cannot be found.” We tried adding some inline java but got a type mismatch error.
I would truly appreciate it if you could shed some light into how we need to pass this parameter...

Once again, thanks.

I've been asked again how we did this and I still ahven't had time to really put together a package that I can post. but here's an example update List Item function that we're actually using which may point o you int he right direction. (wonder if putting code in here is going to work).

<cffunction name="updateListItems" output="true" returnType="String" hint="Updates the items in a list or adds new items based upon the contents of the updates array">
<cfargument name="listGuid" type="String" required="Yes" hint="The GUID of the list being updated">
<cfargument name="listVersion" type="String" default="1" hint="the List version, in case there is more than one">
<cfargument name="viewName" type="String" default="" hint="The view to use when updating... normally left blank">
<cfargument name="updates" type="any" required="Yes" hint="The actual update information in the form of a struct">

<cfscript>
var doc = "";
var batchXML = "";
var updateElement = "";
var curMethod = "";
var finalParam = arrayNew(1);
var xmlResponse = "";
var xPath="/ns1:Results/ns1:Result/ns1:ErrorText"; //Look for the error text nodes
var errorList = "";
</cfscript>

<CFOBJECT type="java" class="com.microsoft.schemas.sharepoint.soap.UpdateListItemsUpdates" name="Element" />
<CFOBJECT type="java" class="javax.xml.parsers.DocumentBuilderFactory" name="DocumentBuilderFactory"/>
<CFOBJECT type="java" class="org.apache.axis.message.MessageElement" name="MessageElement">

<cfscript>
doc = DocumentBuilderFactory.newInstance().newDocumentBuilder().newDocument();
batchXML = doc.createElement("Batch");

batchXML.setAttribute("OnError", "Return");
batchXML.setAttribute("ListVersion", "1");
batchXML.setAttribute("ViewName", "");
</cfscript>
<cfloop from="1" to="#ArrayLen(updates)#" index="i">
<cfset curMethod = buildMethodElement(doc,updates[i][1],"#i#",updates[i][2])>
<cfset batchXML.appendChild(curMethod)>
</cfloop>
<cfscript>
finalParam[1] = MessageElement.init(batchXML);
updateElement = Element.init(finalParam);
</cfscript>

<cfinvoke webservice="#sList#" method="UpdateListItems" returnVariable="Results">
<cfinvokeargument name="listName" value="#arguments.listGUID#"/>
<cfinvokeargument name="updates" value="#updateElement#">
</cfinvoke>

<cfset xmlResponse = Results.get_any()>
<cfset xmlResponse = xmlParse(xmlResponse[1])>
<cfset FieldArray = XmlSearch(xmlResponse,xPath)>

<cfloop from="1" to="#ArrayLen(FieldArray)#" index="i">
<cfset errorList = FieldArray[i].XmlText>
</cfloop>
<cfreturn errorList>
</cffunction>

You will need to get the appropriate java classes on your class path. We did that by sticking them in a folder called stubs and putting the whole thing on the path. You can get the clases from the Sharepoint server I believe.

Good luck