Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
17 replies
Subscribers
6 subscribers
Views
8386 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
Sharepoint Web Services I cannot see anywhere in the documentation on how t
Mike Lonsdale
over 11 years ago
Sharepoint Web Services
I cannot see anywhere in the documentation on how to add an entry to a list. Has anyone managed this and can point me in the right direction?
Thanks
Mike...
OriginalPostID-87319
OriginalPostID-87319
Discussion posts and replies are publicly visible
0
shelzle
over 11 years ago
I do a lot of SharePoint integration but mostly reading items from lists. What version of SP are you running. In 2010 and even better in 2013 there are REST APIs. I am going to do some POCs on the REST interfaces in the comming weeks. But when reading the documentation this should be relatively easy.
So to answer your question: Not OOTB. Use the REST API or the Lists Webservice
msdn.microsoft.com/.../lists(v=office.12).aspx
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mike Lonsdale
over 11 years ago
Hi, we are on SP 2010 and are using the List Webservice which doesn't provide, when called from Appian, the ability to add a list item.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shelzle
over 11 years ago
Only to be shure. We are talking about the Webservices provided by Microsoft and not the ones from Appian out of the SharePoint Addon.
Do you know this one
msdn.microsoft.com/.../lists.lists.updatelistitems.aspx
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mike Lonsdale
over 11 years ago
Hi I'm using the Call Web Service Smart Service and then Appian.SharePoint.Lists.asmx?wsdl to connect to Sharepoint and get a list of web services.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shelzle
over 11 years ago
OK. Using the HTTP request plugin you can call the URL
yourSP/.../Lists.asmx
. As body of the request you provide something like this
"<?xml version=""1.0"" encoding=""utf-8""?>
<soap:Envelope xmlns:soap=""
www.w3.org/.../soap-envelope""
xmlns:soap1=""
schemas.microsoft.com/.../"">
<soap:Header/>
<soap:Body>
<soap1:GetListItems>
<soap1:listName>" & pv!list_id & "</soap1:listName>
<soap1:viewName>" & pv!view_id & "</soap1:viewName>
</soap1:GetListItems>
</soap:Body>
</soap:Envelope>"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shelzle
over 11 years ago
SP then returns some XML which you can parse with xpathsnippet. Using other XML functions than "GetListItems" you can call any function provided by MS.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mike Lonsdale
over 11 years ago
Thanks, I've given it a quick try and it works. I would have preferred an OOTB solution that works with the Call Web Service Smart Service that way we can progress a 'No Coding' solution. Anyone at Appian listening?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shelzle
over 11 years ago
AFAIK there is coming something next year. I created some small utility models that encapsulate the WS calls. This way it is still not a nice solutions but it works.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mike Lonsdale
over 11 years ago
Once again, Thanks. Probably have to wait for Appianworld. Would you be prepared to share your utility models (I won't bother you for ongoing support) to give us a jump start?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shelzle
over 11 years ago
You are welcome :-) Sharing the model is no problem. When you provide me an email address I'm going to send it to you.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>