I have a requirement to extract sharepoint list data through batch ETL process (Ab Initio). I have seen syntax using C# and VB sciprts. But is there any easy way by calling the the webservices using http or https URLs. If yes, whether it requires any custom build in sharepoint to provide the web service or any built in services can be used ?

  • Such as REST?
    – wjervis
    Commented Dec 11, 2014 at 21:02

1 Answer 1


As far as I know you can use the built-in web services from any kind of processes that supports basic HTTP operations. Of course, that does not mean a simple HTTP GET (I assume you mean that when you write

using http or https URLs

) as you should post the details of the request in the body.

I suggest you to check the methods of the Lists web service, implement a client using C#, that performs the required action, capture the network traffic using Fiddler, and reproduce the same traffic from Ab Initio. If it does not support calling SOAP web services directly, then you should create some kind of wrapper interface to make the data you need available via "pure" HTTP(S) URLs.

  • just a question. Does sharepoint authenciation is different for web services and accessing the portal. I am trying to figure out whether i can use the credentials to call web services users just have access to the sharepoint portal.
    – swami
    Commented Dec 12, 2014 at 16:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.