Welcome

Sharepoint lead is a place where you can read about interesting topics related to sharepoint, and you can also post comments and suggessions.

Friday, June 22, 2012

How to use soapUI to review ListData.svc


Introduction

​SoapUI is a free tool that can be used to test out of the box ListData.svc service provided by sharepoint. This service is available at /_vti_bin/ListData.svc for any of your sharepoint site. Here is how we can try it out using SoapUI.

Step 1: Install sopa UI and click on File > New SoapUI Project. Add some project name and check "Add REST Seervice:" like shown in following figure and then click OK



Step 2: After clicking on OK another window will open like following, just click on OK




Step3: New REST resource window will appear. In resource name enter site url and in resource path/endpoint provide list/document library name and click on "Extract params" button. Following is the screen that shows sample data.




Step4:That will automatically create a new request called Request 1.This request will automaticlaly detect endpoint and path to your list/document library. If it is not, just click on"-no endpoint set-" and click on add new endpoint. Enter site url in the dialog again.



Step5: Maximize "Request 1" window in soapUI. In botton left corner you will see " ... ", click on it and you will be able to provide sharepoint authentication details there.



Step6: Once you are done with authentication details you can click on execute icon at top left corner of "request 1" window (marked in above figure) to execute the request and you will be able to see response at right hand side window.

Step7: ListData.svc can also return json data in response out of the box. Just try to provide accept = application/json like shown in figure below:


Conclution:
SoapUI is a super simple too to try out and it will be really help to review xml/json data while you are planninig to consume it with jQuery. 


5 comments:

  1. Thanks for the article. Are you using Sharepoint on cloud or Sharepoint On prem? I am having issues authenticating to Sharepoint on prem using NTLM/Kerberos, SoapUI is stuck at authenticating.

    ReplyDelete
    Replies
    1. Hey sree,

      I tried this in on prem. Look at step 5, it will allow you to enter domain, username and password.

      In case of cloud (sharepoint online) you can leave domain blank and enter username and password of your cloud account. It should work.

      Let me know if any need any other help.

      Delete
    2. I tried it and it fails. I followed this article which fixed my issue. probably with NTLMV1 vs NTLMv2

      http://stackoverflow.com/questions/914899/testing-webservice-with-soapui-windows-authentication

      Delete
    3. Thanks for posting the solution link. Good luck with whatever you are doing.

      Delete
  2. Hi, Can you show an example of a request to add an attachment to the list item?

    ReplyDelete