Writing JSON from a Sharepoint DVWP

I’m currently doing some work in Sharepoint 2007 for a client. I’ve found it a bit of a struggle as I am hampered in the things I can do, I can’t really develop any code for the installation. This has left me using Sharepoint 2007 designer and the out-of-the-box functionality.
I slowly realized that it might be best to use Sharepoint’s data view web part (DVWP) to output JSON formatted data and do most of the heavy lifting is javascript using a MVC application framework. Having come to that conclusion it has taken me days to persuade Sharepoint to do that. The default behaviour of a DVWP is to output a HTML table, and finding all the parameters to stop this was a mission. However, this article has a brilliantly clear summary of what you need to do.
I can now write small aspx pages that output the data I need for my web application, and then forget about Sharepoint for the rest of the implementation.

Leave a Comment