How to get splist data in Json formate

Question

Dear Team,

How to get splist data in Json formate.Cusatom lists also

---

prboss

Answer 1

Hi,

try this blogpost: Well Formatted XML Data From SharePoint List 
or: SharePoint List to JSON

Best regards,
Radovan

---

Please let me know if my post was helpful.

Answer 2

Hi thank you for this.

Is there any possibilites to access the splist   JSON data using webservices

for custom lists also

---

prboss

Answer 3

You have to combine two things: getting list items with WebService (http://msdn.microsoft.com/en-us/library/lists.lists.getlistitems(v=office.12).aspx) from WS you get XmlNode with data.

and JSONConvertor method with process XmlDocument and generates json string (http://www.codepursuit.com/?p=375)

---

Please let me know if my post was helpful.

Answer 4

Hi,

In addition to Radovan reply, here is blog to get list item in jason format using webservice:

http://blogs.technet.com/b/sharepointdevelopersupport/archive/2012/07/27/code-sample-on-demand-fetching-of-sharepoint-list-items-using-jquery.aspx

Hope it could help

---

Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

Whenever you see a reply and if you think is helpful, click "Vote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Mark As Answer